使用范围将值从一个度量复制到另一个度量 [英] Copying values from one measure to another using scope

问题描述

以下是我要覆盖市场得分值

Below is the scenario in which i want to overwrite the value of market score with over score. If over score exists.

这是预期的输出。

谢谢

推荐答案

从头开始编写范围语句很难，而不知道多维数据集的结构是什么样的。但是如果你只是希望这个范围适用于维度，你向我们展示了q1，q2，q3成员，你可以使用类似下面的
（替换< attribute>和< level>位置持有者）使用多维数据集中对象的名称：

It's pretty hard to write a scope statement from scratch without knowing what the structure of the cube is like. But if you just want this scope to work over the dimension you showed us with the q1,q2,q3 members in it you could use something like the following (replacing the <attribute> and <level> places holders with the names of the objects from your cube:

SCOPE（Dimension。< attribute>。< level> .Members，[Measures]。[Market Score]）;

   this = COALESCEEMTPY（[Measures]。[Over score]，[Measures]。[Market score]）

END SCOPE;

SCOPE (Dimension.<attribute>.<level>.Members , [Measures].[Market Score] );
    this = COALESCEEMTPY([Measures].[Over score],[Measures].[Market Score] )
END SCOPE;

这篇关于使用范围将值从一个度量复制到另一个度量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！