Connect to Hyperion Essbase?

[#1]

Hi,

Can we connect Qlikview with Hyperion Essbase?

Thanks

Amit

[mike_garcia]

I have the same question, can anyone help?

[jasonseril]

Hello all,

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

jason

[stevedark]

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

[#5]

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

[stevedark]

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

[#7]

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

[#8]

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.

[#9]

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

[#10]

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