Universe Design Tool Refresh Table

---

Add Schema Changes to Derived Universe

Promoting schema changes into the CA BI infrastructure is as straight-forward as adding the new schema object to the derived universe.

Note: Before you begin, verify that the appropriate steps have already been completed, and the new schema objects have been added to the CA SDM flexible schema.

To add schema changes to the derived universe

1. Open the BusinessObjects Designer, and import the derived universe to a local file system as follows:
   1. Select File, Import from the Designer menu.

      The Universe Successfully Imported dialog appears.

   2. Click OK.
2. Refresh the structure of the derived universe as follows:
   • Select View, Refresh Structure from the Designer menu.

     The following questions appear:

     • "Do you want to refresh the out of date columns in selected tables?" Click OK.

     Note: If the message "No update needed" appears, it means the CA SDM object layer has not been appropriately updated with the new schema. Review the steps for publishing schema changes to CA SDM.

   • "Refresh structure: The structure has been successfully modified." Click OK.

   New columns appear in the universe structure on the right side of the window, making new object(s) available for use within the derived universe.

   The objects are available to the CA BI tools after they are moved from the right pane to the left pane. When you add objects to the left pane, make sure that you follow the common schema modifications standards.

3. Drag and drop the new object(s) to the desired location in the left pane.
4. Click Save.
5. Select File, Export from the Designer menu.

   The Universe Successfully Exported dialog appears.

6. Click OK.

   Changes added to the derived universe schema are exported to the local CMS.

7. From the Designer menu, select Tools, Check Integrity.
   1. In the dialog that appears, select the Parse Objects check box. (Do not change other settings.)
   2. Click OK. The integrity check is started.

      Note: No parse errors should be reported. If errors are found, modify your objects in the left pane so that they do not produce parse errors.

8. Click OK to close the dialog.
9. Export the derived universe to the CMS as follows:
   1. Select File, Export from the Designer menu.
   2. From Domain field drop-down list, select <Browse>, and then locate and select CA Customer Universes.
   3. Click OK to export the universe to the local CMS.

   The Universe Successfully Exported dialog appears.

10. Save your changes and export the CA SDM universe.

    The changes are now available in your CA BI reporting environment, including Web Intelligence and Crystal Reports.

---

Copyright © 2013 CA. All rights reserved.

Universe Design Tool Refresh Table

Source: https://ftpdocs.broadcom.com/cadocs/0/CA%20Service%20Desk%20Manager%2012%209-ENU/Bookshelf_Files/HTML/CA_SDM_Impl_ENU/add_schem_chg_to_univ.html

Posted by: hatcherdeconsenry.blogspot.com

Share this post