Developer access to OAC/OAS dataset and workbook configurations

Question

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

Gianni Ceresa · Answer

@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.

GayathriAnand-Oracle · Answer

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.

OAldrich · Answer

@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!