savetheday
asked on
OLAP Test Cube Parallel To Production Cube
Hello Experts!
I have an OLAP Cube that is updated weekly from an SSIS package. It runs in production in both a cube and SSRS drilldown reports.
There has been a request to change the business logic, which will be done in SSIS, that processes the data to the cube and in turn SSRS. However, the original cube is not to be changed at all. My question is, how do I copy the database so that I can run a separate SSIS package into a separate cube to provide a parallel set of reports in the cube/SSRS?
Can I copy the SSAS Database and cube and rename them? If so how to I do this specifically without overriding the original databases (very important). Thanks!
SD
I have an OLAP Cube that is updated weekly from an SSIS package. It runs in production in both a cube and SSRS drilldown reports.
There has been a request to change the business logic, which will be done in SSIS, that processes the data to the cube and in turn SSRS. However, the original cube is not to be changed at all. My question is, how do I copy the database so that I can run a separate SSIS package into a separate cube to provide a parallel set of reports in the cube/SSRS?
Can I copy the SSAS Database and cube and rename them? If so how to I do this specifically without overriding the original databases (very important). Thanks!
SD
ASKER
Hi Pedro -
I have the project solution as far as the cube files and such. I have access to one server where the SSAS database sits, along with the relational db which feeds the data. I am not sure what you mean by make a full process and change the location. Do I create a new database and just back up and restore or something. Also, as far as the cube files, how do I copy it so that I can make changes without affecting the original. Can I just copy the whole parent folder to another directory (really for testing only so should not affect anything in original database or cube, and will eventually go into production).
I am not familiar with how to copy files as I have tried to copy the project files and it seems to revert back to the original location to look for files, or change the original.
Thanks.
SD
I have the project solution as far as the cube files and such. I have access to one server where the SSAS database sits, along with the relational db which feeds the data. I am not sure what you mean by make a full process and change the location. Do I create a new database and just back up and restore or something. Also, as far as the cube files, how do I copy it so that I can make changes without affecting the original. Can I just copy the whole parent folder to another directory (really for testing only so should not affect anything in original database or cube, and will eventually go into production).
I am not familiar with how to copy files as I have tried to copy the project files and it seems to revert back to the original location to look for files, or change the original.
Thanks.
SD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Pedro -
1). Yes I have a set up very similar to the example you gave. There is a connection to the main database, where the source data resides and is updated in an SSIS package weekly.
The Cube is the other connection, the connection where data is returned into the SSAS database, or the OLAP cube.
I only have one server to work with, which will be the same server the current source data (DB) and target (SSAS DB) Sits. I want to create a parallel SSIS package with different business rules that uses the same source data but returns the data in a different OLAP Cube onto the same server, w/out interfering with the original OLAP Cube.
Can I copy and restore the Cube with a different name, do I copy the files, both?
Thanks -
SD
1). Yes I have a set up very similar to the example you gave. There is a connection to the main database, where the source data resides and is updated in an SSIS package weekly.
The Cube is the other connection, the connection where data is returned into the SSAS database, or the OLAP cube.
I only have one server to work with, which will be the same server the current source data (DB) and target (SSAS DB) Sits. I want to create a parallel SSIS package with different business rules that uses the same source data but returns the data in a different OLAP Cube onto the same server, w/out interfering with the original OLAP Cube.
Can I copy and restore the Cube with a different name, do I copy the files, both?
Thanks -
SD
to copy the SSAS Database you only need to make the full process and add the new name to the SSAS database connection.... if not exists it will created a new one... simple.
Regards.
Pedro
Regards.
Pedro
ASKER
Could you clarify specifically what you mean by "make the full process?" Is this what SSIS does - i.e. dumps the data into a new SSAS name? Do I copy the cube and rename?
Do the full process in the SSAS project after rename the database name... It will create a new one in the same server if you just add a new OLAP database...
Helped?
regards!
pedro
Helped?
regards!
pedro
ASKER
We just keep going around with this. What do you mean by "Do the full process." I don't know what that means!!!!
IS there anyone else out there that understands this question???
IS there anyone else out there that understands this question???
right click in the SSAS solution (visual studio) and select the option Process... then select FULL
helped? need some image?
regards!
pedro
helped? need some image?
regards!
pedro
ASKER
Hello Pedro -
That seems to have done it. The newer cube is visible now in SSAS. It does not seem to be available from analysis services processing task, though they are both there in SSAS. Would you happen to know how to point to the new cube from analysis services processing task?
Thanks -
SD
That seems to have done it. The newer cube is visible now in SSAS. It does not seem to be available from analysis services processing task, though they are both there in SSAS. Would you happen to know how to point to the new cube from analysis services processing task?
Thanks -
SD
ASKER
in SSIS
do you have the project soultion of SSAS? If yes, only need to make a full process and change the location of SSAS.... if not exist it will create one...
Helped?
regards!
Pedro
www.pedrocgd.blogspot.com