OBIEE 12c need to Generate Catalog Provisioning Report (Object Path, Permissions, etc.)

Alvaro_Soares

Hi everyone,

I'm trying to generate a provisioning report in OBIEE 12c, and I’m facing some challenges.

I’ve been using Catalog Manager, but there are hundreds of objects in our catalog, and none of the existing reports seem to provide the exact data I need.

What I’m specifically looking for is a report that includes, for each catalog object:

• Object path
• Object name
• User permissions
• Type of permission (read, write, execute, etc.)

I’ve also tried using the runcat.sh utility, but unfortunately it didn’t yield the expected results — the output was either empty or incomplete.

Has anyone successfully extracted this kind of information from the OBIEE 12c catalog? Any guidance, scripts, or best practices would be greatly appreciated.

Thanks in advance for your help!

Gianni Ceresa

You should have "All", or something that means the same.

I don't have a 12c catalog manager anymore, and I saw that the OAS version does it. There are good chances the same (or similar) was already there in 12c.

Gianni Ceresa

Hi,

If in your report you add the ACL column you get the ACL of the object. It will be a single column with the whole ACL, therefore you need an extra step to process it if you really want a full detailed ACL output in separate columns (but because the ACL can be from a single object to 50 different objects, that's maybe not what you need anyway).

Alvaro_Soares

Hi Gianni,

Thank you for reaching out.

I've got to use the ACL field in a report. However, on Catalog Manager what type of report could give this list ? I mean I can see several types there such as Dashboard, Analysis, Briefing Book, Dashboard Group Folder etc.

Thank you

Alvaro_Soares

Hi Gianni,

I've got to create the provisioning report from Catalog Manager.

Thank you

Gianni Ceresa

Good!

And while it wasn't said, do your report in "offline" mode if you want to really have everything.