Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
Connecting Jaspersoft iReport to a cube in PALO Community
Is it possible to access the cube with in the PALO community edition via XMLA or some other way?
Thanks for the help.
Jyot
Right now it is possible to access Palo OLAP Server Community Edition through Palo ODBO/XMLA Provider Community Edition (XMLA) only from Excel.
Premium version of Palo ODBO/XMLA Provider supports any XMLA client.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations
Vladislav Malicevic
Head of Research and Development
Jedox AG
Thanks for the reply. Can you please share the url to be used while connecting to the premium version.
|
Source code
|
1
|
http://localhost:4242/xmla/
|
To include credentials:
|
|
Source code
|
1
|
http://<PALOUSER>:<PALOPASSWORD>@localhost:4242/xmla/
|
e.g.
|
|
Source code
|
1
|
http://admin:admin@localhost:4242/xmla/
|
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations
Vladislav Malicevic
Head of Research and Development
Jedox AG
Thanks Vladislav. I tried the url
http://admin:admin@localhost:4242/xmla/ in the iReport but it errors out with a message "Error Connection Refused Connect".
Do I have to start any service to enable xmla? My Palo web is running and i can access the same cubes from Excel.
Thanks for your help.
Jyot
Well yes, aside from Palo OLAP Server you need Palo ODBO/XMLA Provider I thought I have that one (it is not included in standard setup at the moment - extra
setup).
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations
Vladislav Malicevic
Head of Research and Development
Jedox AG
Hi! Palo is a great product. I think it's fantastic, quick and easy to use. I've setup the ODBO/XMLA Provider and its running. What is the right connection strings to use? I would like to see if the data can be displayed via other reporting tools. Is there any documentation around the ODBO/XMLA Provider? Can it be sold seperately if companies want to only buy components to integrate? I'm presenting Palo very soon, and would like to demo reporting of Palo data via a variety of reporting tools. So this is urgent.
Hi,
as the full XMLA/ODBO component is included in the Premium Edition only (Community Ed supports odbo connections via excel pivot tables only), I suggest you to contact Jedox sales directly (
http://www.jedox.com/en/about-jedox/Contact/Contact-us.html) for urgent info,
regards,
RQ
This post has been edited 1 times, last edit by "realquo" (Nov 27th 2010, 4:06pm)
