OBIEE 11g : Data Filters not working and fail to trigger
Last updated on FEBRUARY 12, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11g]
Information in this document applies to any platform.
On Oracle Business Intelligence Enterprise Edition (OBIEE) 11g,
After a restart of the OBIEE services due to a planned maintenance activity, on the Analytics the Data Security was not implemented and all users were having access to all the data. Once again the OBIEE services were restarted and after that, when the reports were checked in Analytics, the Data Filters were working again.
Event 1: Planned restart of the app services as a maintenance activity
Event 2: Session variable (used for data filter of the Report) not initialized with a value and has no value definition [if the logs are gathered at the time of issue, this could be seen in nqserver.log]
Event 3: Restart of the OBIEE services
Event 4: Session variables refreshed and hence are not null. Hence data security working.
What could be the cause of the issue and how to avoid or prevent this ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms