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?
Thanks
Hey Priyanka,
Please post the data and we'll show you how to do it in Omniscope :-)
Paola
Priyanka Makke
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?
Thanks