One of the challenges with WebI that I had in the past was fact that when you select more columns in a table then the Alerters button in the menu bar is disabled:
Usually, a hierarchy in a WebI report “occupies” as many columns in a table as there are hierarchy levels. It means that if you want to show in a table a measure let’s say on a yearly, quarterly and monthly level, there are 3 columns in front of a column that shows the measure – one column for the [Year] dimension, one for the [Quarter] dimension and one for the [Month] dimension. Something like this simple report based on the eFashion universe:
If a hierarchy goes deeper and deeper (10+ levels deep hierarchy of products is not so unusual) then there are more and more columns in a table. In such case, displaying the hierarchy in just 1 column does not only save the space in the horizontal direction but may be much more appealing to report users. So have about the above table turned into this:
Let’s have a look how to achieve it using breaks and formatting.