You are not logged in.

XMLA support?

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.

dibe0014

Sage

  • "dibe0014" started this thread

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

1

Tuesday, August 18th 2009, 10:05pm

XMLA support?

Hi,

I'm trying to figure if the community edition supports XMLA and how to access it.
I could install Palo, set up MDX support and I can use the Pivot tables in Excel. Now I want to go one step further and use a XMLA client like REX (http://sourceforge.net/projects/whex/) to explore the Palo database using XMLA.

How do I have to set up the XMLA string to make it work? My first approach was http://127.0.0.1:7777 but it doesn't work (HTTP error 503).
The next port I tried was 4242. After entering the user the Palo MDX service crashes.

Any ideas?

Thanks,
Benjamin
My blog on Open Source BI and living in Canada

This post has been edited 1 times, last edit by "dibe0014" (Aug 28th 2009, 4:14pm)

realquo

Sage

  • "realquo" is male

Posts: 257

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

2

Wednesday, August 19th 2009, 11:34am

Hi,

I'm trying to access Palo using pivottables and eventually other xmla clients too. I was able to explore the demo db using Pivot table (even if it's very slow), but could'nt figure how to use other xmla clients, pointing to 127.0.0.1:4242 results in the application hanging on.

Any help will be greatly appreciated.

RQ

This post has been edited 1 times, last edit by "realquo" (Aug 19th 2009, 11:59am)

dibe0014

Sage

  • "dibe0014" started this thread

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

3

Friday, August 28th 2009, 4:17pm

From the overwhelming feedback I get my question I conclude Palo isn't able to handle XMLA requests.
My blog on Open Source BI and living in Canada

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 348

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

4

Tuesday, September 1st 2009, 5:49pm

The community edition will only handle XMLA requests from Excel, i.e. it has built-in support for Excel Pivottables.

The Enterprise Edition of the BI Suite includes the Palo ODBO Provider, which will interpret XMLA / ODBO requests from any client.

realquo

Sage

  • "realquo" is male

Posts: 257

Date of registration: Mar 11th 2009

Location: Italy

Occupation: BI Consultant

  • Send private message

5

Tuesday, September 1st 2009, 6:15pm

Dominik,

thanks for clarifying this point, regards,

RQ

Marco Groeneveld

Sage

Posts: 138

Date of registration: Oct 27th 2005

  • Send private message

6

Wednesday, September 2nd 2009, 2:00pm

RE: XMLA support?

Hi,

For SQL Server 2000 OLAP the XMLA connection string is:
http://localhost/xmla/msxisapi.dll

What is XMLA connection string for PALO Enterprise ?

Marco

dibe0014

Sage

  • "dibe0014" started this thread

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

7

Thursday, September 3rd 2009, 3:28pm

Hi Dominik,

thanks for your answer. I might download the trial version the next days.

We are developing Wabit , an Open Source Reporting tool and I would like to test how it would work together with Palo.

Thanks,

Benjamin
My blog on Open Source BI and living in Canada

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 348

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

8

Thursday, September 3rd 2009, 5:16pm

Please note that since the ODBO / XMLA provider is not open source, there won't be support for it on the forum.

gleesoto

Master

  • "gleesoto" is male

Posts: 68

Date of registration: Nov 12th 2005

Location: Ireland

Occupation: datasmith

  • Send private message

9

Friday, September 4th 2009, 2:05am

Benjamin,

You should change your location from Freiburg to Canada :-)

I have been looking at the various SQLPower offerings over the last few days, very impressed.

Tom

dibe0014

Sage

  • "dibe0014" started this thread

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

10

Friday, September 4th 2009, 3:49pm

Thanks for the compliments :-) Our developers have been working hard to bring our reporting tool up to speed and also to implement the Mondrian Schema Designer. I'm not working as a developer, but I have written tons of enhancement requests, many of them made it into our current release.

I wish we could use the open source version of Palo as a data source but to use the Java API would take too much time so I was hoping they would offer an XMLA provider for it.

Benjamin
My blog on Open Source BI and living in Canada

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 455

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

11

Thursday, September 24th 2009, 2:29pm

Wabit <> XMLA <> Palo

Hi Benjamin!

I played around with Wabit and my (enterprise) ODBO/XMLA Provider for Palo. It doesn't work. I get error from olap4j driver (which I can't copy/paste btw. - copy seams not to work in that dialog in wabit). I've attached screenshot.

Are you involved into development of olap4j? I would like to help you get this running.

I also gave whex a try and it looks like working.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

dibe0014

Sage

  • "dibe0014" started this thread

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

12

Thursday, September 24th 2009, 3:12pm

Hi,

thanks for trying out Wabit. I'm personally not involved in the development of olap4j but one of our developers is. I'll send you his email in a private message.

Benjamin
My blog on Open Source BI and living in Canada

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 455

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

13

Tuesday, February 9th 2010, 8:20am

Wabit <> XMLA <> Palo

Update:
I've downloaded and installed latest Wabit version (1.1.1). With it I was able to connect and "execute" couple of views against our provider.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG

dibe0014

Sage

  • "dibe0014" started this thread

Posts: 85

Date of registration: Sep 25th 2008

Location: Oakville, ON

  • Send private message

14

Wednesday, February 10th 2010, 5:27pm

Thanks for the update. I just talked with our developer and we could get the same queries to work as you did. It looks very promising. Luc will stay in contact with you.

Benjamin
My blog on Open Source BI and living in Canada
Rate this thread