Let me describe the requirement using 'FactInternetSales' table.
I have a Date_Range dimension with members 7 days, 14 days, 30 days, etc. To associate this dimension I need
DateRangeKey in the FactInternetSales table but FactInternetSales doen't have TimeKey (it has OrderDateKey, DueDateKey, ShipDateKey).
So how I can calculate DateRangeKey in the FactInternetSales named query using OrderDateKey, DueDateKey or ShipDateKey as they relate to their respective dimension but I need DateRangeKey from TimeKey (I guess OrderDateKey - 7, etc would work instead of TimeKey
Without Date_Range dimension I can meet some of my reporting requirement using filter or range operator but not all and for
performance I would like to use Date_Range dimension instead of filter or range.
Any help will be greatly appreciated.
View Complete Post