We help IT Professionals succeed at work.
Get Started

OLAP Test Cube Parallel To Production Cube

1,401 Views
Last Modified: 2016-02-13
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
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE