Developer access to OAC/OAS dataset and workbook configurations — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Developer access to OAC/OAS dataset and workbook configurations

Received Response
61
Views
5
Comments
Philippe ROGIERS-Oracle
Philippe ROGIERS-Oracle Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Could a tool be provided for developers to have access to OAC/OAS dataset and workbook configurations : e.g. be able to review and update dataset table configuration (logical SQL, configuration of analysis from Oracle applications), review and update business rules in the dataset. Such tools allow to 'industrialise' much more the management of datasets and workbooks e.g. for duplication and adjustments from gold templates to multiple dataset/workbook instances. Currently we think this information is stored on the server in a Singleton database to which we have no access and partially in the Oracle schema for which we would need documentation

Answers

  • SteveF-Oracle
    SteveF-Oracle Mod

    This may not be your complete request, but the Developer Options provides some of this (although, not really the intention, or fully documented). Additionally, REST API's continue to be rolled out with each release .


    If you intent is to post an enhancement, then you should be searching and up-voting/commenting or posting enhancement in the Ideas Lab

    https://community.oracle.com/customerconnect/categories/idealab-oracle-analytics-cloud-and-server

  • Philippe Lions-Oracle
    Philippe Lions-Oracle Mod

    @Philippe ROGIERS-Oracle , consider checking out the Governance custom extension that is part of the Analytics Library (Analytics Library Extensions for DV | Oracle, scroll down to find this plugin). There is also a YT video that briefly explains it. This will not answer your initial question, but will help you with at least reporting on dependencies.

  • OAldrich
    OAldrich Rank 2 - Community Beginner

    @Philippe Lions-Oracle As a new user of OAC, our organization is struggling to manage datasets and their dependent workbooks. We've upvoted the idealab item above, but are wondering if there is any current mechanism to list dependancies without resorting to the analytics plugin? If we should be directing our inquiry to support, happy to do so as well!

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    Currently the plugin is the only way to get the information you are looking for. Probably dataset APIs will be enhanced as part of future roadmap to be more robust, but as of now this is not there and analytics plugin Philippe mentioned provides the workable solution for this requirement.

  • Gianni Ceresa
    Gianni Ceresa Mod

    @OAldrich ,

    That plugin doesn't do any miracle, it simply call an API and store the result into datasets to "analyze" it.

    You can call that API yourself and get the output and do the job you need with it, without going through the plugin.

    Without going too much into the Oracle cooking behind the scene, seeing how DV is built, this is probably anyway the direction any feature will be built like: DV is all a dynamic front-end run by javascript based on a ton of async calls to undocumented (or to be precise not publicly documented, but there are a good amount of info available on all the existing methods) APIs.

    The request of fully public and documented APIs exists since day 1 of DV (it was VA back then), but still there is little to nothing released.