01-11-2024 04:48 AM
Hi,
This is most likely basic but I cannot find a reference for this.
I want to show the time Quarter in a cube view, but the name should be the last month of the quarter instead of Q1. Should be March 2023.
May I know how to do this?
Thank you in advance.
Solved! Go to Solution.
01-11-2024 12:19 PM
I'd probably keep the monthly time selection but override the view to QTD.
With Time as the primary dimension selection, it would be: T#2023M3:V#QTD
This should still display 'March 2023' but your data will be the full quarter.
01-11-2024 09:01 AM
Hi Cons,
It depends on how you define the time at the begginning (year, quarte, month...)
Here you have some of the available options.
If you start with the years as time, you can set it fixed as T#(your_year).M3, T#(your_year).M6, T#(your_year).M9, T#(your_year).M12
If you have the quarter as time, you could set it as T#FirstPeriodInMonthPrior1(your_quarterTime) [not tested].
Good luck
01-11-2024 12:19 PM
I'd probably keep the monthly time selection but override the view to QTD.
With Time as the primary dimension selection, it would be: T#2023M3:V#QTD
This should still display 'March 2023' but your data will be the full quarter.
01-15-2024 07:03 AM
Thank you @db_pdx, it worked.