OBIA 11g Procurement Dashboard - Drill Down/Child Report Is Not Filtering The Parent Report's Column Values

(Doc ID 1585469.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

BI Apps Version: 11.1.1.7
Environment: LINUX
DWH DB: 11G R2
OBIEE: 11.1.1.7.1

Dashboard Navigation: Procurement-----> Spend Analyzer ----> Spend By Organization

For the report "Spend by Top Business Units" , click on any row for Column "Spend" value , which shows "Drill Down to Next level" and clicking on it taking to Report "Spend by Top 10 Categories".
The parent Value "Top Business Unit" is not getting filtered (NOT getting is prompted) to specific parent value on which we have clicked in the child report.
The child report "Spend by Top 10 Categories" is not filtering parent report "Top Business Unit" value and Grand Total results in child are also not matching between pare
 

Solution

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