Oracle Analytics Cloud and Server Idea Lab

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

Runcat command for all catalog objects

6
Views
1
Comments

Hi,
We’re currently using the runcat command to audit and manage user permissions on catalog objects (e.g., dashboards and analyses) within Oracle Analytics. However, we’ve run into a technical limitation: the tool does not appear to enumerate or return child-level catalog objects within dashboards — specifically “section” objects and their associated metadata. A major customer has requested that we provide access to the complete metadata for all catalog objects, including detailed information on both top-level and nested objects (such as dashboard sections, pages, and components).

Tagged:
1
1 votes

Submitted · Last Updated

Comments

  • Gianni Ceresa
    edited 3:26PM

    It isn't a technical limitation, runcat works at the catalog object level, and it does it correctly. A dashboard page section is not a catalog object, it's a "virtual" object, and is defined by the code of the dashboard page itself. They aren't child objects of the dashboard page, the only catalog object is the dashboard page itself.

    Therefore runcat will not, correctly, return the dashboard page section as an object. The ACL of the section is written in full text in the XML defining the page. You can still get all the information you need by looking into that piece of XML.

    image.png

    But runcat is not expected to work on the dashboard page section, and it would be a mistake to modify it in that direction. Because then, where is the limit? Why wouldn't runcatreturn every dashboard page object (column, section, text, image, etc.), or for an analysis it should then return each view, etc. That's now a job for runcat, because they aren't catalog objects.

    You created this idea before to even get a reply to the same topic you asked in the forum: