Start a new topic

Hour of Day - SSAS

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

1 Comment

Hey Priyanka,


Please post the data and we'll show you how to do it in Omniscope :-)


Thanks

Paola

Login or Signup to post a comment