sap businessobjects dashboard design - …melorhosts.com/bo/bo/bo4.0training/first...

Lab: Configuring and Using Monitoring

Scenarios1) Schedule monitoring probes to run periodically

2) Create a watch based on a probe output

3) Analyse the probes execution over time from the monitoring dashboards

4) Handle alerts generated by the system and based on the watch defined earlier

5) Report from the trending derby database

ObjectivesIn this lab, you will learn how to:

Schedule monitoring probes and analyze their execution data

Define thresholds based on probes execution output or metrics, and alerts based on these thresholds

Use the Monitoring dashboard available from the CMC

Handle Alerts from the CMC

Create a universe from the trending derby database

Perform the following steps as described in order:

Schedule monitoring probes from the CMC1. Log on to the Central Management Console (CMC) as train-XX (00 or 01)

http://localhost:8080/BOE/CMC

2. Go to Monitoring > Probes

© SAP AG 2010 SAP BusinessObjects /

http://localhost:8080/BOE/CMC

3. Select the CMS Logon Logoff probe and click on Schedule

4. When the Schedule options appear, set the probe to run every 3 minutes from the current time to 24 hours later. We want the CMS Logon Logoff probe to run every 3 minutes while we are working on other exercises and generating some activity on the BOE cluster. We will analyze this monitoring data later on.

5. Select the Crystal Reports Service (Processing Server) probe, and click PropertiesVerify that the probe input parameters are as follows

CUID should be from a Crystal Report from Public Folders > Report Samples > Demonstration (Launch BI Launchpad and get the CUID of this report)


6. Go to the Schedule section and set it to run every 5 minutes for the next 24 hours.

7. Select the InfoView probe and set it to run every 5 minutes for the next 24 hours.

8. You should now see 3 probes set as scheduled from the Probes dashboard. Notice the icon from the Schedule Status column.

9. If the Infoview probe shows a failure, it is probably because the username/password it is using is not correct.

10. Right-click on the probe and select Properties11. Edit the username/password by inputting one of the train-xx users (e.g. train-01, or train-02)

12. Click Save and Close13. Right-click on the probe and select Run Now

14. Click the refresh icon ( ) next to the Enable Auto-Refresh button.

15. If you wish the probe screen to automatically update, select the ‘Enable Auto-Refresh’ button.

Create a watchThe CMS probe is now scheduled and you want to base a watch on it so it generates an alert if the Logon Logoff action takes longer than 200 milliseconds.

1. Go to Monitoring > Watchlist


2. Click on New and define a name, description for your new watch as showed in the screenshot

Set the number of states to Two (OK, Danger) and check the 2 options Show on Dashboard and Write to Trending Database

3. Click on NextBrowse the available metrics and select Probes > BI40SIA.CMSLogonLogoff > executiontimeOn the right panel, set the Danger operator to ‘>=’ and value to 200 (or choose a value that appears just above the current average so that you get some alerts)


4. Click on NextLeave the settings to default: alert notifications will be sent every time the threshold is reached and notifications will be sent to the ‘Administrator’ user.

5. Click on Save to save this new watch.

Get notified when the threshold is reached

When your CMS probe has been running for a few hours you may have sent alerts to the Administrator.

1. Log on to BI Launch Pad


2. From the Home Page, notice the new Alerts from the Alerts module – if you have alerts you will see something similar to this.


3. Click on one of the alerts to view the details


4. Log on to the CMC and go to Monitoring > Dashboard

Notice the alerts on the right panel

Click on “More Alerts” at the bottom of the panel (or to the “Alerts” tab)

5. Click on Filter > All

6. Select one of the alerts from the CMS probe, view the details and confirm it (in reality you will

confirm it once you’ve taken action). You will use the Confirm button for this ,

and also notice how the icon changes from Unread to Read to Confirmed .

Analyze your monitoring dataYour probes have been running for a few hours, you might have received alerts and taken actions and you now want to analyze the data and trends over time.


