Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Time dimension

Author  Topic 

stathis30_2000
Starting Member

23 Posts

Posted - 2007-09-04 : 11:29:55
Hello,

I am trying to make a time dimension in analysis services. Is it possible to include the hours of a day in the dimension ? Is necessarily the day level the lowest of the hierarchy?

Thank you
ST

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-04 : 23:05:06
It's possible if you build dimention table properly.
Go to Top of Page

stathis30_2000
Starting Member

23 Posts

Posted - 2007-09-05 : 03:57:25
How can I build the dimension table properly ? I use the dimension wizard and I do not have much choices...

Thanks
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-05 : 22:39:21
Need set days and hours in source table.
Go to Top of Page
   

- Advertisement -