取回空列

Question

在 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？

Answer 1

您需要将常量定义为表达式：

WITH
MEMBER MEASURES.CONSTANTVALUE AS 1
SELECT {MEASURES.CONSTANTVALUE} ON COLUMNS
FROM [cube]