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

book

Article ID: 49165

calendar_today

Updated On:

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>

    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>

    <Please see attached file for image>

    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.

    <Please see attached file for image>

    Figure 3

    <Please see attached file for image>

    Figure 4

    <Please see attached file for image>

    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

    <Please see attached file for image>

    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

    <Please see attached file for image>

    Figure 7

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

    <Please see attached file for image>

    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

    <Please see attached file for image>

    Figure 9

    <Please see attached file for image>

    Figure 10

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

    <Please see attached file for image>

    Figure 11

    <Please see attached file for image>

    Figure 12

  8. On the USER and GROUPS screen, click NEXT

    <Please see attached file for image>

    Figure 13

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

    <Please see attached file for image>

    Figure 14

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

    <Please see attached file for image>

    Figure 15

    <Please see attached file for image>

    Figure 16

    <Please see attached file for image>

    Figure 17

  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>

    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

    <Please see attached file for image>

    Figure 19

  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>

    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

    <Please see attached file for image>

    Figure 21

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

    <Please see attached file for image>

    Figure 22

    Click on OK

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

    <Please see attached file for image>

    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

    <Please see attached file for image>

    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.

    <Please see attached file for image>

    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

    <Please see attached file for image>

    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

Environment

Release:
Component: SDBOXI

Attachments

1558712522378000049165_sktwi1f5rjvs16sot.gif get_app
1558712520559000049165_sktwi1f5rjvs16sos.gif get_app
1558712518623000049165_sktwi1f5rjvs16sor.gif get_app
1558712516988000049165_sktwi1f5rjvs16soq.gif get_app
1558712515155000049165_sktwi1f5rjvs16sop.gif get_app
1558712513298000049165_sktwi1f5rjvs16soo.gif get_app
1558712511262000049165_sktwi1f5rjvs16son.gif get_app
1558712509518000049165_sktwi1f5rjvs16som.gif get_app
1558712507836000049165_sktwi1f5rjvs16sol.gif get_app
1558712505884000049165_sktwi1f5rjvs16sok.gif get_app
1558712503766000049165_sktwi1f5rjvs16soj.gif get_app
1558712501780000049165_sktwi1f5rjvs16soi.gif get_app
1558712499797000049165_sktwi1f5rjvs16soh.gif get_app
1558712497947000049165_sktwi1f5rjvs16sog.gif get_app
1558712495802000049165_sktwi1f5rjvs16sof.gif get_app
1558712493915000049165_sktwi1f5rjvs16soe.gif get_app
1558712492072000049165_sktwi1f5rjvs16sod.gif get_app
1558712490204000049165_sktwi1f5rjvs16soc.gif get_app
1558712488000000049165_sktwi1f5rjvs16sob.gif get_app
1558712486043000049165_sktwi1f5rjvs16soa.gif get_app
1558712484032000049165_sktwi1f5rjvs16so9.gif get_app
1558712481933000049165_sktwi1f5rjvs16so8.gif get_app
1558712480057000049165_sktwi1f5rjvs16so7.gif get_app
1558712478313000049165_sktwi1f5rjvs16so6.gif get_app
1558712476432000049165_sktwi1f5rjvs16so5.gif get_app
1558712474069000049165_sktwi1f5rjvs16so4.gif get_app