Tuesday, 5 August 2014
Formatting levels of a hierarchical column in OBIEE 11g
I had a requirement to indent the levels in a hierarchical column. The solution isn't really innovative but I thought of sharing this because finding the option can become a treasure hunt.
The objective is to attain the following.
Note that the values in every consecutive level is indented compared to the previous level.
1. Drag a hierarchical column, expand its levels and select Hierarchy Level Properties as shown below.
2. You will land on the following popup. Put your desired formatting in this place. I have added some padding as highlighted below.
Note that the formatting of every level works independently from the other. So indenting consecutive levels by 30 spaces entails padding 30 spaces for the top level, 60 in the level below the top level and likewise for lower levels.