
Untitled
By: a guest on
Jun 2nd, 2012 | syntax:
None | size: 0.64 KB | hits: 19 | expires: Never
How can I solve this MDX Problem?
"The CURRENTMEMBER function expects a hierarchy expression for the 1 argument."
with member [Measures].[Growth] as ([Date].[Calendar].[Month].CurrentMember,[Measures].[Internet Sales Amount])-([Date].[Calendar].[Month].CurrentMember.PrevMember,[Measures].[Internet Sales Amount])
select
{[Measures].[Internet Sales Amount],[Measures].[Growth] }
on columns,
{([Date].[Calendar].[Month].Members)}
on rows
FROM [Adventure Works]
with member [Measures].[Growth] as ([Date].[Calendar].CurrentMember,[Measures].[Internet Sales Amount])-([Date].[Calendar].CurrentMember.PrevMember,[Measures].[Internet Sales Amount])