Hierarchy expansion in workbook
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. The hierarchy in the system has this new node.
When I ran these queries separately in BEx analyzer both of them are not displaying that node.
They both need to be aligned with their results so the above situation disturbed the workbook formatting.
Can anybody tell me the reason behind this?