Display Only 1's from a Natural Consolidation

[conray]

Hi all,

I have 2 measure namely Std (Weight 1) and Act (Weight -1).
The natural consolidation measure is Diff:
Diff
|--Std
|--Act

I am trying to display all results of a set of materials if the natural consolidation evaluates to non-zero.

Currently, i am able to display the result using zero suppression when displaying the measure Diff.
But when i drill down, it will show every single materials including those which evaluates to zero.

Is it possible to achieve what i want to do?
Sorry if i didn't phrase my question properly caused i can't explain well in words

[declanr]

It depends how you want to display the results but like the majority of things in TM1 there are a few options.

If it is possible for you to view it through an active form; my preferred method would be to create the active form based on a view which has zero supression turned on.

The column only showing the C-Level element and nothing else, the row being what ever else you do so fancy... this makes it so that only the consolidations that have a value are shown. I would then in the Excel sheet containing the active form add the 2 N-Level elements next to the existing column and stick the DBR formulas in.

Because the N-Level is not part of the view that the form is based on your zero-suppression should still work as desired.



Or you could create an extra consolidation that looks pretty much identical but the N-Level elements only pull through their original counterparts IF the orginal C-Level does not equal 0.

So say that your new elements are the same names but all prefixed with 'Z'

['ZStd']=N:
IF(['Natural Consolidation']=0,0,['Std']);

[conray]

Hi declanr,

I will use your prefered method as its easier and faster to do, and also because method 2 requires me to perform additonal calculation on the cube.
Natural consolidation is still the best way to go

Thanks again for your suggestion.