Skip to main content

key performance indicators in obiee 11g

KPI (Key Performance Indicator), Performance of an organization by using measures.
Strategic updates and information about an organization performance.
KPI is based on comparing Actual and target performance.

Steps To Develop a KPI:

Step 1:

Click on new Γ  click KPI under Performance management.

Step 2:

There are 5 steps to complete the KPI performance management to define Actual and target comparisons.
1.       General Properties
2.       Dimensionality
3.       States
4.       Related Documents
5.       Custom Attributes



Step 3:

General Properties:
In this section we are going to Set the actual values and target values from the subject area which we designed in RPD (Admin Tool).
Business Owner you can set based on the requirement and administrator privileges.

Set the actual value and target value from the tables from subject area using the key button.
Here itself you can define the function or calculation using the key FX.


Data format is to set the format of the data at output, the number format, decimal format, percentage format are the different mode of showing data.


Check in Enable Trending, Which is used to compare the actual and target value based on the period or some other dimension and as well as measures.

Tolerance can be depends on percentage or as actual value.


Step: 4

Dimensionality:
Dimension tables can add to get the actual and target value by prompted or for a particular dimension we can get the output.


Here I have used 3 dimensions for the actual and budget variation. 2 dimensions are prompted and one dimension is meant for one particular value. So according to this the values are get filtered and shows in output.

To Add Dimension table Use the Tab with the name of “Add…
You will get the subject areas under that all the tables and columns will get display.

Step 5:

States:
KPI States which is used to compare the values between actual and target, it will shows the status of the report.
KPI - state, define a label, color, and icon. Determine state ranges by defining threshold values between each state.
State Properties has three types
1.       Goal – High Values are Desirable
2.       Goal – Low values are Desirable
3.       Goal – Target Value is Desirable

High Values are Desirable
– which includes the compared value which is higher and Greater than100% of the target value then the status will say ok and with the user – defined color.

If the value is between 90% and 100% of the target value then the status will display as warning with the user – defined color.

If the values are between less than 90% of the target value then the status will display as critical with the user defined color.

Status label is a user – defined, you can alter the status label according to client requirement.

Color is a user – defined, you can define the color according to client requirement by clicking down arrow on the color box.


Icon is a user – defined, you can define the icons for the status according to client requirement.


Actions:
It is used to link to some other report or Dashboards or other kpi’s or to some WebPages by clicking on the value.


Low Values are desirable

If the value is more than 100% of the target value then the status will display as Critical with the user – defined color.

If the value is between 90% and 100% of the target value then the status will display as warning with the user – defined color.

If the value is less than 90% of the target value then the status will display as critical with the user – defined color.


Target Value is Desirable

In this goal it will compare the target value and shows the status according to it.
For the entire goal you can change the color, status label, icons, Actions and threshold values and its percentage.

In case if the KPI returns with no data then it can show No Status or critical or ok or Warning depends on the users.

We have one more option in the states “Show Advanced Properties” which is used to link the score in this KPI.

Score will have User value, Use percentage of target, use percentage of variance, and use a custom expression.

Here you can show the target value based upon the percentage of target value and variance value or by manual value filled by user.

We can add more Status like ok, warning, critical and more with threshold values and conditions.


Step 6:

Related Documents:
You can add some of the related Documents by using this KPI.
Adding a document is two type of mode one type is Catalog and another one is by Link.

Step 7:

Custom Attributes:
Manually you can create columns and you can add some of the calculations by using formulas.

Click finish to save the KPI and Check in the report.

Comments

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope