I would like to analyze data per hour using SSAS training. The built-in date dimension does not create any hour attributes.
Currently, I am creating a new table with HourOfDay and HourOfDayName fields and will use this table to create a date dimension.
Could anyone tell me if there is a common way of achieving a time of day based analysis using SSAS05?
Please post the data and we'll show you how to do it in Omniscope :-)