How to hide unwanted hierarchy nodes with zero values?

[Former Member]

Hi All,

I've a workbook which has two queries based on same cost center hierarchy. When I refreshed the queries it added a new node to one of them which doesn't have any values and not in the other query. They both need to be aligned with their rows so the above situation disturbed the workbook formatting.

When I ran these queries separately in BEx analyzer both of them are not displaying that node.

The hierarchy in the system has this new node.

Can anybody tell me the reason behind this and how can we hide the unwanted hierarchy nodes?

Regards,

Amit

[former_member181953]

Amit, check in you hierrachy infoobject you have hide nodes with only one lower level nodes,

and use zero suppressing from query properties on rows.

Edited by: Shashi on Oct 14, 2008 8:46 PM