Skip to Content
0
Former Member
May 15, 2008 at 02:12 PM

BEx query - report with hierarchy, strcuture and cell

32 Views

SDN,

I need to create a report like -

Profit center1 Profit Center2 PC3 PC4 PC5 ... till PC20

Account

001 10 20 30 40 50 ... 100

002 10 10 10 10 10 100

North 20 30 40 50 60 200

On rows, I need various account with their hierarchy, I should be able to expand account hierarchy node when wants to see details.

in Column... I need various profit center (on header) and data filled with various revenue. so intersection of account and profir center - should be revenue in that acoount from profit center.

Revenue - is based on formula - Ned to define based account-profit center interaction using Cell edit.

In order to create cell - I need two structure, so account I am making part of structure.

trouble is - I am not able to expand account hierarchy?

If I do not make account as part of strcuture, I can not use cell concept. If include them in struc... can not expand/drill on them?

profit center can be expanded as it is outside structure (of key figure)

what I am messing?