OBIEE KPI'S

KPIs are:

• Metrics to measure the performance of an organization relative to its strategic objectives.

KPIs are measurements that define and track specific business goals and objectives that often roll up into larger organizational strategies that require monitoring, improvement, and evaluation.

KPIs have measurable values that usually vary with time, have targets to determine a score and performance status, include dimensions to allow for more specific analysis, and can be compared over time for trending purposes and to identify performance patterns.

KPI status is determined by comparing its actual value against its named ranges that you

define. The performance status of a KPI is represented throughout the system using a

provided or custom status symbol that you assign to each range. In this example five ranges

are defined for a product sales KPI in which high values (those exceeding 125) are desirable.

• • x< = 50: Values less than or equal to 50 indicate critical performance.
• • 50 < x <= 80: Values greater than 50 but less than or equal to 80 indicate a warning of poor performance.
• • 80 < x <= 100: Values greater than 80 but less than or equal to 100 indicate acceptable performance.
• • 100 < x < =125: Values greater than 100 but less than or equal to 125 indicate good performance.
• • x > 125: Values exceeding 125 indicate ideal performance.

1.Creating a KPI:  Home-->Click on New -->KPI-->Select the Subject Area

2.Define General Properties 

Use the General Properties pane to assign the business owner responsible for the KPI,

include actual and target values for the KPI, and allow trending.

3. Enable Trending

Select the Enable trending option to compare KPIs for prior periods and to indicate an
increase or decrease in performance.

 

4. Tolerance

The tolerance can be entered as a percent or as an actual number that represents a difference (change) from the prior period. To represent the tolerance as a percentage, select % from the drop-down list.

Click Next to get Dimensionality pane

5.Dimensionality :

 Dimensionality pane to aggregate KPI values, target values, and ranges, using dimensions in the subject area