Forum Discussion

liezelfrancisco's avatar
liezelfrancisco
New Contributor
17 days ago

Column member filter in cube view

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.

 

  • JJones's avatar
    JJones
    New 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.  

  • FredLucas's avatar
    FredLucas
    Contributor 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.