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

Change Data Warehouse weekly granularity requests to return actual dates instead of week numbers

Avatar

Avatar
Boost 5
Level 2
bryanvork
Level 2

Likes

16 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 2
bryanvork
Level 2

Likes

16 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
View profile
bryanvork
Level 2

10-09-2013

When requesting data from the Data Warehouse with weekly granularity applied, week numbers are returned instead of actual dates. To complicate things, if a year ends in the middle of a week, that week is split into 2 separate week numbers, making it difficult to nearly impossible to tie these week numbers back to actual dates.  The requests end up returning more week numbers than actual weeks in the time period requested.

 

The simple solution would be for Data Warehouse to treat weekly granularity requests the way Report Builder does by returning actual week starting dates instead of week numbers. It would be even better if you could choose the date format you want returned the same way you can in Report Builder (week start date, week end date, etc).

2 Comments

Avatar

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

11-09-2013

Great suggestion @bvorkapich. Nine votes in a day is quite impressive. We'll keep an eye on this one. @mfreestone 

Avatar

Avatar
Boost 50
Level 4
trucallinglife
Level 4

Likes

60 likes

Total Posts

29 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 4
trucallinglife
Level 4

Likes

60 likes

Total Posts

29 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
trucallinglife
Level 4

07-11-2018

Has any progress been made on this, we're having to use ETL tools to import this data based on filename rather than being able to just do a direct import as the week numbers don't match our week numbering and even if they did would require another lookup table to match it to a real date?