还想请教一下。如果简单的这样写
with member [Measures].[a] as '([Measures].[Store Sales]+[Measures].[Store Cost])*[Measures].[Sales Count]'
select
{[Measures].[a]} on columns,
{[Store].[All Stores].[USA]} on rows
from sales
我的理解:显示出来的数字应该是所有USA地区数据做([Measures].[Store Sales]+[Measures].[Store Cost])*[Measures].[Sales Count]运算之后再做和
运行之后发现这个与在management studio中执行如下的SQL语句的结果不一样
select sum((
[Store Sales]+[Store Cost])*[Sales Count])
from sales where region=1;
不知道哪里出了问题,还是我的理解有问题
则,MDX为:
with member [Measures].[a] as '([Measures].[Store Sales]+[Measures].[Store Cost])*[Measures].[Sales Count]'
member [Measures].[b] as 'sum({[Time].[1997].[Q1],[Time].[1997].[Q2],[Time].[1997].[Q3]},[Measures].[Sales Count])'
member [Measures].[result] as '[Measures].[a]/[Measures].[b]'
select
{[Measures].[result]} on columns,
{[Store].[All Stores].[USA]} on rows
from sales
with member [Measures].[a] as '([Measures].[Store Sales]*[Measures].[Store Cost])*[Measures].[Sales Count]'
member [Measures].[b] as 'sum({[Time].[1997].[Q1],[Time].[1997].[Q2],[Time].[1997].[Q3]},[Measures].[Sales Count])'
member [Measures].[result] as '[Measures].[a]/[Measures].[b]'
select
{[Measures].[result]} on columns,
{[Store].[All Stores].[USA]} on rows
from sales