How can I create a time dimension in SSAS which has hierarchy with the highest level values as Year, Prev 35 Days, Weeks.Then second level on hierarchy will show Qtr1,Qtr2 etc under Year. Prev 7 Days, Prior 28 Days under Prev 35 Days and Wk00, Wk01 under Weeks. Under second level hierarchy we will show the MonthDay such as Jan01, Jan02 etc for all those levels
Submit an article or tip