Skip to Content
1
Jan 26, 2007 at 09:37 AM

Suppress hierarchy aggregation

114 Views

Hello!

I need to suppress aggregation on certain nodes in a hierarchy. For example, I have an hierarchy:

node1

--subnode1

-


subnode11

...

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.

Best regards,

Ilya.