Skip to main content
1
100Rub
Newcomer
June 12, 2023

Cube View reporting

  • June 12, 2023
  • 3 replies
  • 0 views

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

O
Omkareshwar
Contributor
June 12, 2023

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

C
OneStream Employee
chulOneStream Employee
OneStream Employee
June 12, 2023

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.

1
100RubAuthor
Newcomer
June 13, 2023

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.

 

Terms & ConditionsAccessibility statement