Scenario is a common partitioning dimension. Some example scenarios would be Actual and Budget. In this case, we want the complete structure to occur for both Actual and Budget. There are many advantages to thinking of these from a dimensional viewpoint. Height Height is one way of identifying location within the dimension.
Height is counted from the bottom up.
In a star architecture, L 0 points to or is joined to the fact table. Admittedly the individual queries are more complex. However, the drilling operations become almost trivial. For the same reason, there are benefits in keeping the complete dimensional structure in the same table. One of the particular advantages to using depth is that dimensional navigation is simpler.