Skip to Content
0
Former Member
Aug 07, 2015 at 06:04 AM

Analysis hierarchy: compact view in rows but different columns for two characteristics

1609 Views

Dear all,

we have a requirement to show a hierarchy in combination with one or two characteristics. The standard view in Bex and Analysis for Office (Excel) is like this:

Country (Hierarchy) Customer Revenue Europe A 10 B 20 C 30 DE A 10 B 20 FR C 30

With the option "compact view in rows" it looks like this:

Country (Hierarchy) revenue Europe 60 DE 30 A 10 B 20 FR 30 C 30

But our requirement is to show a combination of those options. The reason is to both eliminate the characteristic values for top level nodes and show the second characteristic in an own column.

Country (Hierarchy) Customer revenue Europe 60 DE A 10 B 20 FR C 30

Is it possible to realize the last table in Analysis for Office (Excel) in combination with a standard Bex Query.

Thanks for your help.

Kind regards

Thomas