Oracle Analytics Publisher

Bursting Report

Received Response
19
Views
1
Comments

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 ✭✭✭✭✭

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

    Rgds,

    Kevin