请教一个mdx表达式的写法
时间维度:年-季-月-日
度量:销售额
筛选条件:A店(共3家店)
请教高手,“各店平均销售额”(即当前时间维度级别下全部门店的平均销售)的mdx计算公式应该如何写啊?提示一下也行,谢谢 --WITH MEMBER [MEASURES].[平均] AS 'AVG( [Product].AllMembers , [Measures].[Store Sales] )'
WITH SET [商店] AS '{ [Store].AllMembers }'
SELECT [商店] ON COLUMNS,
{[Measures].[Store Sales]} ON ROWS
FROM Sales
WHERE ([Time].[1997])不好意思.
WITH MEMBER [MEASURES].[平均] AS 'AVG( [Product].AllMembers , [Measures].[Store Sales] )'
SET [商店] AS '{ [Store].AllMembers }'
SELECT [商店] ON COLUMNS, 数据挖掘研究院
{[MEASURES].[平均] } ON ROWS
FROM Sales
WHERE ([Time].[1997])

