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!