Skip to main content
Newcomer
Jun 12, 2023 12:31 PM UTC

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.

 

 

 

 

3 replies

Contributor
Jun 12, 2023 2:06 PM UTC

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

Employee - Guide
Jun 12, 2023 6:10 PM UTC

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.

100RubAuthor
Newcomer
Jun 13, 2023 4:43 AM UTC

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.