BI Report With Participant Hierarchy Dimension Is Not Returning Any Data for the Participant Login User (Doc ID 2010947.1)

Last updated on MAY 15, 2015

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Added the participant manager hierarchy to a report. When we sign in as a rep the report comes back with no data.  Report runs fine for the manager


STEPS

Create an BI analysis on subject area "Incentive Compensation - Earning and Attainment Real Time"
with following columns:
   Participant Hierarchy.Manager Name
   Participant Hierarchy.Person Name1
   Participant Hierarchy.Person Name2

   Example Hierarchy :
      VP, IC (login user : IC.VP1 )
        -- Manager1 IC  (login user : IC.MGR1 )
           --  Salesrep1 IC (login user: IC.REP1)
           --  Salesrep2 IC

IC.VP1 user shows:
Manager Name  Person Name1  Person Name2  
IC, VP1       IC, Manager1  IC, Salesrep1
                            IC, Salesrep2

IC.MGR1 user shows:
Manager Name  Person Name1  Person Name2
IC, Manager1  IC, Salesrep1
              IC, Salesrep2

IC.REP1 user shows:
No Results
The specified criteria didn't result in any data.

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