Connect to Hyperion Essbase?

[#1]

Hi,

Can we connect Qlikview with Hyperion Essbase?

Thanks

Amit

[#2]

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

[#3]

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

[#4]

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]

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

[subin6600]

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]

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]

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

[#9]

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

[#10]

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]

Hi,

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

thanks