我该如何解决这个 MDX 问题？
我想比较以前的值和当前的值，但我的 MDX 查询给出以下错误
"The CURRENTMEMBER function expects a hierarchy expression for the 1 argument."
如何解决此问题？
我的 MDX 查询如下。请帮忙
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]
I want to be comparing the previous and current values, but my MDX query is giving the following error
"The CURRENTMEMBER function expects a hierarchy expression for the 1 argument."
How can I solve this problem?
My MDX query is below. please help
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]
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
将您的成员语句更改为以下内容：
currentmember 函数在层次结构中工作。
Change your member statement to the following:
The currentmember function works off of a hiearchy.