Forum Discussion
- JJonesNew Contributor III
That is correct, there is only the ability to have a member expansion and a single Nested Member Expansion on the column and there is not the ability to add additional member expansions on the column filters.
- FredLucasContributor III
Hi liezelfrancisco,
That's correct, 4 levels for rows and 2 for columns.
From a performance and usability point of view, one of the important aspects to consider is the number of resulting columns and rows being displayed on screen. We usually try yo encourage smaller cube views and give access to further detail using, for example, the linked CV functionality.
However, depending on what you are trying to achieve you could use a multi dimensional filter that differs per column, allowing you to vary 3 (or more) dimensions per column.
See print screen example below:
In case your multi dimensional filter must be dynamic then you could consider having an XFBR rule generating it.
Related Content
- 2 years ago