Essbase data filters do not work and two users see same data in OBIEE report

(Doc ID 2199093.1)

Last updated on JANUARY 10, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


Problem Summary
The analysis returns the same result when different user sign in with different security access.

Problem Description
OBIEE is integrated with Essbase. You have two different security access to Essbase data: full access and district access. With caching enabled in OBIEE,it was found that district access user would see all the data as full access user have already cached the result. OBIEE should leverage  Essbase security to allow different access users to see their own result based on the security setup. However, it looks like there is a bug in how OBIEE manage cache as the district access user would use full access user's cache.


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