Dynamic Time Dimension
Posted on 2008-10-21
I have an SQL Server Analysis Services (SSIS) Project that contains an order measure group and a project dimension. The project has a field that contains the start of the project. When I analyze measures in the order measure group along a time dimension I want a breakdown by week but have my weeks start date be the start date of the project.
For example If you analyze the measure by week, all orders in project 1 that have an order date within one week of the project start date would be totaled in week 1. All orders in project 2 that have an order date within one week of project 2's start date would be listed under week 1 as well. This could result in totals from the order measure group that are years apart being totaled in the same week.
I hope that's a clear enough explanation.