Migrating BO reports from Universe to BICS - How to maintain Hierarchies in BEx
We are in process of migrating some of our BO reports from Universe based to BICS based reports.
In earlier version we defined a hierarchy (upto 10 level) in Universe and used BO drill down feature to show results against each hierarchy levels.
Now we are migrating this report with BICS (using same BEx query as source which we used for Universe) and we are facing challenges to migrate this hierarchy into BEx. We can't modify the BW info-objects as other projects using those objects in their reports.
Can anybody help me on how to configure/build the hierarchy at BEx level and allow us to use the same in BO reports?
Thanks in advance.