Practical Issue #1: Building a Hierarchy

[Former Member]

Hello Experts,

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

OrgStruc

-

---

Region

-

---

Country

-

---

ProfitCenter

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.

1.

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.

[Former Member · Accepted solution]

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,

Eugene

[glenleslie]

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.

[Former Member]

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.

Cheers

Anurag