Set 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. Start IBM Cognos Connection.
  2. In the upper-right corner, click Launch, IBM Cognos Administration.
  3. On the Status tab, click System.
  4. In the upper-left corner of the Scorecard pane, click the arrow to view the Change view menu, and then click Services.
  5. Click Metadata .
  6. Click the arrow next to Metadata service to display the Actions menu, and click Set properties.
  7. Click the Settings tab.
  8. Next to Advanced Settings, click Edit .
  9. Select Override the settings acquired from the parent entry.
  10. In the Parameter column, type the parameter name.

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

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