Hour of Day - SSAS

Posted almost 6 years ago by Priyanka Makke

Post a topic

Answered

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

0 Votes

Paola Tomei posted almost 6 years ago Admin Best Answer

Hey Priyanka,

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

Thanks

Paola

0 Votes

1 Comments

Paola Tomei posted almost 6 years ago Admin Answer

Hey Priyanka,

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

Thanks

Paola

0 Votes