RISKMASTER Business Intelligence Working with Reports User Guide

(1)

(2)

Statement of Confidentiality

This documentation contains trade secrets and confidential information, which are proprietary to Computer Sciences Corporation. The use, reproduction, distribution or disclosure of the documentation, in whole or in part, without the express written permission of Computer Sciences Corporation is prohibited. This documentation is also an unpublished work protected under the copyright laws of the United States of America and other countries. If this documentation becomes published, the following notice shall apply:

(3)

3.1 Accessing a Scheduled Document ... 11

3.2 Running a Report Manually... 13

3.2.1 Using the Navigation Panel to Find a Report ... 13

3.2.2 Running a Report Manually Based on Date Range... 14

3.2.3 Running/Saving The Export to Excel Report... 19

3.2.4 Using the Search Field to Find a Report ... 23

(4)

1 Introduction

Business Intelligence uses Business Objects to access and report on the information stored in Chubb Services (CLAIMWATCH) database. Business Objects is the integrated query, reporting, and analytical tool designed for the web and for Windows. Business Objects enterprise reporting enables you to access data, format it, and deliver it as information inside and outside your organization.

2 Logging in to Business Objects

1. Launch your Internet Browser.

2. Enter the Chubb URL (https://cscbi.chubb.com) and press Enter on your keyboard.

The Chubb Login page opens.

3. In the Login section, enter your Chubb Username and Password and then select the Submit button.

(5)

The Business Objects Log On to InfoView page opens.

4. In the User name field, enter your user name.

Note: The Business Objects and Chubb user name are typically the same, but the passwords may vary.

5. In the Password field, enter your password.

If you have problems logon please one of the person below: AJ Kerrigan Gene Vasquez Andy Kerrigan Office 908-903-7179 Office 908-903-7189 Office 908-903-3310

Cell 908-319-3761 Cell 732-673-9578

6. Select the Log On button.

The InfoView Home page opens.

(6)

******************

Important Please Read

******************************

Internet Explorer’s security settings may prevent reports from being saved to your

computer. If this happens, you’ll see a message that looks like this:

If you click on the gold bar and select the Download file option, the page will refresh and

force you to re-run your report. To prevent this from happening, follow these steps:

• From within Internet Explorer, go to the Tools menu and click Internet Options

(If you do not see a Tools menu, hold down the Alt key on your keyboard and hit the

letter T)

• Click on the Security tab

• Click on Trusted sites

(7)

• Click the Sites button

(8)

• Type https://cscbi.chubb.com into the top box and click the Add button

(https://cscbi.chubb.com should appear in the Websites box)

• Click the Close button

• Click the Custom level button

(9)

• Change the Automatic prompting for file downloads setting to Enable, then

click the OK button

(10)

• If you get the following message, click the Yes button

• In the Internet Options window, click the OK button

(11)

3 Working with Reports

3.1 Accessing a Scheduled Document

1. You must first log into the InfoView Portal (see previous section) before you can navigate to a report from the navigation panel. 2. In the Navigation panel to the left of your window, open Home and

then open My Folders.

All scheduled documents are delivered to the Inbox for your user account under My Folders.

3. Under My Folders, select Inbox.

The Inbox displays in the right-hand-side frame and lists the delivered documents.

(12)

4. To view a report, in the right-hand-side frame, click on the report name. Note: To learn how to view the schedule history of a report, proceed to the

Running a Report Manually section of this document.

(13)

3.2 Running a Report Manually

If required, you can manually run a report even if it has been

scheduled to run automatically. To manually run an existing report, do one of the following:

• Navigate to the report from the navigation panel.

• Search for a report using the Search Title field on the InfoView Home page.

3.2.1 Using the Navigation Panel to Find a Report

One way you can find your reports is to navigate to them using the folder structure located in the left frame of the InfoView Portal. In your client folder you will see two sub-folders: One for manual reports that you can run yourself and another for the reports that are scheduled to run automatically.

For example, to look at previous instances of a report that is delivered to you on a schedule, navigate to the Scheduled folder. When you select the Scheduled folder a list of report files that are scheduled to run automatically are displayed in the right-hand-side frame.

Note that each report has a series of links below the report name.

(14)

• Select the View Latest Instance link to view the latest instance of the report.

• Select the History link to view the previous runs of the report.

3.2.2 Running a Report Manually Based on Date Range

Sometimes you might want to manually run reports using a particular date range.

1. To manually run a report, navigate to the Manual folder. 2. From the right-hand-side frame, select the report name.

•

The system displays a message telling you that it is processing the report.

Click on the report name and you see the dialog box below.

(15)

• A prompt displays asking you for input to enter a date range.

3. Enter your criteria and select the Run Query button. For this report this will be your output.

(16)

• The As Of Date is the ending period you want. Claim period is the period for all claim history. This is usually from the

beginning of the program until the month end you need. Financial period is usually the first day and last day of the month end in claim period. You must also enter the client code for the client you want to run this report for.

(17)

4. To save this report on your computer you click on the word

“document” then the word “Save” then “to my computer” then to PDF.

(18)

5. You now see a save dialog box you will click on save. You must tell the computer were to save the report and click on Save. Click on close after the file has been saved on your computer. You can now open this PDF report from your computer and email this report.

(19)

3.2.3

Running/Saving The Export as an Excel Report

Sometimes you might want to manually run reports using a particular date range and have the ability to save this in Excel..

1. To manually run a report, navigate to the Manual folder. From the right-hand-side frame, select the report name.

The system displays a message telling you that it is processing the report. Click on the report name

2. From the right-hand-side frame, select the report name.

(20)

• A prompt displays asking you for input to enter a date range.

(21)

• Claim period is the period for all claim history. This usually is from the beginning of the program until the month end you need.

Financial period is usually the first day and last day of the month end in claim period.

You must also enter the client code for the client you want to run this report for.

3. Enter your criteria and select the Run Query button. Your output will look as below.

(22)

4. To save this report on your computer you click on the word “document” then the word “Save” then “to my computer” then to Excel.

5. You now see a save dialog box you will click on save. You must tell the computer were to save the report and click on Save. Click on close after the file has been saved on your computer. You can now open this PDF report from your computer and email this report to whom you want.

(23)

3.2.4 Using the Search Field to Find a Report

1. To search for a report, on the InfoView Home page, in the Search Title field, enter the report name.