OBIEE 11g not showing/listing dashboard name for a new dashboard in the drop down menu

When creating New dashboard in  OBIEE 11g, we were faced with issue that dashboard name did not show up in drop down dashboard menu.

I did some research, and this is what I found:

1. When you create a new dashboard under 'Shared Dashboard', it displays a warning, that "This dashboard will not appear in the "Dashboards" menu"

2. To make the dashboard appear in the menu, after you create new dashboard under 'Shared Folders', click  New > Dashboard again, and select newly created dashboard in step one as the folder, then give a name. 

3. Now after you create it second time, it will show up in the list.

Hope that helps, very different than in 10g

OBIEE 11g Bug - Unable to edit column properties

We installed OBIEE 11.1.1.5 version, and in one of the report in analyze, we were unable to edit column properties, becasue the edit properties icon was not showing up for attribute columns. Turns out, that this is a known bug in 11g.

Workaroung is to create report again from scratch (painful).

Uninstalling Obiee 11g instance on a linux red hat platform

Here are the steps followed to uninstall 11g:

1. Take backup of nqsconfig.ini file at following path: (using pftp)

/MiddlewareHome/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1/

2. Take back up of instanceconfig.xml file at following path:

/MiddlewareHome/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1

3. Take back of RPD OracleBIAnalyticsApps_BI0002.rpd at following path:

/MiddlewareHome/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository

4. Take backup of web catalogue:

/MiddlewareHome/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/EnterpriseBusinessAnalytics

5. Back the patch files for BP2

6. Run deinstaller (Xming should be running for this as this is GUI based):

>cd /MiddlewareHome/Oracle_BI1/oui/bin

>./runInstaller.sh -d

7. Uninstall weblogic and leftovers using brute force (fastest method known to man)

>cd /MiddlewareHome

>rm -rf wlserver_10.3/

8. Remove all directories under /MiddlewareHome

I reinstalled after performing above steps and it did work.

Delay in BI reports showing up

We had a direct database request in BI answers. When user click on report to see the output, BI was taking unusually long time just to show the clock to indicate query is working.

We found out, it the option ‘Bypass Oracle BI Presentation Services Cache’ that was adding a long delay. It wasn’t required, so removing it made the report work just fine.

Copying Items OBIEE in My Folders to another machine by administrator

We have several occasions when a user is transferred from a department to another and his work needs to be handed over to new person. All the work is often saved under users My Folder.

Well there is only one way to access user’s My Folders but administrator, and that is using catalog manager in ‘offline’ mode. I don’t know why it won’t let you access in online mode..