Yes, anyway there is some opensource GUIs for doing that, especially jpivot. In fact, my idea consists in extracting datas from an OLAP cube with MDX or XMLA or JOLAP queries, from an existing OLAP server, as it is currently possible with some software like SAS or SPSS.
Regards, Laurent 2007/3/1, David Meyer <[EMAIL PROTECTED]>: > > 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/ > -- «À attendre que l'herbe pousse, le boeuf meurt de faim» «Le boeuf» @<http://www.le-valdo.com> [[alternative HTML version deleted]]
______________________________________________ [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.
