suppress/exclude or hide??? 3

[MiRRo]

Hi people this is my problem.
I have several catagories in dimension adresgroup who are customers which have no adresgroup. Those customers are displayed in Powerplayreporter in the dimensionmap adresgroup, I dont want them to displayed. Is it secure to say in dimesion diagram to suppress or exclude or hide those customers so they will not be displayed in reporter under the dimension adresgroup??? Which one shall I choose or is there an another option??
Thanks!!!

Cheers,

MiRRo

 

[BruceReed]

Hello Mirro

Suppress means not to show the details in the PP report, but the values of these supressed item(s) are used, and show up in the rolled-up numbers (total, average etc.)

Exclude means don't show the details, don't use the values of the missing item(s) in any roll-up.

Hide includes everything in the cube, but just hides it for the moment in Transformer. It is similar to using the "+" and "-" in MS Exployer.

Bruce

 

[CognosProfessional]

SUPPRESS:
In situations where a category is not required for reporting purposes, but its ancestor and descendant categories are, you can suppress the category to hide it. Suppression creates placeholder categories in hierarchies where no values exist for some categories in a level. The values for the descendants of a suppressed category are rolled up and retained in the ancestor category. Suppressed categories, including blank categories, are still included in category counts. Values associated with them are included in rolled-up measure values.

You can suppress existing (as well as blank) categories in a level by suppressing the level itself.

In dimensions with alternate drill-down paths, suppressing a category located above the convergence level in one drill-down path has no effect on categories in the other drill-down paths. You can suppress categories in different alternate drill-down paths, but you can’t suppress more than one entire alternate drill-down path.

EXCLUDE:
The Exclude option not only omits categories and their descendants from the dimension or user class view: it also omits the data associated with those categories. Excluded categories are not included in category counts, nor are values associated with them included in rolled-up measure values. This differs from the Cloak, Summarize, and Suppress options, which act on the categories but have no effect on the data written to the cube.
In dimensions with alternate drill-down paths, excluding categories from one path excludes the same categories from all other drill-down paths. In Transformer version 6.6 and above, you can exclude categories from a user class view.

CP