KPI and Scorecards In OBIEE 11g

Creation of KPI and Scorecards:

What is a KPI:

A KPI is a measurement of a particular business process which is compared against specific goals and objectives of an organization. KPI’s are typically tracked over time as a way to monitor performance and drive business decisions to help improve upon that performance. KPI’s typically have both a goal and a status that reflects performance relative to the goal. In addition, KPI’s normally are “dimensionalized” – meaning they can be analyzed by any number of defined dimension attributes associated with the KPI.

KPI in OBIEE 11g can be used an analysis dashboard to allow a user to view KPI performance and drill into the details to understand why a KPI value may be off target. KPI’s can also be used to automatically trigger alerts to specific users using OBIEE’s agent mechanism when KPI target values reach critical status levels.

OBIEE KPI’s also can be configured with another new feature – Action Links – which allow the user to initiate a action based on the status of the KPI. The action link can reference another analysis, send an email, kick off a workflow, or any other process to assist in making the KPI the basis for “actionable intelligence”.

How To Create a KPI:

Step 1:

Log in to Oracle Business Intelligence Enterprise Edition 11g, using your username and password. From the home page, select New -> KPI from the common header area. When prompted to select a subject area, select Sample Sales Lite.


The KPI Entry screen will then appear. This screen enables you to define the actual value and target value measures for the KPI, as well as an optional time offset to show performance as a trend. In this example, enter “Base Facts”.”Revenue” as the Actual Value measure and Base Facts”.”Target Revenue” as the Target Value measure, and Click the Enable trending checkbox , as shown in Figure 1. Click Next to proceed to the Dimensionality screen.


Click on Next Button and add Dimension Column as shown below.


On the Thresholds screen, you can specify values that will determine whether the performance achieved warrants an OK, Warning, or Critical indication.


Click Next to proceed to the next step, where you can define related documents for the KPI. This enables users to reference other analyses, external Web pages, and documents that can be used to support the KPI. For this example, however, there are no related documents, so click Finish to move to the final steps, where you can name and save the KPI.


Now repeat this process to create the second KPI in order to display in the Scorecards.

Displaying KPIs, Using a KPI Watchlist:


From the Oracle Business Intelligence home page, select New -> KPI Watchlist.


From the Catalog view on the left-hand side of the screen, drag and drop the two KPIs you created previously onto the watchlist on the right. The selected KPIs will then be displayed in a grid format, showing the actual and target values, along with the variance and the percentage variance, as shown in Figure.

What is Scorecards:

                                    Design of a OBIEE 11g Scorecard ultimately is about the identification of a small number of financial and non-financial measures and attaching targets to them, so that when they are reviewed it is possible to determine whether current performance ‘meets expectations’. The idea behind this is that by alerting managers to areas where performance deviates from expectations, they can be encouraged to focus their attention on these areas, and hopefully as a result trigger improved performance within the part of the organization they lead.

How To Create Scorecards:


After defined your KPIs, you can arrange them into a simple scorecard.


From the Oracle Business Intelligence home page, select New -> Scorecard. When prompted, name the scorecard and click OK to accept the default scorecard settings.


With the new scorecard open, navigate to the Strategy panel at the top left corner of the screen and click the Create Objective button. Name the new objective , and click the Save button just above the text box to save the new objective to the scorecard definition.


When adding this new objective, assign a KPI to it. To do so, use the Catalog panel on the bottom left of the screen and drag and drop the KPI onto the New Objective list for the objective. Click OK to save this objective.


Repeat the above step and create one more Objective and use the Catalog panel on the bottom left of the screen and drag and drop the KPI 1onto the New Objective1 list for the objective. Click OK to save this objective.


To create a new strategy tree, navigate to the Strategy panel at the top left of the screen and this time click the View Strategy Tree button. When the strategy tree appears, expand the entries under the objectives to see the KPIs and their values, as shown in Figure.

Displaying both the KPI’s and Scorecards on Dashboard:


Create a new Dashboard and drag and drop the KPI Watchlists and the Scorecard in to the section area and save the Dashboard such that we can see both the KPI’s and Scorecards in a single Dashboard.

By bidevatapraveenkumar Posted in OBIEE 11g

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s