Need help in Multidimensional function

[Shamar]

Hello Gurus!!!

I need to use both year and month in  tuple function like below. since the measure should be in crosstab row.

tuple ( [Actual] , [Last_Year],[Month])

where [last_Year] = prevMember(lastchild([Time]))

          [Month] = [Namespace].[Dim].[Hierarchy].[Month]

As Month is a Memberset, am getting error saying that : "This parameter is 'level' type but is expected to be one of the following: 'member'. "

Please suggest a solution.

Thanks,
Shamar

[TheFrenchGuy]

Hello,

if it expects member for month, why not

Code Select Expand

children([Namespace].[Dim].[Hierarchy].[Month])

But this error refers to a "parameter" : you have prompts, isn't it ?

[Shamar]

Hello TheFrenchGuy,

  Thanks for your reply.

  We dont have prompts for year and month


Thanks,
Shamar

[MFGF]

Hello Gurus!!!

I need to use both year and month in  tuple function like below. since the measure should be in crosstab row.

tuple ( [Actual] , [Last_Year],[Month])

where [last_Year] = prevMember(lastchild([Time]))

          [Month] = [Namespace].[Dim].[Hierarchy].[Month]

As Month is a Memberset, am getting error saying that : "This parameter is 'level' type but is expected to be one of the following: 'member'. "

Please suggest a solution.

Thanks,
Shamar

Hi,

A tuple is the value of a measure at a specific intersection. What this means is that it is a measure value within context of a *single* member from each dimension in your cube. Because you are not specifying members from all dimensions here, under the covers the report will be using either the default member for each unreferenced dimension, or else the member(s) defining context wherever the tuple is used (ie the row/column members of your crosstab). You can't define a tuple using a set of members or a level, which is why you get an error when you use the month level in your expression. Can you explain what you are trying to do in more detail? Do you want the measure value aggregated for all months? Something else?

MF.