我的 SSAS 多维数据集中有以下数据
我需要使用 MDX查询。
在此示例数据中，当 Id 列的当前值不等于之前的值时，我需要获取 Weight 值作为 Result Id 列，否则为 0。
请在下面的屏幕截图中查找公式和示例结果以供参考。
我尝试使用 PrevMember 函数在 Mdx 中可用，但它不起作用。
请找到我尝试过的查询：
WITH MEMBER [Measures].[Expression1] AS IIF([Id].CURRENTMEMBER = [Id].CURRENTMEMBER.PrevMember,0,[Weight])
SELECT{ [Measures].[Expression1]} ON COLUMNS ,
NONEMPTY((TOPCOUNT( (Order((([class].[Id].[Id].ALLMEMBERS)),[class].[Id].CurrentMember.MemberValue,ASC)),101)),
{ [Measures].[Expression1]}) ON ROWS FROM [Model] CELL PROPERTIES VALUE, FORMATTED_VALUE, FORMAT_STRING
查询得到的结果是
I am having the following data in my SSAS cube
I need to get the value based on a comparison between the current value and the previous value using MDX query.
In this example data, I need to get the Weight value as Result when the current value of Id column is not equal to the previous value of Id column otherwise 0.
Please find the formula and the sample result in the below screenshot for reference.
I have tried to achieve the requirement using PrevMember function available in the Mdx but it is not working.
Please find the query I have tried:
WITH MEMBER [Measures].[Expression1] AS IIF([Id].CURRENTMEMBER = [Id].CURRENTMEMBER.PrevMember,0,[Weight])
SELECT{ [Measures].[Expression1]} ON COLUMNS ,
NONEMPTY((TOPCOUNT( (Order((([class].[Id].[Id].ALLMEMBERS)),[class].[Id].CurrentMember.MemberValue,ASC)),101)),
{ [Measures].[Expression1]}) ON ROWS FROM [Model] CELL PROPERTIES VALUE, FORMATTED_VALUE, FORMAT_STRING
The result am getting for the query is
发布评论