One click single Cube migration by snapshot, possible?
Summary:
Content (please ensure you mask any confidential information):
Hi,
Just for brainstorm on a migration case.
Let's say there is an application with 3 cubes - PROD. Now with business expanding, back migrated PROD to DEV (NOTE: with time going on, PROD and DEV is not all synchronized), and developed a new cube in the same application. While the new cube is done in DEV, what's the safer / easier / best way to migrate the new cube(incl. all associated artifacts) from DEV to PROD.
- Safer way:
— Create the new cube first in PROD,
— Migrate/ import all the metadata/dimensionalities (NOTE: this is bit complex due to the dependencies between dimension metadata, one example is some dimensions' members are smartlist based while the smartlists again is created from dimension members, so it won't be as easy as a whole application clone which take care of everything in order automatically, and would have to be done from scratch step by step)