Strategy ONE

Exchanging the Database Instance for an MDX Cube Schema

When you integrate MDX cube sources into Strategy, the data is integrated as an MDX cube schema. Once you integrate an MDX cube source into Strategy, you can exchange the database instance used to connect to the MDX cube schema for a different database instance. This allows you to use different database instances with different login and connection information to access an MDX cube schema.

  • An MDX cube source has been integrated into Strategy(see Integrating MDX Cubes into Strategy).
  • You have created the database instance where the MDX cube schema should be moved. This database instance must meet the following requirements:
    • The database instance does not have any MDX cube schema defined for it.
    • The database instance uses the same database connection type as the database instance that currently stores the MDX cube schema. For example, you cannot move an MDX cube schema for SAP data to a database instance that has connection information for a Microsoft Analysis Services MDX cube source.

To exchange the database instance for an MDX cube schema

  1. In Developer, log in as an administrator to your project that is connected to an MDX cube source.
  2. Right-click the project and choose Project Configuration.
  3. Choose Categories > Database instances > MDX Data warehouses.
  4. Click Schema Maintenanceto view a list of all available MDX cube schemas for the project.
  5. From the Database instance column for an MDX cube schema, choose the database instance to move the MDX cube schema to.
  6. Click Yes.
  7. Click OK twice.