Page 1 of 1

Force the Measure Elements at Consolidation

Posted: Fri Aug 01, 2014 2:56 pm
by 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

Re: Force the Measure Elements at Consolidation

Posted: Fri Aug 01, 2014 3:31 pm
by 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;

Re: Force the Measure Elements at Consolidation

Posted: Fri Aug 01, 2014 4:04 pm
by 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.

Re: Force the Measure Elements at Consolidation

Posted: Fri Aug 01, 2014 6:01 pm
by Wim Gielis
The exact syntax is different:

Code: Select all

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

Re: Force the Measure Elements at Consolidation

Posted: Sat Aug 02, 2014 12:16 am
by rmackenzie
Thanks for the correction, Wim, I was doing it totally off the top of my head. :oops:

Re: Force the Measure Elements at Consolidation

Posted: Sat Aug 02, 2014 12:28 pm
by Wim Gielis
No problem Robin, you're welcome.