计算特定维度的成员

计算特定维度的成员

本文介绍了计算特定维度的成员的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有两个不同的度量组,它们被连接到几乎相同的维度,但是对于一个维度,只有一个连接到其中一个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


这篇关于计算特定维度的成员的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 10:10