I need to suppress aggregation on certain nodes in a hierarchy. For example, I have an hierarchy:
subnode11 should aggregate data as usual, subnode2 too, but the node1 should display no data for keyfigures.
Is there any way to do this in the query? It's easy with a custom Excel workbook or Web-Template, but I see no way to do it in the query.