Page 1 of 1

TM1 Rules - Calc Measure not showing with Suppress zeroes

Posted: Sat Sep 17, 2011 4:02 pm
by ashwinchitkara
Hello All,

I have a Calculated Measure A = B+C being calculated using cube rules

When I have the Suppress Zeroes 'ON' I do not see this measure even if I have data being calculated for this measure.

Is this normal to TM1? Can I incorporate a function within my rule to show me Calculated Measure even with the Suppress Zeroes 'ON'

Thanks,

Ashwin

Re: TM1 Rules - Calc Measure not showing with Suppress zeroe

Posted: Sat Sep 17, 2011 4:13 pm
by David Usherwood
Your rule is unfed, so A will disappear when you turn on zero suppression.
You could write a set of feeders like

Code: Select all

['B'] => ['A'];
['C'] => ['A'];
But it would be much more efficient to set A to be B+C in a consolidation.

Re: TM1 Rules - Calc Measure not showing with Suppress zeroe

Posted: Sat Sep 17, 2011 7:11 pm
by ashwinchitkara
David,

Thank you for your quick response. FEEDERS did help; however with reference to your note on an "efficient design to set A to be B+C in a consolidation" when I use the ['A']=C:['B']+['C'];
with FEEDERS per your suggestion, Calc Measure does not show again with Suppress Zeroes. However it does show with
['A']=['B']+['C'];
or ['A']=N:['B']+['C'];

Does that mean Calculated Measure would not work with Suppress Zeroes turned 'ON' when the rule is ['A']=C:['B']+['C'];
even when the FEEDERS are set to
['B'] => ['A'];
['C'] => ['A'];

Re: TM1 Rules - Calc Measure not showing with Suppress zeroe

Posted: Sun Sep 18, 2011 8:52 am
by David Usherwood
Looks like I was not completely clear here.
The most efficient approach is to edit the measure dimension and make C the parent of A and B. Then you won't need the rules or the feeders.
C: rules aren't relevant to what you're trying to achieve (and are generally worth avoiding anyway, in my opinion).

Re: TM1 Rules - Calc Measure not showing with Suppress zeroe

Posted: Sun Sep 18, 2011 1:40 pm
by ashwinchitkara
I get it. Thanks David. Appreciate your time to assist me.