How to manually import the out of box CA Business Intelligence (CABI) Service Desk CABI report content.

Products

• 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:

Normally, the out of the box CABI report content is imported via the 'CA Business Intelligence Configuration' program from the CABI install media.

However, there might be circumstances where it would be necessary to manually import the out of the box CABI Service Desk content.

Solution:

One of the uses of the Business Objects Import Wizard application is to import content into CABI environments from a Business Intelligence Archive Resource (BIAR) files.

Note: You will need access to the CABI install media (DVD#2)

Verify CABI - Service Desk ODBC Connectivity

1. Ensure that the CA Service Desk ODBC services on the Service Desk primary server are running
   
   

   <Please see attached file for image>

   
   
   
2. On the CABI server, launch the 32-bit ODBC program. If CABI is installed on a 64-bit OS, you can launch the 32-bit ODBC program from START -> PROGRAMS -> BUSINESS OBJECTS XI 3.1 -> BUSINESSOBJECTS ENTERPRISE -> 32-BIT DATA SOURCE
   
   
3. Go to the SYSTEM DSN tab and locate and select the ODBC connection (casd_<Service Desk Primary Server Name>
   
   

   <Please see attached file for image>

   
   
   
4. Click on CONFIGURE
   
   
5. Click on the TEST CONNECT button and enter a Service Desk username and password for a Service Desk user that has ADMIN rights. A successful test should result.
   
   

   <Please see attached file for image>

   
   
   

   <Please see attached file for image>

   
   
   

   <Please see attached file for image>

   
   
   
6. Click on OK, followed by APPLY and then OK

Manually Import Out of Box CABI Service Desk Content

1. Launch the IMPORT WIZARD program on the CABI server (START -> PROGRAMS -> BUSINESS OBJECTS XI 3.1 -> BUSINESSOBJECTS ENTERPRISE -> IMPORT WIZARD)
   
   
2. Click NEXT on the WELCOME SCREEN
   
   

   <Please see attached file for image>

   
   
   
3. In the SOURCE drop-down field, select 'Business Intelligence Archive Resource (BIAR) File'. In the BIAR FILE field, navigate to the following file on the CABI install media - \ca_tps.nt\CABO\data\CA_ServiceDesk_Reports.BIAR. Click on NEXT
   
   

   <Please see attached file for image>

   
   
   
4. In the DESTINATION screen, enter the BOXI Administrator password. Click on NEXT
   
   

   <Please see attached file for image>

   
   
   
5. A progress bar appears showing the BIAR file load progress.
   
   
6. On the selection screen, click on CLEAR ALL to clear all selections. Then select just the following and click on NEXT:
   
   Import Users and User Groups
   Import Folders and Objects
   Import Repository Objects
   Import Universes
   
   

   <Please see attached file for image>

   
   
   

   <Please see attached file for image>

   
   
   
7. On the IMPORT SCENARIO and INCREMENTAL IMPORT screens, leave the defaults and click on NEXT
   
   

   <Please see attached file for image>

   
   
   

   <Please see attached file for image>

   
   
   
8. On the USER and GROUPS screen, click NEXT
   
   

   <Please see attached file for image>

   
   
   
9. On the FOLDER AND OBJECT screen, select the CA REPORT folder and click on NEXT
   
   

   <Please see attached file for image>

   
   
   
10. Leave the defaults for the next three (3) screens as below:
    
    

    <Please see attached file for image>

    
    
    

    <Please see attached file for image>

    
    
    

    <Please see attached file for image>

    
    
    
11. The PREPARING FOR IMPORT screen appears. Once available, click on the FINISH button to start the Import process
    
    

    <Please see attached file for image>

    

Verify CABI Service Desk Universe Connection

1. Launch the DESIGNER program on the CABI server (START -> PROGRAMS -> BUSINESS OBJECTS XI 3.1 -> BUSINESSOBJECTS ENTERPRISE -> DESIGNER)
   
   
2. Enter the credentials for the BOXI ADMINISTRATOR account and click on OK
   
   

   <Please see attached file for image>

   
   
   
3. Click on TOOLS -> CONNECTIONS. In the CONNECTION LIST window, locate and select the CA SERVICE DESK connection. Click on EDIT.
   
   

   <Please see attached file for image>

   
   
   
4. Enter the following information:
   
   Authentication Mode : Use specified username and password
   User name: ServiceDesk username
   Password: ServiceDesk username password
   Data Source Name: Select the same ODBC connection as referenced in step #3 of the 'Verify CABI - Service Desk ODBC connectivity' section above
   
   

   <Please see attached file for image>

   
   
   
5. Click on the TEST CONNECTION button. A message stating 'Connection Successful' should be displayed
   
   

   <Please see attached file for image>

   
   
   Click on OK
   
   
6. Ensure that the CONNECTION POOL MODE setting is configured as follows
   
   

   <Please see attached file for image>

   
   
   
7. Click on NEXT and then click on FINISH on the next screen
   
   
8. Back on the Designer main screen, select FILE -> IMPORT
   
   
9. Click the top BROWSE button and navigate to the CA UNIVERSES folder and click on OK. The CA SERVICE DESK Universe will appear in the Universe section. Click on OK
   
   

   <Please see attached file for image>

   
   
   
10. Once the import is complete, click on FILE- > PARAMETERS and click on the TEST button. A message stating 'Connection Successful' should be displayed.
    
    

    <Please see attached file for image>

    
    
    Click on OK
    
    
11. Click on FILE -> SAVE
    
    
12. Once the save is complete, select FILE -> EXPORT. Select all the groups in the GROUPS section and click on OK
    
    

    <Please see attached file for image>

    
    
    
13. Once the export is complete, click on the OK button and close the Designer program.
    
    
14. Test the out of box Service Desk CABI reports from Infoview to ensure that they work correctly

Environment

Release:
Component: SDBOXI