I am looking to create dimensions using multiple hierarchies on a fact
table containing approx 30-35 million records. Two of the dimensions
could be part of a multiple hierarchy the other two I am not so sure
about.

The dimensions I aim to create are:-
Year/Month/Day
Year/Week/Day
(These can be part of a multiple hierarchy)
Month/Year
Week/Year
(Not sure about these two)

Can the month/year and week/year dimensions be part of a multiple
hierarchy.

Processing at the moment takes 45-60 minutes, ideally I'd like to
maintain a processing time of approx 1 hour for this cube

Would appreciate any guidance.

If you're using AS 2005, it should be possible to create the multiple
hierarchies within a dimension - for example, look at the [Date]
dimension in the Adventure Works cube.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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