Setting the maximum number of objects used in SAP BW packages

You can set the maximum number of cubes and info queries that can be included when a SAP BW package is created.

The longer a SAP BW import takes, the more time the server spends processing the request, which could have an impact on its performance for other applications. Find a balance between the number of cubes and info queries commonly needed by users and the potential impact on server performance.

The following (case-sensitive) parameters are available:

  • com.ibm.cognos.metadatauiservice.sap.maxcubes

    The maximum number of cubes that can be used in a SAP BW package. Valid settings are zero and greater. The default is 2.

  • com.ibm.cognos.metadatauiservice.sap.maxInfoQueries

    The maximum number of info queries that can be used in a SAP BW package. Valid settings are zero and greater. The default is 5.

For more information about SAP BW data sources and creating SAP BW packages, see Data sources and connections.

Procedure

  1. In IBM Cognos Administration, on the Status tab, click System.
  2. In the Scorecard pane, from the change view menu of the current view, click Services > Metadata.
    Tip: The current view is one of All servers, All server groups, All dispatchers, or Services.
  3. From the Metadata service Actions menu, click Set properties.
  4. Click the Settings tab.
  5. Next to Advanced Settings, click Edit .
  6. Select Override the settings acquired from the parent entry.
  7. In the Parameter column, type the parameter name.

    For example, type com.ibm.cognos.metadatauiservice.sap.maxcubes.

  8. In the Value column, type the associated value for the setting.
  9. Continue typing setting names and values as required.
  10. Click OK.
  11. On the Set properties page, click OK.
Parent topic: SAP BW Packages