The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

FM's avatar
FM
New Contributor III
3 years ago
Solved

Cube View splitting quarters in columns

Hello,   I have this Cube View that I created in which I have to move the half year (H1) column to be in between Q2 and Q3 in order to match the formatting of the report that I was given as the m...
  • t_kaplanis's avatar
    3 years ago

     

    Since it seems you are using the WFYear, I would suggest using the substitution variable for that instead.

    The column definition would be the following to move H1 between Q2 and Q3:

    T#|WFYear|H1.Children, T#|WFYear|H1, T#|WFYear|H2.Children, T#|WFYear|H2

    Use the same concept for selecting a quarter of your choosing:

    T#|WFYear|Q3

    This will give you Q3 of the workflow year.

    These are quick ways of doing this, but this could be accomplished in many other ways.

  • aricgresko's avatar
    3 years ago

    Try this. 

    To select a single quarter, create a parameter and use that in your member filter.