KPI - OBIEE 11g

Key Performance Indicators.

The name itself is self explanatory as to what a KPI is. So how do we implement this?

My system is a 64 bit windows platform running OBIEE 11g.

Lets dive into the topic straight away!!

In order to create a KPI, we must first be aware of what the has to be measured and against what the measured quantity has to be compared. Once we have a good understanding of these, let us start the process:n

1. Log into the presentation services. Go to 'New' and under 'Performance Management' select KPI

2. There are a total 5 different steps that have to be completed before the KPI is saved and set up. The 5 steps are as follows:

• General Properties
• Dimensionality
• States
• Related Documents
• Custom Attributes

3. In General Properties, we have to provide the following details:

• Description of the KPI
• Business Owner : The user who is being assigned the ownership of the KPI
• Actual Value: This is the value that we are actually measuring. This is the proper current data.
• Target Value: This is a value against which we are comparing the Actual Value. It can be a column in the database or else it can be a calculated field that can be calculated using the expression wizard provided.
• Enable Trending: You can either enable or disable trending and if you enable it, you have to mention the compare to prior value and the provide the tolerance as well.

4. In the Dimensionality step we have to define the KPI value. When we say define the KPI value, what is meant is that this where we give the criteria's against which the Actual Value and the Target Value will be measured.

5. In the States step, you have to mention the states of the KPI.. i.e.. for instance what % to what % is a good value.. what range should be assigned to warning and under what value will the KPI show as critical. This is but an example. You can use whatever values and how much ever states as is required.

6. In the Related Documents step, you have to either fill the related documents that are there with respect to the KPI. This can be another KPI we made or some report or something related. Fill this info if you have related documents.

7. In the Custom Attributes step to build the KPI, we mention any custom attributes we want added in our KPI. WE can build up the expression using the expression builder provided.

8. Once this is done click Finish and Save the KPI in your desired location.

9. Once it is saved, go to your catalog open the KPI to view your KPI.

Voila.. The KPI is created and displayed.

- Cheers

      Gautam.

OBIEE 11g Customization in windows7 64 bit platform

The intention of this post is to perform a few customizations. Version of OBIEE used is 11.1.1.6.0 and the platform it is installed in is Windows7 64 bit.

We will be referring to changing the Oracle logo visible in the login page and concurrent pages, the background image visible when signing in and signing out, and the text next to the oracle logo.

• Initially log into the Enterprise Manager using the link : http://localhost:7001/em
• Select Business Intelligence, then core application
• In the availability tab  select processes sub tab to view all the OBI Service components
• Bring down all the services using the 'Stop All' button.

Currently we have bought down all the services. Now we have to edit a few files.

To change the Oracle_logo in the login page and the concurrent inner pages, navigate to the two paths mentioned below:

C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\sk_blafp\b_mozilla_4
 

C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\sk_blafp\login


Replace the oracle_logo.png file with the corresponding image you want displayed.

This is will lead to the Oracle logo being removed and replaced by your own logo.

To change the background of the login page and the page displayed while logging out, we have to navigate to the below mentioned paths:

C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\sk_blafp\login


C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1347382400875\xmlpserver.ear\q37fhu\xdo\images


C:\OBIEE11gHome\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\bipublisher_11.1.1\gyyvtu\war\xdo\images

 Replace the file 'background_blue_whitegradient_.png'


To change the  text displayed next to the oracle logo, we have to navigate to the below mentioned path:

C:\OBIEE11gHome\Oracle_BI1\bifoundation\web\msgdb\l_en\messages

Open the productmessages.xml file. Find the portioned mentioned below:


<WebMessage name="kmsgHeaderBIBrandName"><TEXT>Business Intelligence</TEXT></WebMessage>


Replace the portion 'Business Intelligence' with the text of your liking to change the the header text.


Go to the Enterprise Manager and start the services using the 'Start All' button.

Once this is done, navigate to the OBI login page using : http://localhost:7001/analytics  and enjoy the changes made!

Cheers!

Sqldeveloper not working with Oracle11gR2 database on 64 bit windows 7

When installing Oracle11gr2 database in a 64 bit windows machine, we might encounter an issue  where in the Sql Developer  that comes along with it doesn’t work. 

This is because the sqldeveloper coming along with the 11gR2 version of the Oracle Databse doesn’t support the 64 bit OS.

 

sqldeveloper.exe is a 32-bit exe that is being shipped on Windows 64-bit and it cannot load the jdk dll's.

So how do we solve this?

Simply download the version 2.1 of Oracle SQL Developer Oracle Technology Network

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The version 2.1 is documented as supporting 64- bit Windows platform.

Once the 64- bit sqldeveloper is doqnloaded and the java path is provided, it works perfectly.

Have a nice day!

-Gautam

Image Paths in OBIEE 11g

Locations where the images have to be placed so as to use it in analysis’ are:

• E:\OBIEE11g_Home\Oracle_BI1\bifoundation\web\app\res
• E:\OBIEE11g_Home\Oracle_BI1\bifoundation\web\app\res\s_blafp\images
• E:\OBIEE11g_Home\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\s_blafp\images

 

Once images are placed in these paths, restart the OBIEE presentation services.

In an analysis column, go to ‘column properties’ – Style Tab - Image

 

 You are all set.. Cheers!..