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

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.2
      
      

      <Please see attached file for image>

      
      
      
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>

   
   
   
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>

   
   
   
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>

   
   
   
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>

   
   
   
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>

    
    
    
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>

    
    
    
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>

    
    
    
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>

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

Environment

Release:
Component: ARGIS