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

bryanvork

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 (2 New)
2 Comments

benjamingaines2

11-09-2013

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

trucallinglife

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?