Combining two hierarchies into one

The result of a query contains as many metadata columns as there were hierarchies on rows. For example, if we put two hierarchies on rows, color and size of products, there will be two columns of metadata information, one for each hierarchy. In the first column, we will have all colors and in the second column we will have all sizes. Depending on the relationship between those hierarchies, we will get either a full cross join for unrelated hierarchies (different dimensions) or a reduced set of valid combinations (in the case of the same dimension). In any case, there will be two columns.

We can think of this one hierarchy, which occupies one column type of report as a symmetric table. This type of report can grow very large very quickly because of the cross production of multiple hierarchies. It is not uncommon for business users to request placing data from different hierarchies into the same row or column, with the goal of reducing the size of the report...