Forum Discussion

STDN's avatar
STDN
New Contributor III
2 years ago

Cube Views

Hi, How to get 4 quarters data in one year like Q1+Q2+Q3+Q4= 2023?  what is the use of Scenario View-SV in View Dimension?   Can anyone help me with above questions?   Thanks in advance.
Cube View
CM67's avatar
CM67
New Contributor II

Hi, you could just use the full year, e.g. 'T#2023'. Or you could also use 'T#WFYear' or 'T#POVYear' to keep it more dynamic.

The Scenario View (SV) is the Default View assigned to the Scenario in the dimension library - this can be set to either 'Periodic' or 'YTD' (year to date).

Hope this helps!

STDN's avatar
STDN
New Contributor III
2 years ago

Thanks for your response, i tried the same thing but it is not coming.

 

My Scenario is before 2023,  i have Q1,Q2,Q3 and Q4 data so i am expecting all quarters added data into 2023 to get Total data. can  you guide me on this?

 

Thanks in advance.