Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bursting Report

Received Response
11
Views
1
Comments
Saher
Saher Rank 4 - Community Specialist

Hi everyone,

I need your help regarding bursting report.

I created two Data models G_1 and G_2.
In G_1, The query fetches the list of employees whose probation is about to end. (5 employees no of rows )
In G_2 The query fetches the list of representative data(3 Representative)

Both queries are working fine in Datamodel file.

For Table 1, the information is repeated several times in the image below, but the information in Table 2 is accurate.

Now, the requirement is to send the list of 5 employees, to all their respective representatives.

I'm stuck at one point How can I show & hide the one representative list to another representative? in RTF file?

Thanks

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    I would suggest you reorder the data, select the reps first, have the employees be dependent on the reps.

    Rgds,

    Kevin