BIP 12c Publisher Bursting issue when we have two datasets in one report

User_58V4Z

Hello Experts,

Bursting issue when we have two datasets in one report

Oracle BI Publisher 12.2.1.0.0  (build:20151008.1303)

We have two data sets in one report. 

Dataset 1 : All products purchased and purchase amount

Customer ID : 1

Customer Name : Jack

         Product         No Items   Total Amount

        Laptop            3                 3500

        Smartphone    10                7000

        Charger           25                200

       

Dataset 2

Customer ID : 1

Account Number      Account Currency   Account Balance

10001                          USD             180000

10008                          EUR             25000

We are trying to burst each customers details to customer email. We have another table with Email id and customer id and added in the bursting definition

But when we select customer id from dataset 1 as split by  and deliver by report output received only have the details of dataset 1  and vise versa.

We tried to join the dataset by create link using customer ID. Still the output seems to be like above. whichever dataset selected as the split by and deliver by it is displaying data only for that dataset.

Couldnt figure out on how to rectify this ..