Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?... Nom : non disponible Url : https://stat.ethz.ch/pipermail/r-help/attachments/20070228/6ebce030/attachment.pl
You might want to have a look at the reshape package, http://had.co.nz/reshape, which can create multi-dimensional cubes and perform some OLAP type functionality (although it's likely a lot slower than a fully-fledged OLAP, it will probably do the job) Hadley On 2/28/07, Laurent Valdes <valderama at gmail.com> wrote:> Hi ! > > with apply or tapply-like functions, is it possible to create > multidimensional cubes with R ? Like with SAS and its function PROC TABULATE > or OLAP ? > Is there some functions or modules to access OLAP databases with R ? > > My idea is to create a package for that, since XMLA and JOLAP specifications > should able us to do so ! > > Thanks for your help, > > Laurent > > > -- > ?? attendre que l'herbe pousse, le boeuf meurt de faim? > ?Le boeuf? @<http://www.le-valdo.com> > > [[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 > and provide commented, minimal, self-contained, reproducible code. > >
Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?... Nom : non disponible Url : https://stat.ethz.ch/pipermail/r-help/attachments/20070301/baeb8abd/attachment.pl
You can also have a look at structable() in vcd, especially the indexing functions. The problem with OLAP in R is, that you will have to create sth. like a hierarchical factor to handle rollup/drilldown correctly. And you will have to decide whether it's purely memory-based (fast calculations, but memory limit), or you do it using data bases / SQL (slow). And finally, you will need some simple GUI to provide interactive use (doing OLAP using command-line functions is not really OLAP). Best, David ----------------- > Hi ! > > > > > > with apply or tapply-like functions, is it possible to create > > > multidimensional cubes with R ? Like with SAS and its function PROC > TABULATE > > > or OLAP ? > > > Is there some functions or modules to access OLAP databases with R ? > > > > > > My idea is to create a package for that, since XMLA and JOLAP > specifications > > > should able us to do so ! > > > > > > -- Dr. David Meyer Department of Information Systems and Operations Vienna University of Economics and Business Administration Augasse 2-6, A-1090 Wien, Austria, Europe Tel: +43-1-313 36 4393 Fax: +43-1-313 36 90 4393 HP: http://wi.wu-wien.ac.at/~meyer/