Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Configuring universe parameters

Before you can configure the universe parameters, you must import the universe and edit the connection to the database.

To import the ITSM universe

  1. From the Windows Start menu, select Start > All Programs > SAP BusinessObjects Enterprise XI 4.0 > SAP BusinessObjects Enterprise Client Tools > Universe Design Tool.
  2. Select File > Import.
  3. On the Import Universe window, click Browse next to the Folder field, select the root database node, and then click OK.
  4. In the Universe Name column, select ITSM.
  5. Click OK.
  6. In the confirmation dialog, click OK.

To edit the connection to the database

  1. In the Universe Design Tool window, select Tools > Connections.
     The Wizard Connection window appears showing a list of available connections to access data.
  2. Select the ITSM connection.
  3. Click Edit.
     The edit connection window appears showing logon parameters.
  4. Provide the values required to connect to your data source.
  5. Click Test Connection.
  6. After the connection is verified, click Next.
  7. On the Configuration Parameters page, click Next.
  8. On the Custom Parameter page, click Finish.

To configure ITSM universe parameters and export the ITSM universe

  1. In the Universe Design Tool window, select File > Parameters.
     The Universe Parameters window appears showing the Definition tab.
  2. Select a value in the Connection field that points to the BMC product database instance that you want to use for creating reports.
  3. Click the Controls tab, and provide the values required.
    • Ensure that the Limit size of result set to check box is unchecked. This option limits the number of rows that a query can return.
    • Ensure that the Limit execution time to check box is checked. The default value is 10. This option limits the execution time of a query to prevent users from unknowingly executing queries that retrieve large amounts of data and cause a reduction in system performance.
  4. Click the SQL tab.
  5. Ensure that the Warn option is selected in the Cartesian Products group box.
  6. Click the Parameter tab.
  7. Ensure that the value of the ANSI92 parameter is set to Yes so that the universe returns the correct query results.
  8. Click OK.
  9. Click Save.
  10. Select File > Export.
  11. On the Export Universe window, select appropriate universe, and click OK.
  12. In the confirmation dialog, click OK.
  13. Close the Universe Design Tool.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*