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
Hello,
if it expects member for month, why not children([Namespace].[Dim].[Hierarchy].[Month])
But this error refers to a "parameter" : you have prompts, isn't it ?
Hello TheFrenchGuy,
Thanks for your reply.
We dont have prompts for year and month
Thanks,
Shamar
Quote from: Shamar on 23 Jul 2015 08:11:33 AM
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.