Force the Measure Elements at Consolidation

[krithika331]

Hi,

In the Measure Dimension, I have the consolidations defined for three categories A, B and there are elements present in them. The Summation of different measures is happening at the Consolidation level which is not correct and I want to make it to zero. I have applied as below but it throws the error as element is ambigous. Any Ideas??

[{'A', 'B'} ] = C: 0;


Thanks in Advance

[rmackenzie]

If you have an element named 'A' in more than one dimension in the same cube then the rules for that cube need to specify which dimension e.g.:

Code: Select all

[{ 'dim1':'A', 'dim1':'B' }] = C: 0;

[krithika331]

Thanks a lot. It is working as expected if I define it separately for each element as below:

['dim1':'A'] = C: 0;
['dim1':'B'] = C: 0;

But when I define as [{ 'dim1':'A', 'dim1':'B' }] = C: 0; , it gives me error.

[Wim Gielis]

The exact syntax is different:

Code: Select all

['dim1':{'A','B'}] = C: 0;

[rmackenzie]

Thanks for the correction, Wim, I was doing it totally off the top of my head.

[Wim Gielis]

No problem Robin, you're welcome.