使用范围将值从一个度量复制到另一个度量

本文介绍了使用范围将值从一个度量复制到另一个度量的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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;