Yeah, we have used saiku on top of essbase successfully.
The pastebin link looks about right.
you probably have to define username + password in a separate line in the configuration file
have a look at the tomcat/webapps/saiku/WEB-INF/classes/saiku-datasources/README file. there are some sample configurations for other xmla providers in there.
essbase shouldn't be much different
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Can olap4j be used together with Essbase 11 (throught provider services url http://server:port/aps/XMLA
I found the following information around, but so few useful information finally :
Any useful advice or doc to guide me? The idea would be to use Saiku on top of Essbase... well at least to test if it works!
Many thanks!
Yeah, we have used saiku on top of essbase successfully.
The pastebin link looks about right.
you probably have to define username + password in a separate line in the configuration file
have a look at the tomcat/webapps/saiku/WEB-INF/classes/saiku-datasources/README file. there are some sample configurations for other xmla providers in there.
essbase shouldn't be much different
Many thanks for your quick reply! I'll check this up!
Hi, I had a look at it getting a java error when launching Saiku server.
Here are the steps I followed :
I updated olap4j jar version getting latest stable version (compilation #22), but not sure if it included latest related XMLA/Essbase modifications (ie http://sourceforge.net/p/olap4j/discussion/577988/thread/ddf52986 and
I created a file with the following content in ...\saiku\WEB-INF\
XML/A (ESSBASE)
----------------------------------------------
type=OLAP
name=xmla
driver=org.olap4j.driver.xmla.XmlaOlap4jDriver
location=jdbc:xmla:Server=http://localhost:13080/aps/XMLA
Many thanks
username=admin
password=password
Last edit: seb 2012-11-20