[R] R OLAP engines, an integration?

2005-10-14 Thread Emmanuel Maroye
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 [EMAIL PROTECTED]


[[alternative HTML version deleted]]

__
R-help@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


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

2005-10-14 Thread 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]


 [[alternative HTML version deleted]]

 __
 R-help@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

__
R-help@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