Column Header Mouse Over In OBIEE 11g

You can set Mouse Over functionality over column header of the table.

Step1: Go to column format and check custom heading.

Step2: Add html tag like <b title=”DNAME”>DNAME</b>

Step3: Go to instanceconfig.xml.

Step4: Edit it and add tag – <HardenXSS>false </HardenXSS> in the Server Instance.

Step5: Restart the Services.

Now we can see the Mouse Hover for Column Heading.

By bidevatapraveenkumar Posted in OBIEE

Log Files in OBIEE 11g

Log Files in OBIEE 11g:


In Enterprise Manager Console you can find the Most Recent Errors and Most Recent Warnings. After warning messages, you can also see all the log files grouped by categories using Log Viewer.

Available files:

• Presentation Services Log
• Server Log
• Scheduler Log
• JavaHost Log
• Cluster Controller Log
• Action Services Log
• Security Services Log
• Administrator Services Log

The log files for OBIEE components are found under /instances/instance1/diagnostics/logs

Different type of log files:

Presentation Server log files:

Files: sawlog0.log, webcatupgrade0.log
BI Server log files:
Files: nqquery.log, nqserver.log, servername_NQSAdminTool.log, servername_nQUDMLExec.log, servername_obieerpdmigrateutil.log
Scheduler log:
Files: nqscheduler.log

Cluster Controller log:
Files: nqcluster.log
ODBC log:
OPMN log:

Files: debug.log, logquery~NUMBER.log, opmn.log, opmn.out, service.log

By bidevatapraveenkumar Posted in OBIEE

How to see log level from Presentation Services

Step 1 : Login to answers page http://<hostname&gt;: <port >/analytics/ by using the credentials.

Step2 : Click on new and select a Subject Area, pull any column from the Subject Area.

Step 3 : Go to Edit Formula (fx) of the column and go to variable–>Session Variable now give the value as log level in the server variable and click ok.

Step 4 : Now click on results then we can see the log level which we set in the UI.

By bidevatapraveenkumar Posted in OBIEE

Displaying dashboards in dropdown menu

OBI typically displays the names of the individual dashboards across the top of the screen. Unless we create more than 15 dashboards, it would not show it in a drop-down menu. That is the default dashboards required before they turn out to a menu.

Here we can group the dashboards that were built based out of same subject areas and show a drop down menu as follows:

In order to do that, we need to create dashboards by using the same shared folder and change the instanceconfig.xml file parameter as follows.


So if you have more than 2 dashboards then all the dashboards which comes from the same shared folder will be displayed as menu. And this entry takes effect for all the shared folders.

By bidevatapraveenkumar Posted in OBIEE

Date Last Refreshed in Answers Page

Step 1: Open RPD and Go to ManageàVariables.

Create a new Initialization Block in Session Variables.

Step2: In Variable Target Click on Edit Data Target and create a New Variable.

Step3:  Write the SQL statement  as

SELECT ‘:USER’ || ‘, Data Last Refreshed : ‘ || to_char(sysdate,’DD-MON-YY HH24:MM:SS’)  FROM DUAL

Click the Browse button and browse the Connection Pool.

Open the RPD in Offline mode and Test for the Connection Pool whether it is active or not.

Step 4: Save the PRD, Check consistency.

Step5: Open the Answers Page by using the user credentials then we can see the Username who had login with the date and time of the user login.

By bidevatapraveenkumar Posted in OBIEE

Presentation Table Under Presentation Table

To Create a Presentation Table under Presentation Table in Presentation Layer:


In Table Description give the symbol as -> then we will get that table inside another table with respect to columns.

In PRD we have to give -> under the table Description of the table what we want to the table to be drill.

By bidevatapraveenkumar Posted in OBIEE

Selecting a single value and showing a Range.

This post shows how you can use presentation variables to select a single value in a dashboard prompt and produce a result set that includes a range of values.

Step1: Set a presentation variable with the dashboard prompt.

Step2: Open the Year column in Answers and create the report in this format by giving the SQL Expression and calling the Presentation Variable.

Now the filter Looks like this.

Now click the edit filter and enable the Protect Filter.

Step3: Dont be panic if we click on Display Results then we will get a error its because we are not passing value to the Presentation Variable.

This can be resolved by placing both the prompt and report in the Dashboard.

Step4: Save the report and place the report and prompt in the Dashboard.

By bidevatapraveenkumar Posted in OBIEE

Merging of OBIEE Repositories.

Step 1:

Make sure while merging you are working offline in Administrator tool.

Merging originally designed to work with three repositories. As we have just two repositories we will create a dummy repository.

Go to Administration — > File — > New and create a new repository call Merge.rpd

Step 2:

Open the Paint Merge.rpd in offline.


Step 3:

Merge Paint Rpd with duplicate RPD which we created (Merge).

Go to File — > Merge and select Merge.rpd


Step 4:

Click Select for the Modified Repository and select Sample Sales Merge.rpd

Step 5:

In decision you can either select Modified or Current. As we are merging 2 different repository it is ok. select Merge. You will see an error message called : Delete Failed. Just ignore that message.


Step 6:

Now you will see both the repository merged as below.


By bidevatapraveenkumar Posted in OBIEE

Session Logout in OBIEE 10g.

When a session is idle for 4 minutes on a dashboard and when the user clicks Go button or navigates to another dashboard for access then it should log him out,this can be done by adding  some tags in the instanceconfig.xml file in Windows Environment.
Before doing this please make ensure that you had taken the back up of the instanceconfig.xml file.

<ClientSessionExpireMinutes>4    </ClientSessionExpireMinutes>

Now your requirement will be completed.

By bidevatapraveenkumar Posted in OBIEE

Changing The Precession Of Percent Of Columns In Pivot Table

We have an added feature “Percent of” to find the percentage for a measure w.r.t a dimension in pivot table. Here using this “Percent of” feature we will get the percentages up to single Decimal place only.
If the requirement comes like to increase the Decimal places for this percent of calculated columns. In OBIEE there is no direct option to achieve this requirement. For this we need to alter the Advanced XML to achieve this.
The detailed procedure is as follows. I had worked this task with Paint Repository (Which came by default with OBIEE)

1. Take Markets. Region and Sales Measures. Dollars from Criteria.
2. Go for pivot view.
3. And create one duplicate column for dollars and rename the duplicate dollars column as “Percentage of Region”
4. Now to get the “Percentage of Region” values as percentage of dollars w.r.t Region go for column properties tab and click the Show Data As->Percent of->Column.

5. Now we will get the percentage of values for “Percentage of Region” Column.

6. Here Observe the percentages values and their Decimal places, we have only one decimal place for the values.

7. Now to increase these decimal places we need to alter the Advanced XML as there is no direct option to do this.

8. Click the Advanced Tab to alter the XML.

9. To Increase the Decimal places for percent of column we need to change the “mindigits” and “maxdigits” values to require no. of Decimal places we want to search for the “minDigits” and “maxDigits” tags

Percentage of Region

10. Now change this mindigits and masdigits values to ‘3 ‘ to get 3 decimal places percentage values

Percentage of Region

11. Now click the button and view the results in pivot table
12. And observe the results for percent of column with 3 decimal places as follows

13. By this way we can show the required no. of decimal places for pivot table’s percent of column.





By bidevatapraveenkumar Posted in OBIEE