Skip to Content
1
May 20, 2022 at 03:36 AM

BW Query infoobject breakdown by other infoobject

203 Views Last edit May 20, 2022 at 04:03 AM 2 rev

is it possible to breakdown the dimension with other dimension,

I would like to breakdown the gl account to see the customer under gl account. I try to put the customer infoobject under g/l account in query structure.

capture2.jpg

capture1.jpg

but it only reture the row "customer", does not return the list of the customer.

I expect the results will be

GL Account Amount

10000000 600

- Customer 1 100

- Customer 2 200

- Customer 3 300

10000001 150

- Customer 1 50

- Customer 3 100

10000002 100

- Customer 2 50

- Customer 3 50

I try to apply universal display hierarchy in query, seems work. However, if the gl account applied hierarchy, it not able to drill-down the customer.

Attachments

capture1.jpg (28.5 kB)
capture2.jpg (94.7 kB)