Missing data in Bursting BIP report

Question

I have 2 data models which are independent of eachother

1st data model has details

2nd data model has summary that shows a count of records

in bursting, my 1st data model table shows data as expected but my 2nd data model table shows column headers with no data.

However, when i run the report from back end it shows both tables with data

also, when i republish from scheduled process for bursting it again shows correct data.

But when i download the output file it shows missing data for summary table.

and output received over mail also shows missing data for summary table.

Does anyone know what might be the issue?

Thanks,

Ninad

Kevin M-Oracle · Answer

You need to organize the data so that there is a shared level for each group.

Then split-by and deliver-by elements in G_1.

Ex. DATA_DS

G_1 (parent)

G_2

G_3

G_1 is your new group and G_2 and G_3 are the original groups.

Rgds,

Kevin

Ninad Joshi · Answer

Please check the word file for screenshots for further clarification