Is it possible to create Hierarchy combining multiple characteristics

Hi,

We have a requirement where a drop down needs to be added in a BO dashboard whose data is based on a hierarchial structure. The data is availabe in 3 different characteristics in BW. So the question is, whether it is possible to create a hierarchy combining 3 characteristics in BW ?

Sample data:-

Dept code

XYZ 1

ABC 2

Unit Code

A 1

B 2

C 3

D 4

E 5

And similar is the 3rd char (Org level). We need to create a hierarchy combining these 3 chars. And it should look like:-

Please let me know, if this kind of structure is possible to create in a hierarchy in BW ?

Thanks,

Naveen

·