OBIEE REVISITED: April 2012

Monday, 30 April 2012

Dashboard in Drop Down

Below is the method followed to show multiple dashboards with multiple pages in a drop down.
You need to have a default page with static text -HTML enabled and with the following piece of code.

<center>
<html>
<body>
<script type="text/javascript">
</script>
<FORM>
<SELECT NAME="url" onchange="document.getElementById('myframe'). src=this.value"><OPTION VALUE="None" style="font-family:arial;color:red;font-size:90px;">Select a dashboard
<OPTION VALUE="http://usblrnmehandal1:7001/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FTesting%2F_portal%2FTestDashboard&page=Test1">Testdashboard
</SELECT>
</FORM>
<iframe id="myframe" height="1500" width="1500" src="about:blank"></iframe>
</body>
</html>
</center>

If multiple dashboard has to be added then you need to have multiple option values.

Monday, 16 April 2012

Not able to see the connection pool for the session variables

Sometimes when you try to create session variables and select the connection pool for it(if there are many connection pools) then, you are not able to select the required connection pool.

You need to go to the Options-->General-->Allow First Connection Pool for Init Blocks. Check this option.

Now you select the connection pool for the session variables and check. You should be able to see the connection pool.

Wednesday, 11 April 2012

OBIEE services FORCE-SHUTTING-DOWN

Sometimes when you install OBIEE 11g with the help of Administrator and then restart the services then the services shows information of FORCED_SHUTDOWN.

This happened to me because in the below location the username and password was different.

\user_projects\domains\bifoundation_domain\servers\AdminServer\security

Try giving the username and password which is used while installing the RCU. But first check if the username and password is correct or not.

cwallet file will be present in the below mentioned paths. Try opening the files, if you don't have the permissions of Administrator then you will get the 'Access Denied'error pop up. So, ask your administrator to give you the permisssion and restart the services.

\instances\instance1\config\OPMN\opmn\wallet
\instances\instance1\config\JPS
\Oracle_BI1\products\Essbase\EssbaseServer\bin\wallet
\Oracle_BI1\sysman\config\monwallet

Removing Totals of a column

In one of the OTN forum, user asked to remove one of the Totals of a column.
My first thought was javascript.
So below is the report which shows the two dimensions and two measure columns.
Suppose, the user wants to remove the total of the second measure column.

Then first you need to place the report in the dashboard and get the HTML by 'View Source'.
Then you need to find the appropriate td tag and remove it.
This will remove the total of the second column.
Script:

<head>
<script type="text/javascript">
var element1 = document.getElementsByTagName('td');
var count=0;
var classname2 ="TTHT PTHT PTLR PTLC OORT";
for (var j = 0; j < element1.length; j++)
{
var classes1 = element1[j].className;
if (classes1==classname2)
{
count=count+1;
if(count==1)
{
element1[j].parentNode.removeChild(element1[j]);
}
}
}
</script>
</head>

This should help many folks trying to remove bits and pieces.

Tuesday, 10 April 2012

Pivot Table Chart Positions 11g

In the OTN forum questions do come to show the pivot table graph in the required positions.
I am showing 11g screenshot where you can find for chart adjusting.

Monday, 9 April 2012

Displaying Top 2 Values in the Dashboard Prompt

In the OTN forum, a good question was raised for displaying top 2 column values in the prompt according to any measure values.

So, I started by writing a SQL in the Prompts as shown below.
First you need to create a prompt with the dimension column which you need to show for the top 2 values

Secondly, you need to write a SQL in the SQL results

SELECT dim_col FROM subject_area
where rank(measure_column)<3

Thirdly, see the results

Pages