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]
查詢結果如下:
其中[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;
同樣的定義爲什麽查詢出來的結果不一樣呢?
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]
查詢結果如下:
其中[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;
同樣的定義爲什麽查詢出來的結果不一樣呢?
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
darkor2 2014-07-09 回答
赞同来自: