Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Improvement Suggestion for Oracle Analytics Governance Plugin
Good morning everyone!
I am using the new update of the Oracle Analytics Governance plug-in.
However, I see that we have two very important pieces of information that are not currently being returned and that would be essential for the traceability of workbook versions.
1. In the generated object SYS.DATASOURCES we have the column "description". It would be very interesting if we had this same column in the object SYS.WORKBOOKS. Because it is there that we inform the User History of the work and the versioning.
2. In the SYS.WORKBOOKS object we only have one row per workbook with the columns "created time" and "last modified". It would be important to have a separate file that returns all workbook updates so that we can have all the versions of the product that have been uploaded to the environment. If possible, it would add a lot of value to the governance of our workbooks/datasources.
Answers
-
Hi,
The forum use English as common language.
Nobody here will look at your grammar, as long as the message is understood that's what matter.
You should consider writing in English if you want to benefit from the whole, global, community (don't expect hundreds of people to use a translator to understand your post).
2 -
Thank you @Gianni Ceresa . I have already edited the message to English.
1 -
Hi Raphael,
Welcome to the community and thank you for posting your suggestions!
Typically, improvements are posted in the Ideas Lab section, but we can make sure the right team is able to see your post.
@Philippe Lions-Oracle , for your consideration.1 -
Thanks @Raphael Gonçalves Silva ,
The custom extension typically exports what the APIs exposes from the OA catalog. Unfortunately, I am pretty sure that API does not expose the history of workbook modifications - I suspect that information is probably not even stored in the webcat, probably only the last modif date is there. However for the workbook descriptions, let us double check if that data is available via the API. @Aravindan Thoppe Santharam-Oracle , @Prasenjit_Thakur-Oracle , would you know on top of your mind ?
3 -
As Philippe said, the catalog doesn't have any versioning logic in place, therefore it can't provide information about previous versions. There is a temporary "content versioning" because one of the table keeps the content of the object (workbook in this case) till a scheduled task clean up the un-linked rows. But those temporary versions aren't accessible by any API as they officially do not exist.
In OAC you can't do much other than running the extraction often, but even in this case you have no way to be sure that more than 1 change happened between the 2 executions.
In OAS, because you have access to BIPLATFORM schema, you could configure a trigger to keep old records when updates happen, but this is beyond the scope of this question.
0 -
Good morning everyone!
I have two questions for possible improvements to the Governance Plugin.
- Is it possible to bring the workbook description field to the API that generates the SYS_WORKBOOKS file?
- Regarding the SYS_DATASOURCES file, is it possible to bring data access?
0 - Is it possible to bring the workbook description field to the API that generates the SYS_WORKBOOKS file?
