Schema Changes to the Infrastructure

This article contains the following topics:
casm171
This article contains the following topics:
After the CA BI development environment is established and schema changes have been published to CA SDM using the documented process for customizing schema data, the schema changes are ready to be promoted through the CA BI infrastructure. You can make the new schema available for report creation and modification.
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.
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.
Follow these steps:
  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.
      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.
      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.
Common Schema Modifications
You can implement schema modifications in the Universe. To familiarize you with the process, the following table lists the common schema modifications that you might encounter.
When a field type is defined in Web Screen Painter as...
Follow these rules when using the field in the Universe: Right click the attribute and select...
INTEGER
Object Properties, Definition Tab, Type = Number
STRING
Object Properties, Definition Tab, Type = Character
DATE
Object Properties, Definition Tab, Type = Date
Object Format, Number Tab: Choose category "Date/Time"; Choose Format mm/dd/yyyy hh:mm:ss AM/PM
DURATION
Object Properties, Definition Tab, Type = Number; Object Properties, Definition Tab, Select = PdmSeconds(object.attr)
SREL
Create a CA SDM attribute alias.
BREL
Not Applicable
QREL
Not Applicable
DERIVED
Use an appropriate data type and object format for the value stored in the derived field, if desired. The Derived field can produce any result, so there is not a specific standard to follow.
Special Case: Local
This is not a data type defined within Web Screen Painter, but instead a data type used by the universe sometimes to indicate an unsupported data type.
The Local field is displayed in the right pane of the universe with type "L". These fields can be dragged, but not dropped into a class on the right universe pane. Most often, fields data types such as binary, are not supported by the Universe. However, they can be added to the left pane of the universe by creating an object and placing the PdmString (object.attribute) in the "SELECT" window of the Edit Properties dialog.