Bursting BIP report to different emails by respective business units

Question

Hello guys, am super new to bursting. I am facing an issue with bursting an excel attachment which has 3 tabs (a detailed report, +2 summarized tables by buyer name). The report is exporting normally when we manually run it but with bursting, it is only showing the 1st detailed report tab. With the 2 other summarized table being empty.

Any advice is appreciated, thanks !

Kevin M-Oracle · Answer

Hi Gabriel,

It depends on the data you are splitting by.

You only need one layout for bursting.

Rgds,

Kevin

GabrielWong · Answer

Meaning for example if I have G_1, G_2 and G_3, I should have a layout for each of the dataset instead of 1 Excel template with 3 tabs, is this correct?

Regards,

Gabriel

Kevin M-Oracle · Answer

You should use a different layout for the full report and for the bursting subset of data.

For example if you are splitting on G_1, the layout should not have for-each:G_1 or reference data that is not part of G_1.

Rgds,

KEvin