MDX：平均使用
|
我已达到有关问题的基本MDX知识的极限，如果有人有想法，我们将竭诚欢迎您的帮助
情况
这是我要处理的层次结构。在我的fact_table中，我有一个[Measures]。[Sales]度量。
[All Management].[TemplateMgt].[CityMgt].[DistricMgt].[StoreMgt]
[All Management].[TMP-00.002].[London].[DistricMgt].[Shoe001]
[All Management].[TMP-00.002].[London].[DistricMgt].[Hat001]
[All Management].[TMP-00.002].[London].[DistricMgt].[Electronic001]
[All Management].[TMP-00.002].[Paris].[DistricMgt].[Shoe001]
[All Management].[TMP-00.002].[Paris].[DistricMgt].[Hat001]
[All Management].[TMP-00.002].[Paris].[DistricMgt].[Electronic001]
[All Management].[TMP-00.002].[Madrid].[DistricMgt].[Shoe001]
[All Management].[TMP-00.002].[Madrid].[DistricMgt].[Hat001]
[All Management].[TMP-00.002].[Madrid].[DistricMgt].[Electronic001]
Shoe001 | Hat001 | Electronic001
----------------------------------------------------
CUR|AVG|MAX | CUR|AVG|MAX | CUR|AVG|MAX
----------------------------------------------------
WITH MEMBER [Measures].[Cur] AS (...)
MEMBER [Measures].[Avg] AS (...)
MEMBER [Measures].[Max] AS (...)
SELECT {[Measures].[Cur], [Measures].[Avg], [Measures].[Max]} ON COLUMNS,
{FILTER({DESCENDANTS([All Management].CurrentMember, [StoreMgt])}, [All Management].Parent.Parent = \"Madrid\" } ON ROWS
from [MyCube]
没有找到相关结果
已邀请:
2 个回复
肉脓措伪
眠皇
WITH MEMBER [All Management].[Sales_AVG] AS AVG({[All Management].Members}, [Measures].currentMember) MEMBER [All Management].[Sales_MAX] AS MAX({[All Management].Members}, [Measure].currentMember) SELECT {[Measures].[Sales]} ON COLUMNS, {[All Management].Members, [All Management].[Sales_AVG], [All Management].[sales_Max]} ON ROWS FROM [MYCUBE] WHERE {DESCENDANTS([All Management].CurrentMember, [StoreMgt])}