http://support.businessobjects.com/documentation/product_guides/default.asp
■ product: Crystal Reports Server
■ release: BusinessObjects XI Release 2
To obtain a license key for Crystal Reports Server, contact BMC Customer Support.
8 Install the Crystal Reporting Designer product.
9 Use a ZIP file utility to open the downloaded file BMC_PM_Reports.zip, and extract the BMC_PM_Reports.biar and BMC_PM-BusinessView.xml files.
Installing the reporting integration components
Installing the reporting integration components is a manual operation that is performed on the Report Server host computer.
Before you begin
The following prerequisites must be met:
Table 18 Reporting integration prerequisites (part 1 of 2) Product or component Prerequisite
Crystal Reports Server Crystal Reports XI release 2 SP2 must be installed
The Oracle client must be installed on the Crystal Reports server and it must be in the executable path.
You need a Windows Administrator user name and password for the Crystal Reports server host computer.
You need a user name and password with Crystal Reports Administrator rights to log on to the Crystal Reports server (Business View Manager and Java InfoView).
Installing the reporting integration components
BMC Performance Manager Portal and BMC Datastore
The BMC Performance Manager Portal and database must be configured for continuous data export (CDE). For information about configuring the CDE database instance, see “Continuous data export configuration” on page 172.
For the reports that you want to generate, the appropriate Performance Managers listed in Table 19 on page 156 must be installed and collecting data.
After Performance Managers have been collecting data for several hours, run the following command on the Portal host computer:
bpmcli -portal portalWebServerHostName -login superadmin -pass superadmin -c refreshDatafeedMetadata
where portalWebServerHostName is the Portal Web Server host computer, and the correct superadmin user name and password are inserted.
You need a user name and password for the continuous data export (CDE) database.
Table 19BMC Performance Manager components required for various reports (part 1 of 3) Report Performance Managera Application class or Knowledge Module BMC Performance
Manager Availability Report
BMC Performance Manager Express for Unix/Linux
appropriate application classes for the operating systems in your environment:
appropriate application classes for the operating systems in your environment: Table 18 Reporting integration prerequisites (part 2 of 2)
Product or component Prerequisite
Installing the reporting integration components
appropriate application classes for the operating systems in your environment:
PATROL KM for Microsoft Windows Operating System
Table 19BMC Performance Manager components required for various reports (part 2 of 3) Report Performance Managera Application class or Knowledge Module
Installing the reporting integration components
To import the BMC_PM_Reports.biar file
1 Choose Start => Programs => Business Objects => Crystal Reports Server => Import Wizard.
2 In the Import Wizard, click Next to begin the import process.
3 In the Source environment page, choose Business Intelligence Archive (BIAR) File in the Source drop-down menu.
4 Click the Browse button to the left of the BIAR file field.
5 Browse to and select the BMC_PM_Reports.biar file.
6 Click Next.
7 In the Destination environment page, enter or confirm the following information:
8 Click Next.
appropriate application classes for the operating systems in your environment:
a You can use Performance Managers or PATROL KMs with PATROL Integration, or both.
CMS Name host name of the destination Central Management Server (CMS), if it is not present
User Name user name that has the Crystal Reports Administrator privilege, if it is not present
Password password the corresponds to the user name
Table 19BMC Performance Manager components required for various reports (part 3 of 3) Report Performance Managera Application class or Knowledge Module
Installing the reporting integration components
10 In the Incremental import page, click Next.
11 In the A note on importing server groups page, click Next. 12 In the User and groups page, click Next.
13 In the Categories page, click Next.
14 In the Folders and objects page, select BMC_PM, and then click Next. 15 In the Select application folders and objects page, click Next.
16 In the Import objects for universes and connections page, click Next.
The Preparing for import page opens, displaying the following selections:
■ 1 Folders selected
■ 7 Objects selected
This page might remain open for several minutes. The title then changes to Ready to Import.
17 Click Finish
The Import Progress dialog box opens.
18 When importing is complete, click Done. To import the BMC_PM-BusinessView.xml file
Existing customers do not need to import the BMC_PM-BusinessView.xml file again.
1 Choose Start =>Programs => Business Objects =>Crystal Reports Server => Business View Manager.
2 In the Log On to BusinessObjects Enterprise dialog box, enter or confirm the following information:
System host name of the Central Management Server (CMS), if it is not present User Name user name that has the Crystal Reports Administrator privilege, if it is
not present
Password password the corresponds to the user name
Authentication Enterprise, unless your Crystal Reports environment was configured to use a different authentication method
Installing the reporting integration components
4 In the Welcome to Business View Manager window, click Cancel. 5 In the Business View Manager menu, choose Tools => Import.
6 In the Import dialog box, click Choose XML, and then browse to and select BMC_PM-BusinessView.xml.
7 Highlight the root level of the hierarchy.
The root level of the hierarchy has the form CMS_server_name [user_name].
8 Confirm that Overwrite if CUID exists and Preserve CUID when importing objects are selected.
9 Click OK.
10 In the confirmation dialog box, click Yes.
The BMC_PM-BusinessView.xml file is imported and the following message is displayed:
Business views have been imported successfully.
11 Click OK to close the dialog box.
The BMC_PM folder is created in the Repository Explorer pane of the Business View Manager.
12 (optional) Confirm that the following components are displayed under the BMC_PM folder:
■ DROCR_BPMAccountElements
■ DROCR_BPMAccountElements - Prompt Group
■ DROCR_BPMConnection
■ DROCR_BPMElements
■ DROCR_BPMFoundation
■ DROCR_BPMPromptElements
■ DROCR_BPMView
To change the reports definition
1 Choose Start =>Programs => Business Objects =>Crystal Reports Server => Business View Manager.
2 In the Log On to Business Objects Enterprise dialog box, enter or confirm the following information, and click OK:
Installing the reporting integration components
3 In the Welcome to Business View Manager window, click Cancel.
The BMC_PM folder appears in the Repository Explorer pane of the Business View Manager.
4 Double-click the DROCR_BPMFoundation report.
5 In the Object Explorer, expand Tables.
6 Update the value of the Qualified Table Name property on the ACCOUNT table:
A Select the table and navigate to the Property Browser under Object Explorer. B Edit the Qualified Table Name property.
Example: If you are using the default BMC Datastore, change the value to CDE.ACCOUNT.
C Save this change and accept all subsequent prompts.
7 Update the value of the Qualified Table Name property on the ELEMENT table:
A Select the table and navigate to the Property Browser under Object Explorer. B Edit the Qualified Table Name property.
Example: If you are using the default BMC Datastore, change the value to CDE.ELEMENT.
C Save this change and accept all subsequent prompts.
8 Restart the Report Application Server.
To modify the business view to point to the CDE database
1 Choose Start =>Programs => Business Objects =>Crystal Reports Server => Business View Manager.
System host name of the Central Management Server (CMS), if it is not present User Name user name that has the Crystal Reports Administrator privilege, if it is
not present
Password password the corresponds to the user name
Authentication Enterprise, unless your Crystal Reports environment was configured to use a different authentication method
Installing the reporting integration components
3 In the Business View Manager, in the Repository Explorer pane, expand the BMC_PM folder.
4 Double-click DROCR_BPMConnection.
5 In the Object Explorer pane, right-click DROCR_BMCConnection, and then choose Edit Connection.
6 In the Choose a Data Source dialog box, expand Oracle Server (click the plus sign to the left of Oracle Server).
7 In the Oracle Server dialog box, enter the following information:
8 Click Finish.
9 In the Choose a Data Source dialog box, click OK.
10 In the Set Data Connection Password dialog box, enter the CDE database credentials, and click OK.
Unless you changed them, you can use the following default credentials:
■ user name: CDE
■ password: CDE
11 In the Business View Manager, choose Tools => Test Connectivity. 12 Choose File => Save.
At this point, you can continue with step 4 in the following procedure.
To refresh the list of values for Account/Elements selection lists
1 Choose Start => Programs => Business Objects => Crystal Reports Server => Business View Manager.
2 Log on to the Crystal Reports computer where you installed the .biar and .xml files.
3 In the Business View Manager, in the Repository Explorer pane, expand the BMC_PM folder.
Service a string in the form serverName:port/cdeDatastoreInstance (for example, mercury:1521/bmccde)
User ID the user name for the CDE database instance Password the password corresponding to the user name OS authentication leave the box unchecked