How to add ServiceDesk schema changes to CA Business Intelligence derived universe?

book

Article ID: 52971

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

This document describes the procedure to add the custom schema changes of ServiceDesk to CA ServiceDesk derived universe in BOXI.

Solution:

Note: Before following the procedure, make sure the new schema object(s) have been added to the CA ServiceDesk schema.

To add schema changes to derived universe:

  1. Open the Business Objects 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 box appears.

    2. Click OK. Figure 1.1, 1.2

      Figure 1.1

      <Please see attached file for image>

      Figure 1

      Figure 1.2

      <Please see attached file for image>

      Figure 2

  2. Select View->Refresh Structure from the Designer menu

  3. A question "Do you want to refresh the out of date columns in selected tables?" Figure 2

    Figure 2

    <Please see attached file for image>

    Figure 3

  4. Click on OK.

  5. A dialog box with message "Refresh Structure: The structure has been successfully modified" appears. Figure 3

    Figure 3

    <Please see attached file for image>

    Figure 4

  6. New objects or columns added to the schema are available on the right side of the window. In this example a new column zRisk was added to the chg object Figure 4

    Figure 4

    <Please see attached file for image>

    Figure 5

  7. Expand the Change class on the left hand side window. Drag and drop the updated chg object from the right hand side window to left hand side window under Change class. Figure 5

    Figure 5

    <Please see attached file for image>

    Figure 6

  8. Click on File->Save to save the changes.

  9. To make the changes available for universe users, export the universe to CMS. Select File->Export from the designer menu.

  10. In the Export Universe menu click on OK. A dialog box with "Universe successfully exported message appears". Figure 6

    Figure 6

    <Please see attached file for image>

    Figure 7

  11. In the Designer Menu, select Tools->Check Integrity, in the dialog box that appears, select Parse Objects check box. Figure 7

    Figure 7

    <Please see attached file for image>

    Figure 8

  12. Click OK to start the integrity check.

  13. No parse errors should be reported. If errors are found the objects need to be modified on the left hand pane so that they do not produce parse errors. Figure 8

    Figure 8

    <Please see attached file for image>

    Figure 9

  14. From the Designer menu, select File->Export

  15. In the Domain drop down, select CA Customer Universes. Figure 9

    Figure 9

    <Please see attached file for image>

    Figure 10

  16. Click on Ok to export the universe to CMS.

Environment

Release:
Component: ARGIS

Attachments

1558720877495000052971_sktwi1f5rjvs16vuo.gif get_app
1558720875375000052971_sktwi1f5rjvs16vun.gif get_app
1558720873532000052971_sktwi1f5rjvs16vum.gif get_app
1558720871570000052971_sktwi1f5rjvs16vul.gif get_app
1558720869729000052971_sktwi1f5rjvs16vuk.gif get_app
1558720867708000052971_sktwi1f5rjvs16vuj.gif get_app
1558720865929000052971_sktwi1f5rjvs16vui.gif get_app
1558720863904000052971_sktwi1f5rjvs16vuh.gif get_app
1558720861724000052971_sktwi1f5rjvs16vug.gif get_app
1558720859380000052971_sktwi1f5rjvs16vuf.gif get_app