Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connect to Hyperion Essbase?

Hi,

Can we connect Qlikview with Hyperion Essbase?

Thanks

Amit

23 Replies
Not applicable
Author

Can we connect QlikView to Hyperion Essbase with the new version 10?

From the page http://www.qlik.com/us/landing/qv10?ga-link=hero I read:

"QlikView's patented, in-memory technology rapidly combines data from any source. Already using Oracle, SAP®, Salesforce.com, Business Objects, Cognos, Hyperion, SQL Server, MySQL, or Excel? No problem. QlikView's got you covered."

Thanks

Alessio

Not applicable
Author

Hi Amit,

We have successfully connected to Hyperion Essbase data and created Expense, Headcount, P&L Qlikview Dashboards. We use Star Analytics SIS product and are able to securely extract Essbase Data and display it in QV10. Additionally, we are able to securely automate the extract process for audit purposes. For more info go to: http://nxgenconsulting.com/services_Star.html or http://staranalytics.com/products/star_integration_server.htm

-Matt

Not applicable
Author

Here is a blog post that describes in more detail the steps necessary to report Essbase data in QlikView: http://autogration.blogspot.com/2011/02/qlikview-for-essbase.html

suniljain
Master
Master

What are the best possible way to take data from hyperion ?.

subin6600
Creator III
Creator III

Hi All,

I just read that Star Analytics can be used for getting the Data from Hyperion to Qlikview. But i just wanted to know whether is there any information regarding to which type of file will the third party tool Star Analytics save from Hyperion Essbase and make it as source to Qlikview and in reverse how would it work??

Is there any trial version of Star Analytics tool in the market that we can try out??Do we get this tool along with Qlikview 10 or is it additionally needed to be installed??

subin6600
Creator III
Creator III

Hi All,

I just read that Star Analytics can be used for getting the Data from Hyperion to Qlikview. But i just wanted to know whether is there any information regarding to which type of file will the third party tool Star Analytics save from Hyperion Essbase and make it as source to Qlikview and in reverse how would it work??

Is there any trial version of Star Analytics tool in the market that we can try out??Do we get this tool along with Qlikview 10 or is it additionally needed to be installed??

danielrozental
Master II
Master II

You should probably try contacting Star Analytics on their website, it will definitely not be included with QlikView as it is a different company.

Not applicable
Author

Hi All,

There is a new demo posted on YouTube that demos integrating Essbase data and metadata with QlikView: http://www.youtube.com/watch?v=9vyBSi_mssE

There is also more info here: http://staranalytics.com/solutions/solutions-article/qlikview-for-hyperion/

Cheers,

-qke

Not applicable
Author

Hi -

The QlikView output of Star Integration Server is via flatfiles.  There are individual files foreach dimension (metadata) and a single fact data file.  Star Integration Server also creates a QlikView QVS script which maps the dimensions (including aliases) to the FACT table via linking.

Just to give you an update - there is a new version of StarIntegration Server with enhanced support for QlikView: http://staranalytics.com/public-downloads/sis/documentation/SIS_2.8.6.2_ReleaseNotes.pdf.

You can download a trial of the software at:http://staranalytics.com/products/product-trial-request/?dlv=sis.

Best Regards,

Quinlan

marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi,

Is SIS still can be used for qlikview after its acquisition by IBM?

thanks