topic Re: Connect to Hyperion Essbase? in QlikView

Connect to Hyperion Essbase?

Mon, 01 Feb 2010 13:18:27 GMT

Hi,

Can we connect Qlikview with Hyperion Essbase?

Thanks

Amit

Connect to Hyperion Essbase?

mike_garcia — Thu, 25 Feb 2010 22:23:41 GMT

I have the same question, can anyone help?

Connect to Hyperion Essbase?

jasonseril — Tue, 30 Mar 2010 01:47:47 GMT

Hello all,

Does anybody has an example on connecting qlikview to hyperion essbase? thanks in advance.

jason

Connect to Hyperion Essbase?

stevedark — Thu, 20 May 2010 14:47:15 GMT

Hi there,

Apparently there is no way to connect directly to Essbase. I have had this confirmed by QlikTech in the UK. What I am having to do for a client here is get everything extracted into Excel first and then use that as the source. Not really an ideal solution.

I am going to keep looking for a solution - and will post back here if I find out.

Regards,
Steve

Connect to Hyperion Essbase?

Wed, 14 Jul 2010 14:05:13 GMT

Steve,

Have you found any better ways to get data for Essbase?

I´m thinking of using Essbase Excel Add-In to get data into excel and then load it to QV, but doesn´t seems a good idea.

Best Regards

Pablo

Connect to Hyperion Essbase?

stevedark — Thu, 15 Jul 2010 22:39:22 GMT

Hi Pablo,

Still running with the Essbase Excel Add-In at the moment. Looking to go right to the source data rather than their existing cubes - so the issue may go away for that reason at some point.

Cheers,
Steve

Connect to Hyperion Essbase?

Mon, 30 Aug 2010 04:14:34 GMT

Hi All,

Got the same answer too. In stead of connecting to EXCEL, may be an SQL db?

But I'm also looking for another solution, Hope to be Qlikview still...

Connect to Hyperion Essbase?

Mon, 30 Aug 2010 13:25:32 GMT

My understanding from QlikTech consultants is that to use Hyperion Essbase data in your QlikViews you would either export the data from Essbase or use a third-party tool like Star Analytics.

Connect to Hyperion Essbase?

Tue, 31 Aug 2010 08:21:54 GMT

Dear All,

You can use the Extented Analytics (Addon component) in Hyperion and exports the entire data to any RDBMS (say Oracle, SQL etc) and schedule it in hyperion on daily or monthly basis.

You can use this intermediate database as source to QlikView.

Hope it is better solutions rather than exporting in excel by considering data inconsistency and data volume handling problems in excel.

Thanks & Regards,

Raj Kishor

Connect to Hyperion Essbase?

Thu, 16 Sep 2010 20:07:50 GMT

You can export data from Essbase through an essbase calculation script. It is very fast and can export to multiple sources (text, oracle, sqlserver,etc). The command is DATAEXPORT. No additional cost or software needed!!!!!

Connect to Hyperion Essbase?

Wed, 20 Oct 2010 11:10:01 GMT

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

Connect to Hyperion Essbase?

Fri, 21 Jan 2011 01:48:13 GMT

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

Connect to Hyperion Essbase?

Wed, 09 Feb 2011 08:07:03 GMT

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

Connect to Hyperion Essbase?

suniljain — Tue, 15 Mar 2011 13:07:37 GMT

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

Connect to Hyperion Essbase?

subin6600 — Tue, 14 Jun 2011 11:56:08 GMT

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??

Re: Connect to Hyperion Essbase?

subin6600 — Tue, 14 Jun 2011 11:57:00 GMT

Hi All,

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??

Connect to Hyperion Essbase?

danielrozental — Tue, 14 Jun 2011 13:41:29 GMT

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

Connect to Hyperion Essbase?

Mon, 28 Nov 2011 20:21:08 GMT

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

Connect to Hyperion Essbase?

Thu, 12 Jan 2012 18:16:02 GMT

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

Re: Connect to Hyperion Essbase?

marcohadiyanto — Mon, 01 Sep 2014 06:38:03 GMT

Hi,

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

thanks