Forum Discussion

100Rub's avatar
100Rub
New Contributor III
2 years ago

Cube View reporting

Hi,

I want to have a consolidated report from Oct to Sep of any year. In order to achieve this, one time profile is created and attached to a cube and the same cube is used in cube view. What should I write in T# for cube view column ? Thanks in advance.

 

 

 

 

Cube View

3 Replies

Sort By
  • Omkareshwar's avatar
    Omkareshwar
    Contributor II
    2 years ago

    Hi 100Rub,

    You can use T#|WFYear|.Base If Oct is your 1st month in your time profile settings. I am using Workflow Year to have year dynamic.

    Thanks,Omkareshwar

    Archetype Consulting

  • chul's avatar
    chul
    Contributor III
    2 years ago

    Is Oct to Sep your fiscal year? If so, your time profile would indicate that 2023M1 is Oct, 2023M2 is Nov, etc.

    If you're anchoring on WF, then you can use T#|WFYear|.months (or .base if you have a monthly app). If your anchor is Global POV or Cube POV, change the |WFYear| accordingly.

  • 100Rub's avatar
    100Rub
    New Contributor III
    2 years ago

    Hi Omkareshwar and Chul,

    Thank you for your suggestion but I see Oct 2019 to Dec 2019 and again from Jan 2019 to Sep 2019 in my Data Explorer instead of Oct 2018 to Dec 2018 and then Jan 2019 to Sep 2019 as per my Workflow Time POV 2019M1.