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

Document ID : KB000049165
Last Modified Date : 14/02/2018
Show Technical Document Details

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

    Figure 1

  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>

    Figure 2

  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.

    Figure 3

    Figure 4

    Figure 5

  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

    Figure 6

  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

    Figure 7

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

    Figure 8

  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

    Figure 9

    Figure 10

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

    Figure 11

    Figure 12

  8. On the USER and GROUPS screen, click NEXT

    Figure 13

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

    Figure 14

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

    Figure 15

    Figure 16

    Figure 17

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

    Figure 18

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

    Figure 19

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

    Figure 20

  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

    Figure 21

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

    Figure 22

    Click on OK

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

    Figure 23

  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

    Figure 24

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

    Figure 25

    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

    Figure 26

  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