I'm trying to use the XMLA type of connection in PalOOCa but keep getting the message that the server/port combination is wrong. In the (outdated) document on the jPalo site there's a screen displaying a 'service' field with the full Xmla URL but there's no 'service' or 'url' option in the connection screen. Just a choice for XMLA and the same server/port entries as for Palo connections. I tried various combinations of server/port entries (e.g. put the full url like x.x.x.x:8080/pentaho/Xmla in the server field and leave port empty) but none of these seem to work. Is this already implemented? Would be really cool if I could use OO Calc on top of Mondrian
The labels for the connection fields are not correct, when using XMLA.
Within the server field you need to enter server and port and within the port field the service name e.g.:
It should work then in general. But the XMLA access is currently not well tested and lacks performance.
Thanks! It's pretty slow and buggy but at least I can access Mondrian (MySQL) data using the PalOOca addin from OpenOffice now! Very cool.
I couldn't do the same
The connection manager shows the following message:
'the specified port is not a valid number'
and I can't continue
Which version of PalOOca are you using? I think I have the latest (1.1.0), downloaded from extensions.services.openoffice.org/en/project/palooca
try to download from here: extensions.services.openoffice.org/en/node/3389/releases
But as I know there is 2.0.3 version available. Does anybody know from where to download it? I couln't find it here: jpalo.com/en/ , there is only premium version available.
the 32 bit-version could be included in the bundles available on Jedox' web site
the least last time I tried the demo version under Windows I saw the possibility to install it - unfortunately greyed out for me since I use LibreOffice
I doubt that the installer would install it (from previous experience with the suite) - only leave the oxt-file on your disc with a reminder to install it yourself, but at least you'd have the extension ...
I think what the JPalo guys do is in breach of the GPL since the PalOOCa Project released the first versions under GPL.