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
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.