Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Data Warehouse Granularity Different from Report Suite Settings

Avatar

Level 5

Hello Everyone,

Apologies if the question is silly:

We have a fiscal 4-5-4 calendar at our company. 

When pulling reports out of Workspaces, Month granularity looks to be pulling correct data.

For example, Month of Fiscal May gives me 5/6/18 - 6/2/18, as per our setup.

1507742_pastedImage_1.png

1507743_pastedImage_2.png

However when pulling reports out of Data Warehouse, though the calendar in the UI gives me a fiscal calendar, the data that is returned treats the granularity as if it is a  standard calendar year, like it isn't respecting the report suite settings:

1507744_pastedImage_3.png

1507745_pastedImage_4.png

It might just be the way it is, but is there something I'm missing here?

1 Reply

Avatar

Employee Advisor

Definitely not a silly question - from my perspective, I see this as a bug. Have you already logged a ticket with Customer Care?