How to hide unwanted hierarchy nodes with zero values?
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?