Strategy ONE

MDX Cube Schema Loading

By default, MDX cube schemas are loaded as needed when MDX cube reports are executed. You can choose to load MDX cube schemas when Intelligence Server starts. This affects when the load time required for MDX cube schemas occurs.

Loading MDX cube schemas when the Intelligence Server starts is a good option when MDX cube reports are commonly used in a project. This optimizes the MDX cube report runtime performance since the schema for the report has already been loaded. However, The overhead experienced during Intelligence Server startup is increased due to the processing of loading MDX cube schemas, and when importing a new MDX cube or refresh an MDX cube, you must update the schema of your project to load the MDX cube before report execution and to use the updated MDX cube schema.

Loading MDX schemas when an MDX cube report is executed is a good option if MDX cube reports are supported for a project, but are rarely used in the project. This decreases the overhead experienced during Intelligence Server startup as compared to including loading MDX cube schemas as part of the startup tasks, and MDX cube schemas are not required, they do not need to be loaded and no overhead is experienced. However, the MDX cube report runtime performance can be negatively affected due to the processing of loading MDX cube schemas.

This procedure assumes you have already created an MDX cube database instance that connects to your MDX cube source.

To define MDX cube schema loading options

  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 to open the Project Configuration Editor.
  3. Choose Categories > Database instances > MDX Data warehouses.
  4. Click Schema Maintenance.

  5. From the Preload column, choose:

    Yes: MDX cubes are loaded when Intelligence Server starts.

    or

    No: MDX cubes are loaded when MDX cube reports are executed.

  6. Click OK.
  7. Click OK again.

  8. Whenever you modify the schema loading option for an MDX cube source database instance, you must update the schema for your project to reflect these changes.

    In Developer choose Schema > Update Schema.