This content has been marked as final. Show 2 replies
You could create a cyclical dimension with 2 fields you create in the load script.
For example if you have StartDate as your daily date. You could:
Date(daystart(StartDate), 'DD-MMM-YY') AS StartDateDayView,
Date(WeekEnd(StartDate), 'DD-MMM-YY') as StartDateWeekView
FROM .......(enter path)
WHERE StartDate > '01-Jan-2010'