nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

derive FTP output parameters - Remote Filename and Remote Directory automatically

GaneshMat

HI, We have created BIP reports with pl/sql type and when we try to schedule them with output option → FTP, it requires to input Remote Directory and Remote Filename. Is there any option to get those values from lookup or any other way to avoid human errors ?

Find more posts tagged with

BI Publisher

OTBI

Report Output

Report Delivery

Accepted answers

All comments

GaneshMat

Hassan El Bouihi-Oracle

Hi Ganesh,

You could use bursting and provide all the required parameters there.
When scheduling the job, the user will not be prompted for the destination.

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/add-bursting-definitions.html

Thank you

Hassan

GaneshMat

Hassan El Bouihi-Oracle

Hi Ganesh,

You could use bursting and provide all the required parameters there.
When scheduling the job, the user will not be prompted for the destination.

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/add-bursting-definitions.html

https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm

Thank you

Hassan

GaneshMat

Does bursting option works if data model is created with of procedure call ?

Hassan El Bouihi-Oracle

Unfortunately it does not work with Procedure call.

I would request an enhancement request in the Idea Labs portal.
I would ask to have the "Remote Directory" and the "File Name" defined as part of the FTP server setup.
Just like the username/password is defined in the FTP server setup screen.

This way, the user does not have to fill them out as they will be defaulted from the FTP setup screen.

Thank you

Hassan

GaneshMat

it shouldn't in FTP server setup as we may have different reports to send to different folders with different file name. we may use the same report with different parameters to generate a output file accordingly. so, we need to an option either type directly or an option to choose from a list.

Hassan El Bouihi-Oracle

Please share your feedback in the Idea Labs. You are right. some customers may have to use different directories and file names.

GaneshMat

yes, i have posted in there as well.

https://community.oracle.com/products/oracleanalytics/discussion/21479/derive-remote-directory-and-remote-file-name-from-a-lookup-or-a-specific-content-rather-typing

Hassan El Bouihi-Oracle

Thank you Ganesh.

Hassan