Sunday, March 25, 2012

Creating two dimensions referencing the same table

Hi,

I am building a cube in the 2005 Analysis Services. I built the cube successfully when each of my dimensions referenced exactly one table. Now I want to extend that to build two dimensions based on one table. I can build the 2nd dimension but I cannot use it within the cube.

Any suggestions on how to do that?

Thanks in advance,

Aref

Any reason why you can't build 1 dimension and use it in 2 roles within your cube (eg: Date dimension in Adventure Works plays 3 roles)?

No comments:

Post a Comment