Showing posts with label KPI. Show all posts
Showing posts with label KPI. Show all posts

Sunday, August 21, 2011

OBIEE11g Creating KPI Watchlist

Once you have defined all your KPI’s you can add them to a watchlist:
From your analytics home select KPi Watchlist
image
Select add KPI:
image
Select the KPI you want to watch (one at a time)
image
Leave the prompt on Point of view
image (if you have only a laptop install you might want to put in some restrions ….. Knipogende emoticon.
image
Switch to the details tab and enter a description:
image
Set the owner (Adam Bell)
image
Add some related documents:
image
Save the watchlist:
image
and start playing around.
Be aware: KPI wachtlist are very very big resource eaters and might cloug up your laptop!
Till Next Time

Saturday, August 20, 2011

OBIEE11g Creating a KPI

One of the major new features in OBIEE11g are the KPI and Score carding functionalities. Before you can make a scorecard you first need your KPI’s. (check out wiki: http://en.wikipedia.org/wiki/Performance_indicator)

Let’s make a basic KPI:

open OBIEE analytics and select Performance Management KPI:

image

Select the sample sales subject area

image

Start with a proper description:

image

Select the KPI owner (Adam Bell)

image

Select 1 – Revenue as the actual value:

image

Select  5 – Target Revenue as Target Value

image

Enable Trending:

image

Let’s do this on a monthly basis:

image

Press Next:

image

The dimensionality define’s how out KPI can be sliced and diced:

image

Let’s select Year, Quarter and Month and the products and office hierarchy:

image (You can use multiselect)

image

Click Next

image

Lets define the state level triggers:

image

Say 95 & 97 %

image

Click Next

image

Add a link to the wiki definition

image

Click Next

image

Add a custom Attribute AVG Revenue:

image

Click Finish

image

Give it a usefull name:

image

Goto your home and open the KPI:

image

Till Next Time