获取空列返回
问题描述:
在TSQL我可以做获取空列返回
Select Column1, Column2, '' as Column3, 0 as Column4
From MyTable
我想我的MDX为:
SELECT
{Measures.Measure1} ON COLUMNS
{
Dimension1.DimensionColumn1.DimensionColumn1.Members,
'',
0
} ON ROWS
FROM [CubeName]
这不工作 - 我得到以下错误消息
Executing the query ...
Query (12, 1) Parser: The syntax for '{' is incorrect.
问题:如何在MDX中返回空或零ON ROWS
?
答
您需要定义常数的表达式:
WITH
MEMBER MEASURES.CONSTANTVALUE AS 1
SELECT {MEASURES.CONSTANTVALUE} ON COLUMNS
FROM [cube]
我如何获得这个'ON ROWS'? – 2009-11-23 15:31:45
... SELECT {}}在列上,{MEASURES.CONSTANTVALUE}在行上... – 2009-11-27 09:29:27