Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Connect to Hyperion Essbase?

Hi,

Can we connect Qlikview with Hyperion Essbase?

Thanks

Amit

23 Replies
mike_garcia
Contributor III

Connect to Hyperion Essbase?

I have the same question, can anyone help?

jasonseril
Contributor

Connect to Hyperion Essbase?

Hello all,

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

jason

MVP
MVP

Connect to Hyperion Essbase?

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

Not applicable

Connect to Hyperion Essbase?

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

MVP
MVP

Connect to Hyperion Essbase?

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

Not applicable

Connect to Hyperion Essbase?

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

Highlighted
Not applicable

Connect to Hyperion Essbase?

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.

Not applicable

Connect to Hyperion Essbase?

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

Not applicable

Connect to Hyperion Essbase?

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

Community Browser