We all know that implementation of hierarchy is easy with Bex Queries but what about using universe as source. This blog would help you to construct a hierarchy easily in BO using universe.
Will explain you in a step by step procedure.
Pull in all the dimensions and measure to the report that you need in hierarchy. Here I have taken Year ,State City,Storename and three measures.
Click on each dimension and apply break.so if there are 4 levels in your report then apply break only for first 3 levels. As shown below break has been applied for Year, State, City. Also in break options check break header so that we can see 4 headers for this table including the table header.
On The store name column headers place year, State, City dimensions as highlighted below.
Also place Measure values next to dimensions column as highlighted below.
Hide the dimensions on which ever break is applied. We would get a table as below. We could see “California” text moved a bit. It is due to spacing applied. So we can adjust the spacing and show them as hierarchy.
Click on the table and go to analysis pane and click outline. The table will be highlighted as below. This feature helps us to fold and unfold the table. The numbers on the left end below helps us to fold the table .On clicking on each number we can fold it’s below level. Ie On clicking on 3 “e-fashion los Angeles “will be folded.
Below screenshot shows the table being folded at first level. Not only on the numbers below we can also use the arrows seen near to the text to use for folding and unfolding.