Is Multiple Data Sets Creation supported for BI Bursting

AshishERPCloud

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

 

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.

AshishERPCloud

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.

Zanith

Hi Ashish,

Do u able to achieve the requirement of busting using multiple data sets?

 

Thanks,

Zanith.

AshishERPCloud

Hi Zanith,

I am unable to achieve this yet.

Kind Regards

Ashish