3 Replies Latest reply: Apr 24, 2013 10:52 PM by Celvin Kattookaran RSS

    Custom Reports in Hyperian Server Using Java API's

    1004543
      Hi,

      We have a requirement to create following 3 custom reports in Hyperian Server.
      1. ReportSecurity Report - Who have what level of access to the report.
      2. FolderSecurity Report - Who have what level of access to the Folders.
      3. FolderContent Report- which file is in which folder.

      Do we have any Java API available to generate above reports in hyperian server?
        • 1. Re: Custom Reports in Hyperian Server Using Java API's
          Celvin Kattookaran
          I'm don't think there is a Java API for this. (I could be wrong)

          This can be achieved using SQLs

          1 & 2 can be achieved using the below SQL (run this as biplus repository user)
          select c.name as "User Name", d.name as "File Name" from v8_access_ctrl a, v8_container d, v8_css_user b, hssdbuser.css_users c
          where d.container_uuid = a.resource_id
          and b.subject_id=a.accessor_id
          and c.identity_id=b.css_identity
          and d.name='your report name/folder name';
          3 can be achieved using the below SQL
          select a.name,
            b.fr_path
          from v8_container a,
            (select v8_container.name ,
              parent_folder_uuid,
              container_uuid,
              connect_by_isleaf "isleaf",
              sys_connect_by_path(v8_container.name,'/') as fr_path
            from v8_container
            where meta_type_uuid             = 'id03'
              connect by prior container_uuid=parent_folder_uuid
              start with container_uuid      ='reportmart'
            ) b
          where a.parent_folder_uuid = b.container_uuid
          and b.fr_path like '%/your folder name'
          order by a.meta_type_uuid asc,
            fr_path asc
          Regards

          Celvin

          http://www.orahyplabs.com
          • 2. Re: Custom Reports in Hyperian Server Using Java API's
            WVanSluys
            Yes, there are APIs for doing what you are interested in. It is adviseable to use API instead of Direct SQL Query against repository tables as they can change from version to version.


            I recommend you look at the documentation
            http://docs.oracle.com/cd/E17236_01/index.htm

            Start with
            Oracle Hyperion Reporting and Analysis - Framework Developer's Guide
            http://docs.oracle.com/cd/E17236_01/epm.1112/raf_developer.pdf

            You may also need to look at
            Oracle Hyperion Shared Services - Security API Reference
            http://docs.oracle.com/cd/E17236_01/epm.1112/epm_security_api/launch.html
            • 3. Re: Custom Reports in Hyperian Server Using Java API's
              Celvin Kattookaran
              WVanSluys,

              Can you please let me know which API can provide that information.

              I tried FetchCategory.java and ObjectByPath.java, however none of them give any information about their access. (that's why i went the SQL route)

              Regards

              Celvin

              http://www.orahyplabs.com