mdx-如何在度量值成员中用'0'替换空值 [英] mdx - how to replace null values with '0' in measures members

问题描述

在我的MDX查询中，我在SELECT语句中使用了这组度量:

In my MDX query I'm using this set of measures in my SELECT statement:

With SET [Selected Measures] AS { 
                                [Measures].[CTR],
                                [Measures].[Cost],                                  
                                [Measures].[Clicks]
                                }

我要在结果中替换"0"中的NULL值.

I want in my result to replace the NULL values in '0'.

该怎么做?

推荐答案

是否有可能涉及多维数据集设计?如果需要，则需要打开多维数据集解决方案，导航到计算"选项卡并添加以下代码.然后部署更改.

Is it possible to touch upon the cube design? If so you need the open the cube solution, navigate to the "Calculations" tab and add in the below code. Then deploy the changes.

SCOPE([Measures].[CTR]);
IF THIS IS NULL THEN this = 0 END IF;
END SCOPE;

SCOPE([Measures].[Cost]);
IF THIS IS NULL THEN this = 0 END IF;
END SCOPE;

SCOPE([Measures].[Clicks]);
IF THIS IS NULL THEN this = 0 END IF;
END SCOPE;

这篇关于mdx-如何在度量值成员中用'0'替换空值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！