Cube View splitting quarters in columns

Question

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!

t_kaplanis · Accepted Answer

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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded