SAP BEX - Hierarchy

[former_member198674]

Hi Experts,

The user needs the output like this.

Sales org is hierarchy. Whereas Product & Customer is just characteristics.  What is the best way to do this below with a combination of Hierarchy and characteristics?. The user wants the roll up and roll down for industries, customers products …etc. What is the best way to handle the below requirement in Bex query designer and we are planning to use it in WEBI once the query is developed in BEX query designer.

Rows

Key figures

KF1

KF2

KF3

RKF1

RKF2

RKF3

Sales Org

All Customers

All Products

Other attribue1

Other Attribute 2

Thanks

Ram

[MGrob · Accepted solution]

Hi

How about you use the display hierarchy function in BEx?

[former_member198674 · Accepted solution]

Thanks SVU And Martin. We will have to have the display hierarchy function along with External hierarchy.

Thanks

Ram

[former_member202718]

Hi Ram,

How is The Sales org Hierarchy Defined ?

Keep Customer and Material in Free Chars and Drill Down at this Level wud have performance Issues.Just keep Sales Org in Rows

OR

Keep Customer and Material  in Rows and have Sales Org in Free Chars.

One of the Ways could be to have  Sales Org in Rows and Customers in Columns just Above Key Figures.However it wud not suit for Material as number of Material wud be more.

Also Will the User be able to Make out the Report and its Values at the Format He wants?

rgds

SVU