Suppress hierarchy aggregation

[former_member361572]

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.

[former_member361572]

We have resolved to use macros to blank out lines that shouldn't contain aggregate values.

[Former Member]

Hi Ilya,

do you have an InfoObject to determine the level of a node? Based on this information you can create calculated key figures and divide them by a boolean expression (level <> x) where x is the level of node1 in your example.

Best regards,

Björn

[former_member361572]

Hi Björn!

On my main infoobject, on which the hierarchy is built, I have an attribute which shows if the node should be aggregated (0) or not (1). But the problem is that in any formula calculations in the query, BW finds a conflict between the value derived from the attribute, and the same value, aggregated from the child nodes, and just draws a red X in place of the value. So I cannot discern the difference between an aggregation node ano no aggregation node - they're the same red X's.

Best regards,

Ilya.