I have a req to show level based hierarchy in excel kind of pivot structure.
Ms Excel shows formatting in vertical tree structured hierarchy.
OBIEE shows hierarchy in horizontal format.
Please let me know if anyone achieved the same.
Can you elaborate what is not working ??. How did you create the report? .
You have to drag the Heirarchy from BMM to presentation layer.
Check in answers whether the heirarchy in present under the presentation folder. Drag the presentation heirarchy and required measures.