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