Skip to main content
January 23, 2025

Column member filter in cube view

  • January 23, 2025
  • 2 replies
  • 0 views

Hi, 

I am just wondering, is this a limitation of OneStream? Does the column member filter support only two levels? Are we unable to add additional levels beyond this?

Thank you to those who will share their inputs.



 

2 replies

January 23, 2025

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.  

January 24, 2025

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.