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.
