Tuple and current Member

[cognos05]

Hi All,

filter(members([Sales].[Item Numbers].[Item Numbers].[Level 3]),(Tuple(parent(currentMember([Sales].[Item Numbers].[Item Numbers])))) is missing))

Can anyone explain how will the above expression work

1st value of filter member will return all level 3 members form Item Numbers dimension.. Say for example    101,201,301,401,501,601,701,801,901.
Now how the second conditional expression will work ..
In my case certain users will have access to only say 401, and 801 and not its parent level 2.

will it take the each member 101,201,301,401,501,601,701,801,901. substitute inside currentMember and then find the parent and evaluate with tuple and if the tuple value is zero or null then it check for is missing.

I am not sure how that would work. If anyone could explain ,It would be great.

Thanks,
Nithya

[MFGF]

Hi All,

filter(members([Sales].[Item Numbers].[Item Numbers].[Level 3]),(Tuple(parent(currentMember([Sales].[Item Numbers].[Item Numbers])))) is missing))

Can anyone explain how will the above expression work

1st value of filter member will return all level 3 members form Item Numbers dimension.. Say for example    101,201,301,401,501,601,701,801,901.
Now how the second conditional expression will work ..
In my case certain users will have access to only say 401, and 801 and not its parent level 2.

will it take the each member 101,201,301,401,501,601,701,801,901. substitute inside currentMember and then find the parent and evaluate with tuple and if the tuple value is zero or null then it check for is missing.

I am not sure how that would work. If anyone could explain ,It would be great.

Thanks,
Nithya

Hi,

Dimensional sets and hierarchies are read iteratively when a report is being rendered (ie at any one moment in time during the rendering process, the report will be addressing one of the members in the hierarchy). The currentMember() function allows you to get access to that member from within your expression.

The tuple() function returns the value of a measure at an intersection (ie the value of a measure for the combination of one or more members). If a measure isn't specified, the currentMeasure is assumed.

The parent() function returns the member at the level above to which a specified member on this level belongs.

The filter() function allows you to reduce the number of members in a set based on an expression that evaluates to True or False.

So the expression above is retrieving the set of members from Level 3 of the Item Numbers hierarchy whose parent (I assume at Level 2) has a null value for whatever measure you are using.

Cheers!

MF.

[cognos05]

Hi MFGF,

Thanks for the clear explanation.

In my case for few products even if the parent of a level 3 member  has a value for the measure it returns as null...

SO I am displaying my parent level and the below expression in a data item one below other..

So I get two records..I am not sure if this is a bug.

Thanks,
Nithya

[MFGF]

Hi MFGF,

Thanks for the clear explanation.

In my case for few products even if the parent of a level 3 member  has a value for the measure it returns as null...

SO I am displaying my parent level and the below expression in a data item one below other..

So I get two records..I am not sure if this is a bug.

Thanks,
Nithya

Sorry - I'm not quite following.

for few products even if the parent of a level 3 member  has a value for the measure it returns as null...

Where do products fit into this? The expression you included looks like it is returning members on level 3 whose parent has a null measure.

What kind of data source are you using - is it a cube of some sort or DMR? If it's a cube, I'd doubt null values could be in there. Wouldn't the parent measure value simply be the aggregate of it's children's measure values? Would a parent ever have a null measure?

MF.

[cognos05]

I meant level 3 members as products. Its a TM1 Cube .Parent can have null value for its measure if the childrens also dont have values right.

Even this expression

filter(members(Level 3),Parent(currentMember(Product)) is missing)

even if the parent is present it still returns the filtered product for certain products.

is it a bug or should i try with something similar to is missing.

My requirement  is I will show level 4 and level 3 one below other . level 3 will have the above data item expression.

If users have access to only level 3 for a product then only that time this will be shown.


Any thoughts on why some level 3 items are shown even if its parents have values.

Thanks,
Nithya

[MFGF]

I meant level 3 members as products. Its a TM1 Cube .Parent can have null value for its measure if the childrens also dont have values right.

Even this expression

filter(members(Level 3),Parent(currentMember(Product)) is missing)

even if the parent is present it still returns the filtered product for certain products.

is it a bug or should i try with something similar to is missing.

My requirement  is I will show level 4 and level 3 one below other . level 3 will have the above data item expression.

If users have access to only level 3 for a product then only that time this will be shown.


Any thoughts on why some level 3 items are shown even if its parents have values.

Thanks,
Nithya

Have you tried being more accurate with your tuple? You haven't specified a measure - maybe you could try this?

Also, are you utterly sure about the nulls - does TM1 support nulls? Maybe you could try with zero?

MF.