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/ ______________________________________________ [email protected] 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.
