1 Reply Latest reply: Nov 20, 2012 9:28 AM by Venkat Kuravarapu RSS

    OBIEE 11g Compatibility with Financial Reporting

    867222
      OBIEEmates,

      I am creating some reports in OBIEE, I usually try to migrate some FR into OBIEE with satisfactory results. But the ¨Text¨ columns are presented as random numbers. For obvious reasons it cannot be a deliverable for a user.

      I investigaye several alternatives. I am asking for the Oracle community help.

      The first One was a patch found in a blog:

      http://www.rittmanmead.com/2010/09/oracle-bi-ee-11g-integration-with-epm-11-1-2-hfr-action-framework/


      For my particular case I entered the URL
      <registry>
      <id>HDPreg</id>
      <name>Hyperion Directory Provider</name>
      <content-type>epm</content-type>
      <provider-class>oracle.bi.action.registry.epm.HDPRegistry</provider-class>
      <description>Hyperion Financial Reports Registry</description>
      <location> <path>http://APPS54001a-40.admin.bcps.k12.md.us:19000/raframework/browse/listxml</path> </location>
      <service-access>
      <account>EPM</account>
      <propagateIdentity>false</propagateIdentity>
      </service-access>
      </registry>

      According to the instructions I should see a special window in which "Navigate into EPM Content" should be available, but I still cant made this happen. En error which says "Soap Invocation Failure" Error Code ´415´



      The second is to Upgrade The version to 11.1.2.1 in which is know that you can use OBIEE as a Viewr, I am responsible of making this decision, and I do not want to give such an order before I can see how FR is presented in OBIEE, do anyone have some screens, video, or blog in which I can see such functionality?

      I need to be sure it can be done and also if it is Deliverable worthy.


      Thanks

      Daniel Calcaneo
        • 1. Re: OBIEE 11g Compatibility with Financial Reporting
          Venkat Kuravarapu
          In order to fix - you need to define following xml tags - ActionFrameworkConfig.xml
          - registry
          - content-type
          - accounts

          <registry>
               <id>HDPreg</id>
               <name>Hyperion Directory Provider</name>
               <content-type>epm</content-type>
               <provider-class>oracle.bi.action.registry.epm.HDPRegistry</provider-class>
               <description>Hyperion Financial Reports Registry</description>
               <location>
               <path>http://host:19000/raframework/browse/listXML</path>
               </location>
               <service-access>
               <account>EPM</account>
               <propagateIdentity>false</propagateIdentity>
               </service-access>
          </registry>

          <content-type>
               <typename>epm</typename>
               <displayname>Hyperion Applications</displayname>
               <actionType>URLActionType</actionType>
          </content-type>

          <account>
               <name>EPM</name>
               <description>Account used to access WLS JNDI.</description>
               <adminonly>false</adminonly>
               <credentialkey>EPM</credentialkey>
          </account>