Binding multiple datatable inside Repeating section grouping by one of the column of one of the data — Oracle Analytics

Oracle Analytics Cloud and Server

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

Binding multiple datatable inside Repeating section grouping by one of the column of one of the data

Question
41
Views
0
Comments

Summary

Binding multiple datatable inside Repeating section grouping by one of the column of one of the data set.

Content

I have repeating section in Oracle BI Publisher report. In this repeater I wants to bind two data tables from two different data models (Data Sets). Both the data sets are linked with a common column. Now the issue is with the link  dt1.col1 --> dt2.col1, the dt1 data set repeats the whole dt2 records. Thus duplicate records being displayed. How can I avoid this scenario ?