tuple expression

[tarunkrdas2013]

tuple([Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY].[WTD_AS_OF_YESTERDAY],[TY Member Net Sales Amount])

Getting below parsing error when i am using below tuple expression:-

Invalid parameter '[__ns_0].[Fiscal Calendar0].[WTD_AS_OF_YESTERDAY].[WTD_AS_OF_YESTERDAY]' provided for 'tuple' at position '1' for 'dataItem="WTD Sales"'. This parameter is 'level' type but is expected to be one of the following: 'member'.

[bdbits]

A tuple is an intersection of members. It looks like you are providing levels in your expression. Which is what the error is telling you.

Within Report Studio, you can view members in the tree, and the MUN for a member can be seen in it's properties (right-click the member in the tree).

[MFGF]

tuple([Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY].[WTD_AS_OF_YESTERDAY],[TY Member Net Sales Amount])

Getting below parsing error when i am using below tuple expression:-

Invalid parameter '[__ns_0].[Fiscal Calendar0].[WTD_AS_OF_YESTERDAY].[WTD_AS_OF_YESTERDAY]' provided for 'tuple' at position '1' for 'dataItem="WTD Sales"'. This parameter is 'level' type but is expected to be one of the following: 'member'.

As Bob says, you're using a level in your expression in a place where a member is required. Can you explain what you are trying to achieve? Do you want the tuple of the measure and a specific member from this level? Do you want the aggregated measure across all the members in the level (eg the total)? Something else?

Cheers!

MF.

[tarunkrdas2013]

Thanks to both gentle man ,you are right i was placing level instead of member,here is the corrected expression

tuple ([TY Member Net Sales Amount],currentMember ([Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY]))