Re: [R] R & OLAP engines, an integration?

From: Jim Porzak <>
Date: Sat 15 Oct 2005 - 01:32:48 EST

Hi Emmanuel,

We are doing some work along these lines. See for details of our open souce OLAP solution & contact our CTO, Sandeep Giri (via link on that site), for details. We haven't released any R integration yet, but we are doing some things internally & it is on the OpenI development roadmap.

I think OLAP definitely needs integration with some hard analytics. Sure, our business analysts are very comfortable moving around in OLAP space & come up with some amazing insights, but OLAP just provides simple counts, sums etc. No sense of estimated errors or tests of significance. And, of course, no advanced techniques.

One technical point, some methods would require a "drill-through" to the underlying data set. For example, while a mosaic plot can be generated from a 2-dimensional OLAP result table, generating a box plot corresponding to a OLAP bar chart (my personal favorite) needs the raw data points.

We welcome everyone interested in this idea to join in the discussion & effort. The OpenI forum is probably a better place than here.

On 10/14/05, Emmanuel Maroye <> wrote:
> Hi.
> I am a consultant at KAE: Marketing Intelligence ( working on market evaluation and forecasting. Working on large datasets I am looking for a solution to use R on datasets stored in an OLAP engine (like MIS Alea, Applix TM1 or Mondrian). Have you ever heard about such a solution?
> The idea is to apply R methods directly on data stored in an OLAP. The results being part of the OLAP as well (results write back)...
> Thanks in advance.
> Best regards,
> Emmanuel
> _____________________________________
> Emmanuel Maroye
> kae: marketing intelligence
> 209 - 215 Blackfriars Road
> London SE1 8NL
> United Kingdom
> D +44 20 7960 3358
> M +44 7914 010 728
> F +44 20 7960 3301
> E
> [[alternative HTML version deleted]]
> ______________________________________________
> mailing list
> PLEASE do read the posting guide!

Jim Porzak
Loyalty Matrix Inc.
San Francisco, CA

______________________________________________ mailing list
PLEASE do read the posting guide!
Received on Sat Oct 15 01:40:17 2005

This archive was generated by hypermail 2.1.8 : Sun 23 Oct 2005 - 18:54:08 EST