How to use already created Dimensions in SSAS project in new Cube

I have an task in which I have to use already created Analysis Services project for building up new cube. now for building up new cube i need to use some of the dimensions that are already in place. and some i have to create.. Till Data Source View I have almost done. But while cube designing from Data Source View I am facing problem. I am not able to use already present dimensions.

I am using wizard to construct CUBE. now what happens when i create the cube using wizard it automatically creates already present dimensions under new name by appending 1 or 2 etc. I tried the other way by unchecking the already present dimensions but this generates other problem after finishing this way i couldn't see relationships presnt in fact and dimension table as expected by me.

I am new to Analysis Services being my first project i am unable to come out of situation. Somebody has told me by constructing CUBE by not using wizard instead doing it manually will sort out the things... Can anybody provide me any link in which there is explanation how to design cube manually OR solution to my problem

Please mail me at mandipjutla@.hotmail.com

Thanks
Mandip

Hi Mandip,

If you have the dimension already defined in the project all you will need to do is add them to the cube by taking the following steps.

1. Edit the cube that you want to add the dimension to. This OK even if you have created the cube via the wizard.

2. Remove the existing dimension created by the wizard from the cube, by right clicking and choosing delete.

3. Add in the existing dimension that you want by right clicking and choose add.

4. Even if it puts a different name, you can always rename it.

I hope this helps,

David Botzenhart

|||

Hi David,

Thanks for the help.

I have applied the same process as explained by you. But still i can't see the relationship between fact and newly added dimension on Cube's Data Source View.

I have also set up the relation betwwen fact and dimension by going into Dimension Usage tab.

Thanks,

Mandip