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.

In principle, yes. Although other open source alternatives could also be considered. — Xavier Guardiola, May 16 '13 at 13:10

score 3 · Answer 1 · answered Jul 19 '13 at 19:35

3

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?

answered Jul 19 '13 at 19:35

overcoil

5

I've finished an initial cut of "X4R" (XMLA for R), an XMLA/MDX client for R. It's been posted to github: https://github.com/overcoil/X4R – overcoil Aug 19 '13 at 21:33
What is the 'structure' in R that matches the result of the MDX query ? – ic3 Sep 04 '15 at 13:44
@ic3 `array` but it scale badly with dimensions and dimensions cardinality – jangorecki Nov 04 '15 at 19:27

1 Answers1