Home Forums Data Warehousing Analysis Services Display all the Dates of a Week of the current date selected RE: Display all the Dates of a Week of the current date selected

  • Yeah, in out of the box AdventureWorks the Calendar hierarchy is Year>Quarter>Month>Date. For this example I added in week to make it Year>Quarter>Month>Week>Date.

    The fact that you get the entire month for the same query in AdventureWorks proves it's correct. Try it against your data as you mentioned you have week in your hierarchy.


    I'm on LinkedIn