Skip to Content
author's profile photo Former Member
Former Member

Can Hierarchy Nodes be summarized in Bex?

Hello experts,

We have a query the uses a CostElement (CE) hierarchy and CostCenter (CC) in the Rows area. The CE hierarchy has 3 levels; the CEs that are posted to are all on level 3. Levels 1 and 2 are used for grouping purposes and always end with "99".

Upon execution, the results are as follows:

Lvl | CE | CC | $

1 | 689999 | 2001 | 25

1 | 689999 | 2002 | 7

1 | 689999 | 2003 | 5

1 | 689999 | Result | 37

2 | 680099 | 2001 | 25

2 | 680099 | 2002 | 7

2 | 680099 | 2003 | 5

2 | 680099 | Result | 37

3 | 680020 | 2001 | 25

3 | 680020 | 2002 | 7

3 | 680020 | 2003 | 5

3 | 680020 | Result | 37

The desired result is:

Lvl | CE | CC | $

1 | 689999 | Result | 37

2 | 680099 | Result | 37

3 | 680020 | 2001 | 25

3 | 680020 | 2002 | 7

3 | 680020 | 2003 | 5

3 | 680020 | Result | 37

In other words, we want to summarize the nodes at levels 1 and 2 since they are not posted to directly. This will eliminate redundant entries of CostCenters at levels 1 and 2.

We have tried several options using Structures vs. Hierarchy and workbook formating but are unsuccessful so far.

Any suggestions are greatly appriciated!

Regards,

Adam

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 08:07 AM

    Maybe you want to display the rows as hierarchies. Right click on the grey bar that contains the word Rows. Choose Display as hierarchy. You may want to choose a starting expand level.

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.