General OBIEE

Get Involved. Join the Conversation.

Topic

    Karthik K
    Report on BIP Catalog Folders details
    Topic posted September 13, 2017 by Karthik KGold Medal: 3,500+ Points, tagged BI Publisher, Core HR, Fusion, Reports, SQL 
    100 Views, 6 Comments
    Title:
    Report on BIP Catalog Folders details
    Summary:
    Report on BIP Catalog Folders details like Roles and Permission etc.
    Content:

    Dear Team,

    How to report on BIP Catalog Folders details like Roles and Permission etc.

    Need to understand if any report or relevant table names available in Fusion HCM in order to extract list of all roles and permission associated with all the folder/subfolders/reports in BIP catalog.

     

    Thanks

    Karthik

    Comment

     

    • Wade Wilson

      Karthik,

      I too would find value in being able to query this. So I’m hoping others respond who may know.

      I think I discovered a workaround when I was looking at the services (https://bi-aufsn4x0<pod>.oracleoutsourcing.com/xmlpserver/services) for BI… It seems the ‘getObjectSecurityXML’ call in the security service (https://bi-aufsn4x0<pod>.oracleoutsourcing.com/xmlpserver/services/v2/SecurityService?wsdl) may work. However, it is only returning Role Permissions and not Catalog Group permissions for me. This would not satisfy my need, unfortunately, but may help with yours.

      Cheers.

      • Karthik K

        Yes Wade. It is not returning catalog permission. Still looking for solution, as i our organization we have huge number of BIP reports and each one having different set of permissions. So would like to find some way to extract this catalog permission to keep it documented atleast. 

         

        Regards

        Karthik

    • Asif Ranta

      Hi Karthik,

      Have you find solution?

      Regards

      Muhammad Asif Ranta

    • Asif Ranta

      There must be some solution of it from Oracle its is biggest concern of audit department in many organization that which people have which reports accesss.

       

      Regards

      Muhammad Asif Ranta

      • Karthik K

        Yes same concern we have. I have checked with oracle, audit functionality on catalog permissions (ER) will be available in future release. I think it is ready and if required wit hstrong business justification, they can try to backport the functionality

         

        Regards, Karthik