Oracle Analytics Cloud and Server
BI Publisher Bursting by Multiple Datasets
We have a very complex report requirement encompassing a total of 3 different datasets (this can be compressed to 2 as one is a 'Summary' dataset and we can summarize within the two detailed sets). Now, we have developed an XML Excel template that has 3 tabs; one for Summary and two for Detailed. Ideally, we would like to have one Data Model and burst each dataset onto its retrospective tab. Currently, we are only able to burst 1 dataset at a time, therefore we have to execute a script on our own server to merge each excel sheet into one excel document.
Can anyone offer any guidance or advice as to how we can burst multiple datasets from one data model onto one excel template?