Oracle Transactional Business Intelligence Idea Lab

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

Ability to automate backup/deploy of analytics and reports on Oracle Cloud HCM BI

171
Views
13
Comments

Description

Currently no tools are available to allow for automated backup and deploy of analytics and reports.

There is no clear way to version our objects. We should also have the ability to store BI objects as code/text instead of binary. The binary objects can fail if you try to import across different versions of Oracle Cloud HCM BI.

Use Case and Business Need

The problem that I am trying to solve is automation of BI analytic/report backups and deploys. There is a compliance and risk problem for us by not having this automated and auditable. With automation options, we would be able to connect deploys to CI/CD pipelines (with appropriate approvals) and satisfy our requirements.

More details

On-premise Fusion BI client tools have options that allow for this i.e. Catalog Manager and runcat.(cmd | sh). This functionality is not usable in Cloud per document - https://support.oracle.com/epmos/faces/DocumentDisplay?id=2261453.1. Oracle should provide a method to allow automated migration of analytics and reports from pod to pod.

Should also have the ability to export BI analytics/reports as code/text to store in a repository.

Original Idea Number: c8cb290e17

5
5 votes

Submitted · Last Updated

«1

Comments

  • Alvaro Couto
    Alvaro Couto Rank 4 - Community Specialist

    Agreed. It is absolutely necessary to have a tool for version control of the reports and analysis in BI Server.

  • Patrick Haston
    Patrick Haston Rank 1 - Community Starter

    I too support this.  As the number of reports we have grows over time we will need tools to help us manage them.

  • Tugce Kucukoner-144150
    Tugce Kucukoner-144150 Rank 2 - Community Beginner

    Yes, we also need this. We lost lots of our reports by different kind of user mistakes and never turn them back

  • JSalarza
    JSalarza Rank 2 - Community Beginner

    yes - pls we need something similar to Oracle Automated CEMLI Execution to be able to use in Fusion BI

  • Rakesh Sreenivasa
    Rakesh Sreenivasa Rank 1 - Community Starter

    Any insights on this will be helpful as code versioning will be of great help in enterprises.

  • Akhil M
    Akhil M Rank 1 - Community Starter

    A must have feature for reporting. Currently we use Github but that doesn't integrate into the application and we are forced to use version control externally. Looking forward for Oracle to bring this feature to Fusion HCM.

  • 3lRob
    3lRob Rank 1 - Community Starter

    I've upvoted, please note I have a similar request here: https://community.oracle.com/customerconnect/discussion/536466/upload-bip-catalog-object-via-web-services#latest. Please upvote so this gets attention. Much needed across all of Fusion BI reporting.

  • MaartenDIF
    MaartenDIF Rank 4 - Community Specialist

    We need tools to automate our backups for our entire Reporting suite. ERP and HCM and anything to come.

  • Ervar Stecher
    Ervar Stecher Rank 1 - Community Starter

    Agree with this idea.

  • Swapnil Kashid
    Swapnil Kashid Rank 4 - Community Specialist

    This idea is much needed when it comes to maintenance of versions for BI Reports and OTBI Analysis