Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Connect to Hyperion Essbase?

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

Connect to Hyperion Essbase?

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

Connect to Hyperion Essbase?

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

Highlighted
suniljain
Honored Contributor

Connect to Hyperion Essbase?

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

subin6600
Contributor III

Connect to Hyperion Essbase?

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
Contributor III

Re: Connect to Hyperion Essbase?

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
Honored Contributor II

Connect to Hyperion Essbase?

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

Connect to Hyperion Essbase?

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

Connect to Hyperion Essbase?

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

chooco_co
Valued Contributor

Re: Connect to Hyperion Essbase?

Hi,

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

thanks