Hey Marco, The error may be related to OTBI trying to process CHR as a separate function. I tried to test with evaluate... but it's disabled on our pod (and probably yours). EVALUATE('chr(%1)' AS INTEGER, 10) Error: [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to…

Karthik, I too would find value in being able to query this. So I’m hoping others respond who may know. I think I discovered a workaround when I was looking at the services (https://bi-aufsn4x0<pod>.oracleoutsourcing.com/xmlpserver/services) for BI… It seems the ‘getObjectSecurityXML’ call in the security service…

Using the Report functionality with Subject Area, you should be able to SFTP a .DAT file. I'm not sure I'd recommend that because there are better, more efficient ways to do this. We use the data model or extract/report combination for integrations with requirements similar to this where we also need full automation.…

Hi Suveer, Are you using SFTP to deliver the file? You can specify filename in the output when using SFTP. Regards.

Hi Gaurav. This seems like a bug. You should probably create an SR or check the versions listed in this document to see if any of these apply to you - https://support.oracle.com/epmos/faces/DocumentDisplay?id=403584.1 Thanks.

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.

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'…