Rule to exclude consolidation element values for a measure that is related to only lower level element in a hierarchy

[Analytics123]

Hi All,

I got stuck at this point and not sure if there is any way possible to achieve this .

I have a customer dimension with a hierarchy Region, Agency, Reps and Customer . And the other dimension in cube are currency , months and Gl Account.

Now I am having a measure loaded to the cube via a TI Process which would store the DaysSincePayment . This measure should be applicable only to the customers .

So now the issue I am having is say a region 1 -> Agency ->1 has 5 customers the ,DaysSincePayment is rolled up at consolidated levels .

I always wanted the consolidated level of customer dimension to show 0 for DaysSincePayment as they dont relate to them .

I tried this rule but it set 0 to all elements
['Days Since Payment']=C:0;
I also tried
['Days Since Payment']=C:STET; but the values for consolidation still exists.


I am not sure if we can use a subset with all consolidated elements from customers dimension and use them in rule to set it to 0 for DaysSincePayment , but i think thats not possible .


Any help is appreciated .

Thanks,

[Edward Stuart]

Have you considered rule prescedence?

What happens to the values when you move the C level rule to the top of the rules file?

[Wim Gielis]

Hi,

Indeed, consider:
- rule precedence
- the ELLEV function
- the ELISANC function

because if I understand the problem you will need to make a distinction for different kinds of consolidated cells.

[Analytics123]

okay , I used this and it looks okay now , not sure if I need to use any other checks here .

['Days Since Payment' ] = IF ( ELLEV('Customers SoldTo Only', !Customers SoldTo Only) <> 0,0,Continue );

Thanks for your help .