Managing Reports › How to Set Up Data Partitions Security for Reporting › Define Universe Database Credentials

Define Universe Database Credentials

The universe must use the database credentials associated with the BusinessObjects user account.

Note: Verify that you sign on to the BusinessObjects Designer using the Privileged User account and not the Administrator User account.

To define universe database credentials

1. From the Start menu, browse to All Programs, BusinessObjects XI, BusinessObjects Enterprise, Designer.
2. Log on to the Designer.

   The Designer window appears.

3. Select File, Import.

   The Import Universe dialog appears.

4. Select the CA SDM, Knowledge Management, CMDB, or Support Automation Universes folder from the drop-down list.

   Note: If this is the first time you are using the Designer, select Browse, CA Universes.

5. Verify the file path for the import folder in the Import Folder box.
6. Click OK.

   The universe window appears.

7. Select File, Parameters.

   The Universe Parameters dialog appears.

8. On the Definition tab, click Edit.

   The Login Parameters dialog appears.

9. Select the Use database credentials associated with Business Objects user account check box.
10. Click Next, Test Connection, and step through the universe connection dialogs that appear.
11. Click OK to finish.
12. Select File, Export.

    The Export Universe dialog appears.

13. Select the universe that you want to use from the Domain drop-down list.
14. Select Everyone from the Groups list
15. Click OK to export universe changes.