1. Go to Monitoring > Probes

2. Select one of the probes you scheduled earlier, for instance CMS Logon Logoff

3. From the bottom right graph, select the time window during which the probe has been running

4. Observe the chart being updated with the historic values stored in the trending database, feel free to use the time slider to select a different time window and zoom in and out. If you don’t have much data at the moment, we will look again in 24 hours.


Configure jdbc.sbo for derby driverNow you will configure the jdbc.sbo or derby.sbo file so you can create universe using the Generic JDBC driver or the Apache JDBC driver. You will also need to create a backup of the derby database so you can report from this backup.

1. Edit jdbc.sbo (for Generic driver) or derby.sbo (for Apache) files and add Class Path for derby.jar and Parameter.

2. jdbc.sbo/derby.sbo is: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc

3. Locate the following lines in the jdbc.sbo

<DataBase Active=”Yes” Name=”Generic JDBC datasource”>

<JDBCDriver>

4. Add the following lines right after <JDBCDriver>, save and close the file

<ClassPath><Path>C:\RKT\Monitoring\\derby.jar</Path></ClassPath><Parameter Name="JDBC Class">org.apache.derby.jdbc.EmbeddedDriver</Parameter>

Create a backup of the derby database5. In CMC go to Applications>Monitoring Application and specify a directory for the backup. For

example this can be C:\DerbyDBBackup – the directory will be created automatically. This will create a “derby” subdirectory with the backup files.. Click Save and Restart the Adaptive Processing Server from the Server page of the CMC.

6. When Adaptive Processing Server is up Go back to Applications>Monitoring Application and select to run the database backup task now.


7. When you get the confirmation message:

you are ready to launch Universe Design Tool or Information Design Tool. In this example we will use the Universe Design Tool. If you have extra time you could also try the steps on the Information Design tool.

Create a universe in the Universe Design Tool


1. Login into BI4.0 Universe Design Tool and create Generic JDBC connection

2. Define Login Parameters for UNV universe and point Database URL to Derby DB backup that you just createdDatabase URL= jdbc:derby:C:\DerbyDBBackup\Derby;create=falseJDBC Class= org.apache.derby.jdbc.EmbeddedDriver

3. From Table Browser select three tables from APP scheme


4. Create universe

5. Modify the joins so they look like these

6. Publish UNV universe, close Universe designer and now you can create a Webi report.

Create a universe in the Information Design Tool – Optional ActivityIf you modified the jdbc.sbo, in this activity you will be using the Apache driver so you need to perform the same modification, now in the derby.sbo.

1. Open BI4.0 Information Design Tool and create relational Apache Derby 10 Embedded JDBC connection


2. Define connection Parameters and make sure that Server parameter points to Derby DB on WindowsServer (<host>:<port>)= C:\DerbyDBBackup\Derby;create=false

3. Create single source Data Foundation (DFX) and use connection created in the first step


4. From Table Browser of DF select three tables from APP scheme and move them to Master. Create joins

5. Create Derive table for each table from APP scheme (Define derived table SELECT as: select * from <table_name>)(This step is necessary if table columns are not visible when trying to create joins in previous step)


(Name Deriva table as original table name and add _DT. Example: MANAGED_ENTITY_STATUS_DETAILS_DT)

6. Create joins between derive tables


7. Create Relational Business Layer by using Data Foundation created in previous steps

8. Publish the connection to the BI4.0 repository.(When prompted, click Yes to create connection shortcut which is saved in the Derby project)


9. Go to Data Foundation to change the connection. Choose the shortcut to the secure connection (connection has extension cns)

10. Publish Business Layer to the BI4.0 repository

11. Now you are ready to create a Webi or Crystal Reports using this universe.

End of lab


sap businessobjects dashboard design - …melorhosts.com/bo/bo/bo4.0training/first...

Documents