SSAS變量與MDX中變量區別

0
MDX如下:

WITH MEMBER [Measures].[chuhuo]
AS'CASE
WHEN [Measures].[訂單總量]=0 or isempty([Measures].[訂單總量])
THEN null
ELSE [Measures].[Shipping數量]/[Measures].[訂單總量]
END',
SOLVE_ORDER = 0 ,FORMAT_STRING = "Percent",VISIBLE = 1

SELECT NON EMPTY(HIERARCHIZE( { [Time].[月].&[2014-03-01T00:00:00] } )) ON COLUMNS,
NON EMPTY(HIERARCHIZE( { [Model].[Lob].&[4] } ) * {[Measures].[出貨達成率 ],[Measures].[chuhuo]}) ON ROWS
FROM [CUBE_SOAR]

查詢結果如下:

query.png


其中[Measures].[出貨達成率 ]是SSAS定義的變量
定義指令碼如下:
CREATE MEMBER CURRENTCUBE.[MEASURES].[出貨達成率 ]
AS CASE
WHEN [Measures].[訂單總量]=0 or isempty([Measures].[訂單總量])
THEN null
ELSE [Measures].[Shipping數量]/[Measures].[訂單總量]
END,
FORMAT_STRING = "Percent",
VISIBLE = 1;

同樣的定義爲什麽查詢出來的結果不一樣呢?
已邀请:
0

darkor2 2014-07-09 回答

根據數據庫數據查出來的值也是MDX自定義的chuhuo的值是對的。沒頭緒了,求幫忙!

要回复问题请先登录注册