I've been searching the net for days now. I asked our IT department, they don't know either. Not sure if this is the right place, so apologies if I'm mistaken.
In the office we use Excel 2003 combined with Hyperion Essbase 6.5 to retrieve data from our databases.
Every month we prepare a large list of management and sales reports using our Hyperion database and the Essbase Excel add in. Due to the nature of our business clients and products (literally thousands for both of them) change every month. A number of other characteristics are added as well.
Currently we retrieve all products and clients in chunks (per report and update the report by doing vlookups both ways in order to add and delete clients and products.
Essbase has a query designer that I used to create a custom query. Did the same with the advanced member selection. However after I save these query files I don't know how to load and execute them in Excel using VBA.
Static retrieves using VBA are no problem using the standard Essbase functions. The retrieve I build is quite complex and is ill-suited for a standard retrieve. Does anybody have any experience with this and has some VBA code with which I can run the queries I saved.
I want to speed up the reporting process and my only other option is to retrieve all info by hand and put it into an Access database and fill my Excel sheets from here. Yes I know, it sounds silly and pretty desperate. If you have a practical solution I would really appreciate it.
In the office we use Excel 2003 combined with Hyperion Essbase 6.5 to retrieve data from our databases.
Every month we prepare a large list of management and sales reports using our Hyperion database and the Essbase Excel add in. Due to the nature of our business clients and products (literally thousands for both of them) change every month. A number of other characteristics are added as well.
Currently we retrieve all products and clients in chunks (per report and update the report by doing vlookups both ways in order to add and delete clients and products.
Essbase has a query designer that I used to create a custom query. Did the same with the advanced member selection. However after I save these query files I don't know how to load and execute them in Excel using VBA.
Static retrieves using VBA are no problem using the standard Essbase functions. The retrieve I build is quite complex and is ill-suited for a standard retrieve. Does anybody have any experience with this and has some VBA code with which I can run the queries I saved.
I want to speed up the reporting process and my only other option is to retrieve all info by hand and put it into an Access database and fill my Excel sheets from here. Yes I know, it sounds silly and pretty desperate. If you have a practical solution I would really appreciate it.