Friday, February 8, 2013

Modifying OBIEE 11g configuration settings

OBIEE 11g has miltiple configuration files and stored redundantly in different location. Changing configurations manually through text editor can be challenging, and admins have to take care that setting are updated and in sync in all the locations. This is even worse if environment is set to be clustered or has redundancy built in.

A better way to manage configuration is through one of the following two tools:

- Fusion Middleware Control - Also called enterprise manager - this is a web based tool that allows OBIEE 11g monitoring and configuration of basic components, like cache, RPD deployment etc. Tool can be accessed using following URL:

http://localhost:7001/em

- Fusion Middleware Control MBean Browser - This is much advanced tool for modifying OBIEE server settings. It internally takes care of multiple instances of config files in diferent directories and redundant servers.

The Mbean Browser can be accessed from within the Fusion Middleware Control, by navigating as below:

Weblogic Domain > bifoundation_domain > AdminServer > Weblogic Server drop down > System Mbean Browser

To start modifying, first step would be to take an exclusive lock on settings by following link:

Application Defined MBean > oracle.biee.admin > Domain:bifoundation_domain > BIDomain > BiDomain > Operations > lock > invoke

After that, admins can make any necessary changes that are required, and hit 'Apply'. After all changes have been applied, it required to select Commit from same screen where lock was acquired. Fortunately we also have rollback option, incase we want to revert at last minute.

Thursday, February 7, 2013

Unexplained intermittent error in OBIEE UAT server only

We made few RPD changes and code was migrated to UAT server. Intermittently, in UAT, we were getting error on report side:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "Dim - Derivative"."Derivative ID". (HY000)

As a work around, we would clear the cache, delete cookies, close browser completely and try again. This time error was gone. The error kept coming back next day, and we could also recreate the issue just be repeating steps for work around.

I asked admin team to look at it, and we found that this was happening due to clustered environment in UAT. Probably one of the server was still pointing to old RPD.

Tuesday, February 5, 2013

Timestamp fields in database not showing in SQL Developer

The new GUI for SQL developer from Oracle, does not seem to show "time" value for a timestamp field when doing a select statement. I tried setting options, but did not help. Till I get a real solution, here is a workaround:

select to_char(calendar_date,'DD-MON-YYYY HH24:MI:SS')) from W_Day_D

Friday, February 1, 2013

OBIEE - How to prevent automatic execution of reports in dashbaord

The ability to disable auto execution of reports is missing in BI. Neither it is not available in OBIEE 10g, nor in OBIEE 11g (up to 11.1.1.6.7 version). Some experts are saying its planned to be available in OBIEE 11.1.1.7 version. Going by number and speed of releases at one release a month, with currently 11.1.1.6.7, we should expect release of 11.1.1.7 within three month, i.e. May 2013.

In the mean time, here are few work around, if this cannot absolutely wait, or you don't plan to upgrade to new version in this time frame:

1. Use Prompts tab in Answers to create a prompt on a field. When this report is run on the dashboard, it will wait for the prompt to be selected, before execution will start. It may be difficult to integrate this with existing dashboard prompts though.

2. Another method is to default dashboard prompt to a dummy value, something like 'Select Month' etc, which will fetch 'No Results' unless users select an actual month. But this makes a prompt to be selected mandatory, and cant be left blank.

3. Last option that I can think of is to create an empty dashboard with just prompts and a basic answers report with out put as text field only. Ask users to select prompt values here, and make available a navigation link to actual dashboard. This way the values can pass either if the prompt has a scope set to "Dashboard", or through "guided navigation", as long as target dashboard has same set of filters.

Good luck.

OBIEE 10g Error from Dashboard layout

We had a requirement where we had hidden two tabs on a dashboard in development. When we requested to migrate dashboard layout to testing environment, we were getting error as below:

Dashboard Display Error
Assertion failure: pRoot at line 107 of /net/sdchs20n529/vol1/users/anabuild/views/nightly/Tue/101341/RH_Linux/vobs/090414.1900/analytics_web/main/project/webxml/xmldocument.cpp
  Error Details (javascript:void(null))
Error Codes: OQ78YWIW
Turns out, we are hitting a OBIEE known bug. When administrator logged in, the error went away, but the dashbaord were not hidden like we had expected. There are two work arounds for this:

  1. Hide the tabs manually in Integration/UAT instead of moving the dashboard layout.
  2. When moving the layout, try to modify the permissions of dashboard layout object, not sure it will work though.