Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Aaron Leggett
    BI Publisher Bursting by Multiple Datasets
    Topic posted December 10, 2018 by Aaron LeggettSilver Trophy: 7,500+ Points, last edited September 11, 2019, tagged Packaging & Licensing, Reporting 
    174 Views, 2 Comments
    Title:
    BI Publisher Bursting by Multiple Datasets
    Content:

    Hi All, 

    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? 

    Thanks

    Aaron

    Comment

     

    • Pradeep Sharma

      Hi Aaron

      Are you using Bursting query in data model to burst data, or are you using the Excel Template splitting technique to split data into multiple sheets? From description it seems like you are using Excel template splitting technique. If you use the Bursting query, you do not require multiple tabs in your excel template. From your requirement you seem to be creating one tab output for one data set and another tab output for second data set. I think this can be achieved by the splitting technique in Excel Template. If you create concatenated data set, you should be able to split each portion and separate into a new tab. 

    • Aaron Leggett

      Hey Pradeep,

      This is where it gets complex; we are using the Excel Template Splitting Technique and it is working well. When we manually run the report we get the output expected (data from each dataset on separate tabs). However, we then need to automate this and burst the output by each individual project to our FTP server. Not sure if it is possible to burst multiple datasets, I have seen some examples from the early 2010s/pre-2010 regarding data templates and multiple queries, but I am not getting the option to do this on Fusion BI Publisher.