Scheduling a Analysis Subject Area Report to SFTP server — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Scheduling a Analysis Subject Area Report to SFTP server

Submitted
6
Views
3
Comments
narendra kumawat
narendra kumawat Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

Veritas Technologies LLC

Description

We need to send a Report generated through Analytics(OTBI) via New->Analysis straight to a SFTP server. But we can see that this functionality is only available if the report is generated through either New->Reports or New->Data Model. We would want the option to send it to SFTP server available for the Reports generated through New->Analysis.

Use Case and Business Need

Business Users generate most of their reports from New->Analysis as it is convenient and easy for them to generate a report there due to it's simplified UI. But the Users also want that the report to be sent directly to the SFTP server. Since this functionality is not available for Analysis Subject Area Reports, they can't do it. 

More details

In the current scenario, we will have to create a Data Model for every report that had been generated through New->Analysis in the past for it to be sent to the SFTP server. As this is not a feasible solution as every time the user will have to spend time to generate the Data Model and they can't get into much technicalities. We suggest you to add this functionality in other reports generation methods as well. I've attached a file with screenshots describing the situation

Original Idea Number: 43beac9196

3
Up
3 votes

Submitted · Last Updated

Comments

  • John Schmottlach
    John Schmottlach Rank 1 - Community Starter

    We have a similar requirement at multiple customers. We encourage the business and development teams to build their reports as Analyses so that they can leverage the subject area and self service capabilities. However, once the report is built, we are often finding that the output needs to be delivered to a shared location for multiple people to consume the data, or sent off to a different system for processing. We are forced to rewrite these analyses as BI Publisher reports to complete the process.

  • Rachael Puthoff
    Rachael Puthoff Rank 1 - Community Starter

    We have similar requirements. We have multiple vendors that require regular reports and they want it sent to an SFTP site. These reports are analyses in OTBI and we'd love to send them as CSVs to an SFTP site instead of making a data model and report from the analysis and then sending as a CSV to an SFTP site.

  • Hima Bindu Patil -Oracle
    Hima Bindu Patil -Oracle Rank 1 - Community Starter

    A very useful and good idea.

    SFTP should be made available in the 'Destinations' option while scheduling the OTBI report.