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
2 years ago

Hi, could you share the member filter you are using in the cube view to try to retrieve the data?

Also, what do you mean by 'My Scenario is before 2023'? What year is the Q1 - Q4 data for?

The member filter would need to be a combination of the Time and View - e.g. T#[Year]Q4:V#YTD would return the YTD for all quarters

  • STDN's avatar
    STDN
    New Contributor III
    2 years ago

    Thanks again for your replay, I need 2022 year data by adding 4 quarters like Q1+Q2+Q3+Q4=2022 total.

    Please find the  below image  of my Member Filter data and suggest me .

    Thanks 

    • AK's avatar
      AK
      New Contributor III
      2 years ago

      What kind of Accounts you have in Cube View? It depends on the Account type of the Accounts used. Account type determine how account balances accumulate over time.