问题描述
我有两个不同的度量组,它们被连接到几乎相同的维度,但是对于一个维度,只有一个连接到其中一个mesuregroups。
i have two diffrent measuregroups which are conected to nearly the same dimensions, but for one dimension there is just a connection to one of these mesuregroups.
目的是获得不同度量组的度量的总和,但是如果使用的维度刚刚连接到其中一个度量组i只需从一个度量组中获取值。
The aim is to get the sum for the measures of the diffrent measuregroups but if the dimension is used which is just conected to one of the measureroups i need just to get the value from the one measuregroup.
目标:
维度A =维度只与Measurgroup A相关
Dimension A = The dimension which is only related to Measurgroup A
if(维度A是使用然后采用度量组a的onyl度量)
if (Dimension A is uses then take onyl measure of measuregroup a)
否则测量计量A + 测量测量组B。
else Measure of Measurgroup A + Measure of Measurgroup B.
可以做的是计算成员在mdx?
Is tha possible to do is in a calculated member in mdx?
先谢谢你的帮助。
干杯
Alex
推荐答案
看来你好吗蚂蚁计算度量A +度量B,对吧?据我所知,当维度与度量无关时,您设置度量值组属性(IgnoreUnrelatedDimensions为false)
It seems that you want to calculate measure A+measure B, right? As I know, when dimension is not related to measure, and you set measure group properties(IgnoreUnrelatedDimensions to false)
它将显示(null)。因此,当您使用度量A +度量B时,它会 不会影响结果,你需要像测量一样创建计算成员.A + measures.B
it will show (null). so when you use measure A+measure B, it won't impact result, you need to create calculate member like measures.A+measures.B
这篇关于计算特定维度的成员的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!