Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX Create Report Query with 2 source queries using Oracle Analytics Publisher

Mihai Badea-OracleJul 4 2023 — edited Jul 4 2023

Hello,

I've created a report in my APEX application using Oracle Analytics Publisher.

I've created a report query and added 2 source queries to it + report layout + configured report fields in Word. Everything is ok, I am able to generate the report in my APEX app.

I am able to display a table for each row in RowSet1 (query 1) using Page as Break. But I am also trying to display RowSet2 (query2) values immediately after the first row in RowSet1 and NOT after all of RowSet1 values are displayed. RowSet1 and RowSet2 have a common column.

The final display should be

rowset1 first row
```
  rowset2 rows related to rowset1 first row
```
1. rowset1 second row
  
  rowset2 rows related to rowset1 second row
2. rowset1 third row
  
  rowset2 rows related to rowset1 third row

Is this possible using Oracle Analytics Publisher?

Thank you!

This post has been answered by Federico Venturin on Jul 5 2023

Jump to Answer

Added on Jul 4 2023

#apex, #bi-publisher

4 comments

1,004 views

1 mention