cancel
Showing results for 
Search instead for 
Did you mean: 

how to use a hierarchy

Former Member
0 Kudos
47

Hello,

can anybody tell me how to use a hierarchy once it has been created?

I mean I need to use this hierarcy in a query and I'd would like to know which is the full process until reach to the query.

Can anybody suggest me any link where it is explained.

Thanks a lot.

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

tnecnivo
Active Contributor
0 Kudos

Hi David,

Not sure if I understand your question correctly but if you are asking how to use the Hierarchy created for 0CUSTOMER in query.

These are the steps:-

1. Open BEx Query Designer

2. Open the query or create new query

3. Make sure 0CUSTOMER is either in Free Characteristic, Row or Column (depending where you want it)

4. Click/select on 0CUSTOMER, the Properties for 0CUSTOMER will displayed on the right side of the screen.

5. go to Hierarchy Tab, Under 'Selected Hierarchy", click on the square box, a window will prompt.

6. Click on the dropdown to select the Hierarchy Name.

7. Save the query.

Then in your query, whenever you drag in 0CUSTOMER, it will display as Hierarchy according to the Hierarchy you created.

Kind regards.

Answers (1)

Answers (1)

RamanKorrapati
Active Contributor
0 Kudos

Hi David,

First we need to create info object and under that we need to maintain hierarchy structure, Once we maintained hierarchy structure, then we need to load data from Source or Flat file.

Create of hierarchy master data info object:

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6736e07211d2acb80000e829fbfe/content.htm

Below pdf explained loading hierarchy data from R/3 Side to bw.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c06abdd0-1e9f-2e10-dc91-a6e68d0e8...

http://www.element61.be/e/resourc-detail.asp?ResourceId=189

Below screen shows reports on hierarchy:

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/70ca55fe-7d39-2d10-0c95-bbd6850c1...

Regards

Former Member
0 Kudos

Hi KR,

thanks a lot for the information.

I've created the hierarchy on the 0customer infoobject. I only need to know where and how to use this not to load the hierarchy from R3 side. I think your links are focused on this way.

I think the process is very easy but I'm doing something wrong...

Regards.

RamanKorrapati
Active Contributor
0 Kudos

hi David,

have you implemented BPC in ur org?

0customer have the hierarchy str.

on reports if you like to see hierarchy of 0customer, drag 0customer int wo rows, you can see child wise. like 0customer have profit center and company code.

By using 0customer in rows you can view the key fig values for particular profit ctr and comp code combo.

Below link explained  hier str on 0customer.

http://scn.sap.com/message/13544602

http://scn.sap.com/thread/20363

Regards