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
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 model.
I have attempted to make some changes to accomplish this but I have not been able to do so.
I am displaying the quarters as Time:T#WFYear.Quarters
How can I accomplish this formatting goal?
Furthermore what is the synthax that would allow me to display a single quarter of my choosing?
Thank you in advance for your time and cooperation!
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|H2Use the same concept for selecting a quarter of your choosing:
T#|WFYear|Q3This will give you Q3 of the workflow year.
These are quick ways of doing this, but this could be accomplished in many other ways.
Try this.
To select a single quarter, create a parameter and use that in your member filter.
3 Replies
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|H2Use the same concept for selecting a quarter of your choosing:
T#|WFYear|Q3This will give you Q3 of the workflow year.
These are quick ways of doing this, but this could be accomplished in many other ways.
Try this.
To select a single quarter, create a parameter and use that in your member filter.
Thank you to the both of you for taking the time to post and help. The solution worked out great!
