none
Can I deploy a cube to an existing SSAS database.

    Question

  • I have been using SSAS for about 5 months.  I am working my second cube.

    My first cube is in a Database called "IT Analysis Service" and has an ID of "Analysis Services Project4"

    I built another cube in a Database called "IT Analysis Service Test" and has an ID of "Analysis Services Test".

    I would like to move the cube (and Dimensions, etc) in "IT Analysis Service Test" to "IT Analysis Service", so when my end users ( from Excel) select the IT Analysis Services database they see both cubes.

    I have tried updateing the name and Id for "Test" to the same name and Id of my other production cube (  Database called "IT Analysis Service" and has an ID of "Analysis Services Project4"), but this just overwrite my first cube.  I have deploy changes only.

    Is this even possible?  Could someone give me some advice on how to configure so I can deploy both cubes to same database?

    Thanks,

    Mike


    • Edited by Computermike Wednesday, August 21, 2013 8:13 PM clarify
    Wednesday, August 21, 2013 8:13 PM

Answers

All replies