i was trying to create a time dimension with levels - year, quarter,
month,day against my fact table with 4,971,910 records; but got timeout
error. anybody has any clues. thanks in advance....

See this article on best practices for time dimensions:

http://www.sqljunkies.com/Article/D1...F20D60951395.s
cuk
...
Notice there is a dimension table for Product and a dimension table for
Customer, but not for Date; data is being derived from the fact table.
There are many drawbacks to this design, as explained below.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***