Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
gbarrett
Partner - Contributor III
Partner - Contributor III
‎2017-12-20 09:50 AM

Connecting Qlik Sense to Oracle Hyperion Financial Management

Hello There. I have a project where I need to connect a customer's Oracle Hyperion Financial Management to Qlik Sense. I have never used HFM before so I browsed the Community to see if a direct connection was possible. I am seeing mixed responses so I wanted to throw the question out again. Thanks in advance.

1,352 Views
0 Likes
1 Reply
Lavanyasreepada
Contributor II
Contributor II
‎2020-08-25 06:49 AM

Hi 

Description

How does QlikSense support connection to Hyperion Financial Management

Resolution

One option is to use Essbase Analytics Link (EAL) from Oracle/Hyperion which creates a virtual cube on top of HFM  data.  From there the connector will connect to the virtual Essbase Cube.  The other option is to use HFM extended analytics which generates a Star Schema from HFM.

Another option is to load the flat file extracted out of HFM into a Relational database.  From there, Qlik would just use the ODBC connection to that Relational DB. 

 

Thanks 

Lavanya Sreepada 

724 Views
0 Likes