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 11.1.1.9.160119 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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