R clients to OLAP MDX servers

Question

Has anyone tried to access an OLAP server offering a XMLA API (such as Mondrian) from R?

I'd love to run MDX queries from R against Mondrian and retrieve result sets.

Kbp

Are you considering Mondrian only ? – Longcloth

In principle, yes. Although other open source alternatives could also be considered. – Kbp

Also interested in an answer to this question. – Lipchitz

Answer 1

I'm working on something here but I'm new to building R plug-in/extension.

I've begun by looking at RODBC and also gSOAP for this. Any other hints/tips?

Covalence

I've finished an initial cut of "X4R" (XMLA for R), an XMLA/MDX client for R. It's been posted to github: github.com/overcoil/X4R – Covalence

What is the 'structure' in R that matches the result of the MDX query ? – Clemens

@Clemens array but it scale badly with dimensions and dimensions cardinality – Antifriction