This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Would like to direclty query Hyperion Cube / Essbase data source directly - please propose functionality in next release or add a user macro to the gallery. Thanks -cb
Adding my vote as well
Adding my vote - how are people getting around this currently?
The only way I have found around it is to use the Smart View Dev Guide https://docs.oracle.com/applications/smartview/710/SVDVH/SVDVH.pdf to get the functionality you need. Then create a PS or batch script and run that from Alteryx.
So you are creating a VBA script to connect+pull--> then batch script+Alteryx to trigger. Got it
Upvoting, i used Alteryx for just about everything in my previous role and now that i have to connect to essbase i am constantly frustrated with my lack of options.
Added my vote. We are a partner out in HK and have been hearing from many of our clients/prospects that an Essbase connector would be great!
A connector to Essbase would be really great. Currently we have to export data from Essbase using a report script (either Essbase proprietary language or MDX), thus creating a text file, and then loading the text file. It should be possible to use Analytic Provider Services to extract data directly from Essbase (this way different BI tools access Essbase - an MDX statement is generated and fires the data request). Implementing this should be a foundation to create connectors to other multidimensional data sources (e.g. Microsoft Analysis Services, TM/1, Jedox).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.