How many time dimensions can be created for a cube? And can different cubes share one time dimen

Hi, all experts here,

Thank you very much for your kind attention.

I have encountered some problems while creating time dimensions of cubes. I am wondering: Dose SQL Server 2005 Analysis Services allow to create more than one time dimension within a cube? and can different cubes share a time dimension?

Please could any experts here shed me any light on that and I am looking forward to hearing from you shortly and Thanks a lot in advance for your help.

With best regards,

Yours sincerely,

Helen999888 wrote:

Dose SQL Server 2005 Analysis Services allow to create more than one time dimension within a cube?

Yes, but a common practice is to define a single time dimension and give it aliases through the dimension relationship tab in the cube editor. Why do you need multiple time dimensions?

Helen999888 wrote:

and can different cubes share a time dimension?

Yes.

|||Yes - both are possible. In the Adventure Works sample, there are 3 different Time dimensions in the same cube (they are role playing dimensions, but don't have to be, although it usually does make sense to make all time dimensions role playing).|||AS 2005 allows more than one Time dimension in a cube and Time dimensions can be shared.|||

Hi, All,

Thank you so much indeed for your kind advices. It's been very helpful.

With best regards,

Yours sincerely,