4 Replies Latest reply: Oct 18, 2012 9:10 AM by Thomas Schmutz RSS

    SET ANALYSIS Sum for displaying hierarchy relationship in one column?

    Thomas Schmutz

      Hello,

       

      I've quite a few hierarchy reports and would like to show the reports a little bit different than the traditional hierarchy pivot reports.

       

      Instead of showing each hierarchy level in a separate column, I would like to show the different nodes one below the other in a single column.

       

      For better visualization I've created an example (see below HIER_COSTELMNT.qvw).

       

      The COSTELMNT should only appear on the bottom hierarchy-level (3). The hierarchy-levels 2 and 3 should nevertheless show the correct SUM of the dedicated node and all nodes below this particular node. I hope to get there with a correct SET ANALYSIS SUM over the NODE_ID and the Path field :

       

      ex.:

      NODE_ID:   KA10

      Path:          KA1\KA10

       

      So for the node KA10 all nodes with Path KA1\KA10* should be summed up.

       

      Unfortunately I can't figure out the correct syntax of the SET ANALYSIS SUM expression. Does anyone knows if this is possibel and what the correct expression would be?

       

      Best regards,

      Thomas Schmutz