OBIEE 12c and HFM

I've worked with several of the clever people from the Oracle CEAL team and I highly recommend their blog: https://blogs.oracle.com/pa/ . It's full of valuable BI and EPM information.

Their latest post https://blogs.oracle.com/pa/entry/integrating_bi_12c_with_hfm shows us how to import HFM metadata into OBIEE 12c. I had some teething troubles configuring this on Windows (mainly due to the direction of the slashes in my path statements) so I thought I'd share my configuration for OBIEE and HFM on Windows.

I followed the instructions in the document Olivier provided but I got the following error when trying to import the HFM metadata:


"Could not connect to the data source. A more detailed error message has been written to the BI Administrator log file".

Don't believe the error message, there isn't any extra info in the admin log file so no hint as to where I had gone wrong. I think my problem was two fold - I'm on Windows and had used back-slashes in my pathing statements and I used the bi java host port number that was specified in the CEAL document (9610). The default port for the java host is 9510 so I used that.

Here is my working config:

E:\Oracle\OBIEE\Oracle_Home\bi\modules\oracle.bi.cam.obijh\setOBIJHEnv.cmd :

Add the following variables. This is a windows command script so you should be using back-slashes:

SET EPM_ORACLE_HOME=E:\Oracle\Middleware\EPMSystem11R1
SET EPM_ORACLE_INSTANCE=E:\Oracle\Middleware\user_projects\FDNHOST1
SET OBIJH_ARGS=%OBIJH_ARGS% -DEPM_ORACLE_HOME=%EPM_ORACLE_HOME%
SET OBIJH_ARGS=%OBIJH_ARGS% -DEPM_ORACLE_INSTANCE=%EPM_ORACLE_INSTANCE%
SET OBIJH_ARGS=%OBIJH_ARGS% -DHFM_ADM_TRACE=2



E:\Oracle\OBIEE\Oracle_Home\bi\modules\oracle.bi.cam.obijh\env\obijh.properties

Add the following variables. This time we use the forward-slash:

#Added for HFM connectivity
EPM_ORACLE_HOME=E:/Oracle/Middleware/EPMSystem11R1
EPM_ORACLE_INSTANCE=E:/Oracle/Middleware/user_projects/FDNHOST1


Find OBIJH_ARGS as indicated in the CEAL document and append the below tags to the end (without carriage return):

-DEPM_ORACLE_HOME=E:/Oracle/Middleware/EPMSystem11R1 
-DEPM_ORACLE_INSTANCE=E:/Oracle/Middleware/user_projects/FDNHOST1 
-DHFM_ADM_TRACE=2


The text has been wrapped in the image above. Just add the text at the end of your OBIJH_ARGS setting.

E:\Oracle\OBIEE\Oracle_Home\bi\bifoundation\javahost\config\loaders.xml

Add the following lines to the <Name>IntegrationServiceCall</Name> Classpath:

E:/Oracle/Middleware/EPMSystem11R1/common/hfm/11.1.2.0/lib/fm-adm-driver.jar$;
E:/Oracle/Middleware/EPMSystem11R1/common/hfm/11.1.2.0/lib/fm-web-objectmodel.jar;
E:/Oracle/Middleware/EPMSystem11R1/common/jlib/11.1.2.0/epm_j2se.jar;
E:/Oracle/Middleware/EPMSystem11R1/common/jlib/11.1.2.0/epm_hfm_web.jar



For the Admin Tool client, edit the following file:

E:\Oracle\OBIEE\OBIEE_Client\domains\bi\config\fmwconfig\biconfig\OBIS\NQSConfig.INI

JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = "SERVERNAME:9510";  


Restart your OBIEE and you can now import your HFM data into OBIEE:

adm:thin:com.oracle.htm.HsvADMDriver:HFMCLUSTER:APPNAME


You can see your HFM application, use the arrow to push it into the repository view:


You should now see it available in the physical layer:


Save the repository and start building your reports!


Comments

  1. Hi, indeed very useful post. on my installation of obiee12c & hfm 11.1.2.3 on import metadata iam getting 'EPMHFM-69052 : The system was unable to open the application.: Failed to connect to ADM URL: adm:thin:com.oracle.hfm.HsvADMDriver:hfmprod:finance'. I did all setttings according to your post. Any suggestions. Thanks John

    ReplyDelete
  2. Hi, I am also facing the same error while importing metadata in repository for HFM application. I have integrated HFM 11.1.2.4 with obiee 12.2.1.0 .Kindly help

    ReplyDelete
  3. Hello

    Now I got same error with above, will update if we can fix it.

    Thanks

    ReplyDelete
    Replies
    1. Hi, the blog shows how I fixed the error and connected to HFM.
      Cheers,
      Guillaume

      Delete
    2. This comment has been removed by the author.

      Delete
    3. Hi @epm_bi , Sorry for un-clear message I mean , we configured all follow your guideline and it's smooth but last step when import HFM to RPD we face error same with above reply >>> EPMHFM-69052 : The system was unable to open the application.: Failed to connect to ADM URL: adm:thin:com.oracle.hfm.HsvADMDriver:hfmprod:finance'.
      That same with first reply above.

      Do you face that before, please advise thank you.
      And thank you again for great and very detail Blog. We can follow step-by-step almost finish.

      Delete
  4. Hi,

    We are creating HFM reports in OBIEE. We have imported HFM application in OBIEE 12c physical layer. All the dimensions have been imported successfully.

    In OBIEE analyses when we are trying to add columns from dimensions data is getting displayed for all columns but not able to view data for Value measure from HFM application. Please help how to check values for Value measure.

    ReplyDelete

Post a Comment

Popular posts from this blog

OBIEE 12c: Oracle Business Intelligence has stopped working

Bursting using OBIEE Agents: Part 1

Where did my Planning Job Console History Go?