AIM: Build key performance indicators and scorecards in your business intelligence metadata with Oracle Business Intelligence Enterprise Edition 11g.
Download the RPD from the path oracle.com/technetwork/issue-archive/2010/10-nov/o60bi-170650.zip
The password of RPD is "password".
Creating KPIs
We are planning to create 2 KPIs Sales Performance and Margin Maintenance. Later we will be using these KPIs to create a scorecard .To create the KPIs, take the following steps:
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 Sales History.
2. 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 "Sales and Costs Fact"."Amount Sold" as the Actual Value measure and "Sales and Costs Fact"."Amount Sold Target" as the Target Value measure, and leave the Enable trending checkbox unchecked. Click Next to proceed to the Dimensionality screen.
Note: We can change the data type if required by editing the Data Format.
3. In this example, you want users to be able to switch the product category for which the KPI is displayed but you want the year, 2001, to stay constant (or "pinned"). To do this, click the Add button on the Dimensionality screen, select the "Times"."Calendar Year" attribute, and select 2001 for Value. Then click Add again to add the "Products"."Product Category" attribute column, but leave Value as <is prompted>. Click Next to proceed to the next step in the process: defining the states.
4. On the States screen, you can specify values that will determine whether the performance achieved warrants an OK, Warning, or Critical indication. In this example, performance will be considered OK if it is within 90 percent of the target and critical if it falls below 70 percent. To define these thresholds, enter "Sales and Costs Fact"."Amount Sold Target" * .90 as the first threshold value and "Sales and Costs Fact"."Amount Sold Target" * .70 as the second.
Note: We can add more levels if required. Select the Show Advanced Properties for this.
5. 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 Next.
Note: We can add either a catalog object (eg: report) or links here.
6. This enables users to manually create a custom column for the KPI. For this example, however, there are no custom attributes. Click Finish to move to the final steps, where you can name and save the KPI.
7. Now repeat this process to create the second KPI, which will be used to monitor the margin made on sales. Enter the "Sales and Costs Fact"."% Unit Margin" measure for Actual Value, but this time enter the literal value 40 for Target Value (because you want to ensure that sales have a target margin of 40 percent). Use the same attribute columns for the KPI dimensionality, and enter the values 25 and 10 as the two thresholds. Once complete, save the KPI to the Web catalog, using the name Margin Maintenance.
Displaying KPIs, Using a KPI Watchlist
Now that you have defined two KPIs, you can give users a means of displaying these on a dashboard through a KPI watchlist. To create a KPI watchlist, take the following steps:
1. From the Oracle Business Intelligence home page, select New -> KPI Watchlist.
2. 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.
3. The KPI watchlist will be pinned to the year 2001, per your KPI definitions, but it will enable users to select the product category. To select a specific product category, use the list next to the "Sales History"."Products"."Product Category" label above the KPI watchlist and select a category such as Photo or Electronics. Note how the KPI values are recalculated in response to your product category changes in this dimension and how the status changes to reflect the values compared to the thresholds you chose earlier.
Creating a Scorecard
Now that you have defined your KPIs, you can arrange them into a simple scorecard to help achieve your organization’s goals. Using this scorecard, you will define an objective, "Improve Performance," that breaks down into two contributing objectives, "Increase Sales" and "Maintain Margins." Users will be able to use this scorecard to view progress toward the organization’s goal, either for all product categories or for any one category in particular.
To create the scorecard, take the following steps:
1. Login to Oracle Business Intelligence Enterprise Edition 11g using your username and password, and select New -> Scorecard. When prompted, name the scorecard Organizational Performance and click OK to accept the default scorecard settings.
2. 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 Improve Performance, and click the Save button just above the text box to save the new objective to the scorecard definition.
3. With the objective you just created selected in the Strategy panel, repeat this process to create another objective, naming it Increase Sales (this new objective should be located under the Improve Performance objective, to indicate that it contributes to the broader objective).
4. 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 Sales Performance KPI onto the Objectives and KPIs list for the objective. Click OK to save this objective.
5. Now repeat the previous step, with the Improve Performance objective initially selected—but this time creating a third objective, Maintain Margins—and associate the Margin Maintenance KPI with it.
Your Strategy panel within the scorecard should now have a primary objective, Improve Performance, with two contributing objectives, Increase Sales and Maintain Margins, under it. To complete the initial scorecard, you will now create a strategy tree to show how these objectives are related.
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.
This strategy tree shows that the Sales Performance objective is being met across all product categories but the Maintain Margin objective is not, contributing to a warning about the overall objective. Use the dimension selector above the strategy tree to focus on individual product categories to see how each of them is performing against the targets and the thresholds you defined earlier.
Summary
Organizations often use KPIs and scorecards to measure their performance in terms of reaching an objective, setting targets and thresholds to enable them to measure progress across the organization. Oracle Business Intelligence Enterprise Edition 11g gives you the ability to define these objectives and strategies within your BI environment, bringing this important measure of corporate performance to the desktops of everyone on your team.
