TM1 Rules - Calc Measure not showing with Suppress zeroes

[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

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

[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'];

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

[ashwinchitkara]

I get it. Thanks David. Appreciate your time to assist me.