Sunday, June 29, 2014

OBIEE 11g: Writeback Done Button Does Not Refresh Data Displayed

Today I faced this issue in 11g....

After implementing writeback, data is not refreshing at front-end (i.e. report or dashboard), but data is updated in database. To get updated data, we need to purge OBIPS and OBIS cache.

This is a bug in OBIEE 11g, here is metalink prof....


APPLIES TO:

Business Intelligence Server Enterprise Edition - Version: 11.1.1.5.0 [1308] and later   [Release: 11g and later ]
Business Intelligence Suite Enterprise Edition - Version: 11.1.1.5.0 [1308] and later    [Release: 11g and later]
Information in this document applies to any platform.

SYMPTOMS

In OBIEE 10g, after you click on the Update button you could see the results of the writeback in the dashboard. Now, in 11g it does not seem to refresh. You can see the new data in the database but not in the dashboard.

CAUSE
This is expected behavior in 11g. In 11g dashboards do partial refresh because it's more efficient. 

SOLUTION
A dashboard page refresh (from top right Page Options) refreshes all the dashboard's content and shows the new data. 

There is an enhancement request to re-introduce the functionality of OBIEE 10g.  For more information see Bug 13058029 - write back auto-refresh in 11g.

-Asifkhan P.

No comments:

Post a Comment