This content has been marked as final. Show 2 replies
Alex1 wrote:Assuming you have a dim hierarchy setup in your repository, by setting under 'Keys' tab .. 2 keys, one is the Primary Key which is your ID at that level and Desc/Name which you will set for Display.
Level 1 (Bikes, Cars, Trucks) If I want to drill-down in bikes I can see Bike 111, Bike 999 (level2):
Now use the Descriptor ID (Double Column) , read here -> http://www.rittmanmead.com/2010/08/oracle-bi-ee-11g-handling-double-columns-iddescription-interoperability/
and here -> http://docs.oracle.com/cd/E23943_01/bi.1111/e10544/analyses.htm#CHDJDDGC
Thanks for your answer
But I think that I can't use your solution. I don't want to filter by ID. My assignment is to show with one column (in my case Level1) and add members of Level2 (same hierarchy) and give it a custom order.