WITH
MEMBER [Rank] AS
Rank
(
[All Products].[Group 2].CurrentMember
,Order
(
[All Products].[Group 2].MEMBERS
,[Measures].[test]
)
)
SELECT
[Rank] ON COLUMNS
,[All Products].[Group 2].MEMBERS ON ROWS
FROM [cube];
错误:"排名"维度包含多个层次结构,因此必须显式指定层次结构。执行完成
使用 rank
的标准方法是在点击排名函数之前对集合进行排序:
WITH
SET [OrderedGroup] AS
Order
(
[All Products].[Group 2].MEMBERS
,[Measures].[test]
)
MEMBER [Rank] AS
Rank
(
[All Products].[Group 2].CurrentMember
,[OrderedGroup]
)
SELECT
[Rank] ON COLUMNS
,[All Products].[Group 2].MEMBERS ON ROWS
FROM [cube];
以下是我对之前关于Rank
的帖子的引用:
根据字母顺序将 RANK 函数应用于集合