General OBIEE

Get Involved. Join the Conversation.

Topic

    Ashish Harbhajanka
    Is Multiple Data Sets Creation supported for BI BurstingAnswered
    Topic posted July 14, 2015 by Ashish HarbhajankaGold Crown: 30,000+ Points, tagged Report Delivery, Report Output, Reports, Sample Reports 
    122 Views, 3 Comments
    Title:
    Is Multiple Data Sets Creation supported for BI Bursting
    Summary:
    Multiple Data Sets in BI Bursting
    Content:

    This is with reference to Oracle Fusion HCM Applications

    Say we want to have a report which would hold Person Details as one Data Set (Parent) and Email Address (Child Data Set).

    We then need to burst the Data to a SFTP Folder

    Can we do this , if so please help with a simple example

    Thanks

    Ashish

     

    Best Comment

    Wade Wilson

    Hi - The same should apply for multiple data sets. You can add a second bursting in the data model. You would use a different Split By/Deliver By for each bursting. We do this to email to HR Reps vs Workers' managers and they are in separate data sets.

    Comment

     

    • Wade Wilson

      Hi Ashish,

      This appears to be doable. I dug up some sample code that one of my teammates used.

      SELECT 'key' AS "KEY"
           , '<TemplateName>' AS TEMPLATE
           , 'en-US' AS LOCALE
           , 'text' AS OUTPUT_FORMAT
           , 'FTP' AS DEL_CHANNEL
           , '<SFTPServerName>' PARAMETER1
           , '</directory/location>' PARAMETER4
           , '<file.txt>' PARAMETER5
           , 'true' PARAMETER6
      FROM dual
      

      This link explains the parameters. Just scroll to the 'FTP and SFTP' section - http://docs.oracle.com/cd/E23943_01/bi.1111/e22258/add_burst_def.htm#BIPDM394

      Hope this helps.

    • Ashish Harbhajanka

      Hi Wade,

      Thanks for replying, but am looking for multiple data-sets.

      The one you are referring to is the most commonly known and widely used calssic single data-set example which I am aware of am looking for a multi data-set example

      Thanks

      Ashish

    • Wade Wilson

      Hi - The same should apply for multiple data sets. You can add a second bursting in the data model. You would use a different Split By/Deliver By for each bursting. We do this to email to HR Reps vs Workers' managers and they are in separate data sets.