Oracle Analytics Cloud and Server

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

DV Workbook Owner

Received Response
71
Views
7
Comments

HI,

Is there a way to get the Owner name of the Workbook in Usage Tracking? Users wants to see who is the owner of the workbook in the report.


Thanks in advance.

Answers

  • Join the data of the catalog and you have it.

    The owner isn't an information required in the context of usage tracking, but you get it in various ways as it is available in the catalog. You will need to do the join yourself.

  • Subhakara Netala-Oracle
    Subhakara Netala-Oracle Rank 6 - Analytics Lead

    We want the Owner information in Usage Tracking report to check which user has created how many workbooks or who is the owner of a particular workbook.


    Join the data of the Catalog, can you please give details on this?

  • As said, the usage tracking doesn't have the "owner" info because it doesn't bring any useful information: that data is focused on the usage of objects, not the properties of the objects.

    The owner of a catalog object is stored in the catalog, it is one of the many attributes attached to every single catalog object.

    The catalog is stored in the database in OAS/OAC, therefore you just have to query that (it's technically not supported to modify that data, but if you just read from there, it will do the job).

    If you don't have access to the database (OAC), you should consider using one the available APIs: they should return the owner as part of the various metadata.

  • Shantaram-Oracle
    Shantaram-Oracle Rank 4 - Community Specialist

    I hope you already tried to list the workbooks from the OAC home page which includes the workbook name, owner etc.. Here is the screenshot of What I see.. Will this help?



  • You can also explore the Audit log capability available as part of OCI Logging for OAC. Doc here : Monitor Usage and Diagnostic Logs

    Also look into the DV Governance plugin available here :https://www.oracle.com/business-analytics/data-visualization/extensions/

  • Subhakara Netala-Oracle
    Subhakara Netala-Oracle Rank 6 - Analytics Lead

    Thank you @Gianni Ceresa and @GayathriAnand-Oracle . I will check those options.

  • Subhakara Netala-Oracle
    Subhakara Netala-Oracle Rank 6 - Analytics Lead

    @Shantaram-Oracle , we want to create a report on Owners data, like how many workbook are created by a respective owner to get some insights on DV usage by users. Your suggestion works to check who is the owner but our requirement is different.