Discussion Board for collaboration on QlikView Scripting.
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.
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.
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.
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.
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,
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!!!!!