OBIEE REVISITED

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

Pages