Skip to Content
author's profile photo
Former Member

Practical Issue #1: Building a Hierarchy

Hello Experts,

I am working on the following hierarchy and came up with some question I believe you can help me.








Countries: Holland, Canada, Nigeria

Regions : Americas, Europe, Africa

Profit Center: CenterNum, Unit, AAA, BBB, CCC

While trying to set this up, I encountered the following problems:

I created characteristics: Org, Region, Country, ProfitCenter. L left all options as default

except under Hierarchy tab, where I checked with Hierarchy; Time-dependent hierarchy structure, then activated for all.

The lowel level in the hierarchy (ProfiCenter) where data will be loaded from the flat file was not set as a hierarchy.


How do I bring in the CenterNum, UnitNum, AAA, BBB, CCC into the hierarchy? Any special consideration for the CenterNum and UnitNum which together form the primary key for the in coming flat file.

I will post the remaining questions(2,3,..) in a differnt post for purposes if point

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 03, 2005 at 05:20 AM

    Hi Amanda,

    I'm not clear about your Centername and Unitname (what are they?), but think that the easiest way to do what you want - to build an hierarchy of profit centers and use approach recommended by Glen - in a query add chars you need and profit center hierarchy underneath, and represent them as hierarchy.

    Best regards,


    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 04:23 AM

    Hi Amanda,

    Have you tried introducing CenterNum and Unit as the attributes of the Infoobject Profit Center in the Query rather than in the Hierarchy, as they would correspond to a Profit Center and from what I understand they are not part of the hierarchical structure.

    So you could try using them as attributes.

    Hope it helps.



    Add comment
    10|10000 characters needed characters exceeded

  • Oct 03, 2005 at 04:26 AM

    Not sure if you've already tried these or not but Universal Presentation Hierarchies could do this for you dynamically. In BEx Query Designer, add the characteristcs involved in the hierarchy to the rows. Right mouse click in the white space around these characteristics in the rows and select "Display as Hierarchy". This would allow changes in master data to be automatically reflected in the hierarchy in your report.

    Add comment
    10|10000 characters needed characters exceeded