similar to: R client connection OLAP cube (SQL Analysis Services / PivotTable Service)

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

An embedded and charset-unspecified text was scrubbed... Name: not available Url: -- not available on request of Emmanuel Maroye

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, I would like to know if there is a way to change a vector of arbitrary size to make it fits the nearest upper size multiple of a power of 2. -- Cordialy ---------------------------------------- Emmanuel POIZOT Cnam/Intechmer Digue de Collignon 50110 Tourlaville T?l : (33)(0)2 33 88 73 42 Fax : (33)(0)2 33 88 73 39 -----------------------------------------

What is the recommended/optimal way to perform aggregates on data frames with chron objects? Here is an example: >raw.data 1 07/09/01 4000 2 07/09/01 2000 3 07/11/01 1000 4 07/13/01 800 5 07/13/01 700 6 07/16/01 600 7 07/17/01 500 I'm trying to construct a function that would first aggregate the data (second column) by day (grouping by the first column) according to a

Hi, I would like to eliminate the trend of a set localised (with x an y) data. I try to fit a linear model to the data: mod.01 <- lm(ff~x+y) I've got so a model. My question is how can I do to subtract the model from the initial f data ? -- Cordialement ---------------------------------------- Emmanuel POIZOT Cnam/Intechmer Digue de Collignon 50110 Tourlaville T?l : (33)(0)2 33 88 73 42

Hi This is my function. It serves an HTML page after the calculations. I'm connecting to a MSSQL DB using pyodbc. def CAPM(self,client): r=self.r cds="1590" bm="20559" d1 = [] v1 = [] v2 = [] print"Parsing GET Params" params=client.g[1].split("&") for items in

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

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, 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

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 guys, Does anyone have any ideas on my questions below ? Kindest regards David Wilson D c D a t a Tel +27 33 342 7003 Fax +27 33 345 4155 Cell +27 82 4147413 MSN: dave@dcdata.co.za http://www.dcdata.co.za support@dcdata.co.za sales@dcdata.co.za KZN's first and only pure Linux solution provider ____________________________________________________ LinuxBox S.A.: Africa's shell

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

hi how about having more cubes to fly around in 3d space. though at first thought this might appear unessacary as who needs so many desktops? So i thought, why not have special cubes (as well as the original cube of course) and these special cubes, instead of cubes, be 3d metaphric objects for specific tasks such as a radio, or ipod or whatever for music a cinema for movies arcade thingo for

Hi Roland and folks: Roland's and Susanna's comments were very interesting. I think we need to keep in mind that unlike SPSS, R is more than a statistical package. It's a tool. SPSS does indeed make life easy, particularly for data preprocessing (or data "cleaning"), something that is perhaps not advisable using R (the current versions). Also, I think it's a myth that R

Hi all, Anyone want to help with a native IO.foreach? I''m missing some of the critical logic here. This currently just does a straight BYTE_MAX data read, instead of a line by line data read, and doesn''t deal with lines split between multiple reads. I checked strtok into CVS (for windows-pr) if anyone wants to use that instead of String#split. It''s in

1. That was a part of a private email exchange. It has been suggested that more people may be interested. 2. I did use various databases (significant part of my job) for the last 15 years. Some with R for the last 3 years as a hobby. Some comments on the ones used below. Sorry, no links - I am time-constrained at the moment - please google if interested in details. The remarks are from the point