similar to: R & OLAP engines, an integration?

I have been doing data analysis/modeling in R, connecting to SQL databases with RODBC (winXP client with R1.9.0 and win2k SQL server 2000). I am now trying to leverage some of the OLAP features to keep the data intensive tasks on the DB server side and only keep the analytical tasks within R (optimize use of memory). Is there any package that would allow to connect to OLAP cubes (as a client

Olivier Collignon wrote: > I have been doing data analysis/modeling in R, connecting to SQL databases > with RODBC (winXP client with R1.9.0 and win2k SQL server 2000). > > I am now trying to leverage some of the OLAP features to keep the data > intensive tasks on the DB server side and only keep the analytical tasks > within R (optimize use of memory). Is there any package

Hello All, I have a dataset and I wish to obtain all possible data cuboids from it using R . For eg if my data frame is : A B C 1 1 1 1 2 1 2 2 1 The output intended is : A=1 A=2 B=1 B=2 C=1 A=1,B=1 A=1,B=2 A=2,B=2 A=1,C=1 A=2,C=1 B=1,C=1 B=2,C=1 A=1,B=1,C=1 A=1,B=2,C=1 A=2,B=2,C=1 Are there any function(s) to do this in R ? I tried a combination of expand.grid and

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

Hi all, I''ve got overlapped and offset support in both nread and nwrite. The only thing left before I want to release this (as 0.4.0) is to get NO_BUFFERING to work. Unfortunately, I can''t get it to work. Park, I looked at that site you sent (and borrowed some code from it), but I don''t see anything special happening for NO_BUFFERING. I thought it required

Hi All, I have an CBS segmentation algorithm output for 10 tumor samples each from 2 different tumors. Now, I am in an urgent need to assign gene (followed by all genes present) that belong to a particular segment after I removed all the CNVs from segment data. The format of the data is: Sample Chromosome Start End Num_Probes Segment_Mean Sample1A-TA 1 51598 76187 15

Hi all, I recently put a new version of my french introduction to R online. It is more specifically targeted at social sciences students and researchers, but could be interesting for beginners who are not really familiar with statistics and coding. The document is available (in french) in PDF, as well as the Sweave source code, from the following page : http://alea.fr.eu.org/j/intro_R.html

Assertion failure in journal_add_journal_head() at fs/jbd/journal.c:1679 : "(((&bh->b_count)->counter) > 0) || (bh->b_page && bh->b_page->mapping)" ------------[ cut here ]------------ kernel BUG at fs/jbd/journal.c:1679! invalid operand: 0000 [#2] CPU: 0 EIP: 0060:[<c017637f>] Not tainted EFLAGS: 00010282 EIP is at

Hi @ all Does anyone has some experience with PostgreSQL and RoR? Does it gives any disadvantages or problems with PostgreSQL? I have a webapplication, that manage (read/write) many records (no. 200''000 records) and I search a ideal database. Actually, I have two options: - MySQL / - PostgreSQL And now, I would like to ascertain a good solution... Thx, ribit -- Posted via

Hi all, I have a dovecot installation which very suddenly decided to slow to a crawl yesterday after being totally fine for months. IMAP is fine, but POP3 is very painful to use, and frequently times out. here's my config: # 1.0.7: /etc/dovecot.conf log_path: /var/log/dovecot_errors info_log_path: /var/log/dovecot_informational ssl_ca_file: /etc/postfix/ssl/cacert.pem ssl_cert_file:

Hi, Lang As a starter using LLVM JIT to improve OLAP execution engine performance, I'm very glad to hear that. I can't find some useful document help me get start to use the new ORC JIT API quickly. Only can find some examples how to use it, but don't know the internal from low level, and very blurred to design a clearly JIT toolset. Hope more tutorials add in and help ORC JIT more

Is is possible to have a puppetmaster that is a client of a different puppetmaster? We manage our customers'' server via puppet, but one customer has a puppetmaster server which looks after their internal systems. We''ve tried the following in /etc/puppet/puppet.conf ("customer" and "us" replacing the domain names) on their puppetmaster: [puppetmasterd]

Is there any way that a model can be based on a stored procedure or function that so that it can return a set of data based on a parameter provided in either the controller, or s a variable in the model? That way you could: 1) Set the variable 2) Call find_all 3) Get a mutable set of results that takes better advantage of some of the advanced database features available?

Hi guys/girls, How are you ? I'm running "Linux 2.4.22 SMP" with Samba-3.0.4 and pick up the following message in my syslog when accessing a mounted NT4 share: kernel: smb_proc_readdir_long: name=\OLAP Services\Data\GreatPlains\*, result=-13, rcls=1, err=5 Any ideas what this is ? Your assistance is greatly appreciated. Many thanks. Kindest regards David Wilson D c D a t a Tel

Dear all, in last weeks you discussed about R vs SAS. I want to ask your opinion about a comparison between R and SPSS. I don't know this software, but some weeks ago I went to a presentation of this product. I found it really user-friendly with GUI (even if I'd prefer command line) and very usefull and simple to use in creation and managing tables, OLAP tecniques, pivot table. What you

summary: The function 'by' inconsistently strips class from the data to which it is applied. quick reason: tapply strips class when simplify is set to TRUE (the default) due to the class stripping behaviour of unlist. quick answer: This can be fixed by invoking tapply with simplify=FALSE, or changing tapply to use do.call(c instead of unlist executable example:

Hi, is it anyhow possible to tell the other end of the ppp link how he should queue the packages? I have a ppp link to my isp and would like to control the order of packages send to me. I would like to give uucp a lower priority than http. Is this possible? Has ppp any special features to control such things? Bye, Jörg. -- Gott hat den Menschen erschaffen, weil er vom Affen enttäuscht war.

Hello! I have two functions. The first one prepares the arguments for the second one. What is the best way to put all resoults of the first one into the second one? I tried attach, however the object in the "main" enviorment have a priority over the ones in list. An example is at the end. Thanks in advance for any suggestions! Ales Ziberna For example - I would like to use just

Hello! I am trying to move my work in R from Windows to Linux. However I am missing some of the functionality I was used to under Windows. I tried running R 2.0.1 by typing R in the terminal and via Emacs/ESS. R Gui currently does not work on my Linux. Currently one of my problems is: Under Windows, I could terminate any R function by pressing "ESC", but this does not work under

Do you consider yourself a cutting edge statistical expert with a penchant for applying your broad theoretical background to solving some of the most complex statistical challenges facing human health today? Does the idea of working for an emerging company who has a strong management team, financial backing and world class scientific advisors appeal to you? If so, read on... Our client is a drug