[R] R & OLAP engines, an integration?

[Jim Porzak]

Hi Emmanuel,

We are doing some work along these lines. See www.OpenI.org 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
http://sourceforge.net/forum/?group_id=142873 is probably a better
place than here.


On 10/14/05, Emmanuel Maroye <Emmanuel.Maroye at kae.com> wrote:
> Hi.
>
> I am a consultant at KAE: Marketing Intelligence (http://www.kae.co.uk) 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 emmanuel.maroye at kae.co.uk
>
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>


--
HTH,
Jim Porzak
Loyalty Matrix Inc.
San Francisco, CA