Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Data Warehouse Granularity Different from Report Suite Settings

Avatar

Avatar
Validate 1
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 4
jharrington7897
Level 4

Likes

66 likes

Total Posts

50 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
jharrington7897
Level 4

13-06-2018

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?

Replies

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

08-11-2018

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