Skip to Content
Former Member
Jun 23, 2015 at 06:18 PM

Suppression of zeros in a hierarchy


Hi All,

I have a problem in BeX Query Designer.

I am having a WBS Element hierarchy in the rows. Zero suppression is not active in the Query Properties.

When we run the report in the BeX Analyzer, when the hierarchy is drilled down it shows only the hierarchy child nodes where the KF has a value. The requirement is to show all the child nodes even if the values are zeros.

We are using this in a BICS connection for a WebI report so we cannot change the query properties in the BeX Analyser.

How can we set the hierarchy properties in Query Designer to display all the child nodes even if the KF has zero suppression.

Thanks for your help in advance.

Best Regards,