search for: olap

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 that would allow to > connect to OLAP cubes (as a client to SQL Analysis Services PivotTable > Service) from an R session...

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

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 to SQL Analysis Services PivotTable Service) from an R session (similar to the RODBC...

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

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

...sbuf) page_size = sysbuf[8,4].unpack(''L'')[0] # dwPageSize file_size = File.size(file) # FILE_SEGMENT_ELEMENT fse_struct = (0.chr * page_size) + (0.chr * 8) # Buffer + Align. seg_array = (0.chr * (file_size / fse_struct.size)) + 0.chr olapped = 0.chr * 20 bool = ReadFileScatter(handle, seg_array, file_size, nil, olapped) raise SystemCallError.new(GetLastError()) end sleep 0.01 unless HasOverlappedIoCompleted(olapped) unless CloseHandle(handle) raise SystemCallError.new(GetLastError()...

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

..., FILE_SHARE_READ, 0, OPEN_EXISTING, 0, 0 ) if handle == INVALID_HANDLE_VALUE raise Error, get_last_error end buffer = 0.chr * MAX_READ nbytes = [0].pack(''L'') offset = 0 olap = 0.chr * 20 # sizeof(OVERLAPPED) while bool = ReadFile(handle, buffer, buffer.size, nbytes, olap) error = GetLastError() if !bool && error == ERROR_INSUFFICIENT_BUFFER buffer = 0.chr * (buffer.size + buf_max) next end...

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. Hop...

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

...le 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? There are many times when SQL code is simply a better way to twist and turn data sets. (Olap transformations, speeding up joins in large tables by using temp tables, etc.) Best, Brian -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060309/76ed392a/attachment-0001.html

...- Data Analyst Intern Loyalty Matrix is a successful & profitable two-year-old start-up company based in downtown San Francisco. We are seeking a bright, organized, and motivated team player who appreciates the challenges and Primary Responsibilities: ? Brainstorm with OLAP models on customer ? Conduct customer statistical models ? Perform gap customer intelligence ? Report directly Qualifications: ? Graduating Science, Engineering, Math ? Basic knowledge techniques ? Intermediate Preferred Qualifications...

...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 think about? Cordially Vito ===== Diventare costruttori di soluzioni Became solutions' constructors "The business of the statistician is to catalyze the scientific learning process." George E. P. Box Visitate il portale http://www.modugno.it/ e...

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 +27 33 342 7003 Fax +27 33 345 4155 Cell +27 82 4147413 MSN: dave@dcdata.co.za http://www.dcdata.co.za support@dcdat...

...and comfortable with basic functionalities of R, switch them to R. But not both at the same time or in quick succession. If I were to teach a course where SPSS and R would coexist, I'd introduce R slowly. I'd start with SPSS, show them how to use SPSS for routine data management tasks and OLAP etc..., and teach the basics using SPSS, and encourage the students to write syntaxes in SPSS instead of point and click. When they would be comfortable writing SPSS syntaxes, I'd introduce R to show how easily and elegantly they could achieve the same goal-oriented tasks in an R environment. H...

....org Sent: Wednesday, October 06, 2004 1:15 PM Subject: smb_proc_readdir_long error 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 +27 33 342 7003 Fax +27 33 345 4155 Cell +27 82 4147413 MSN: dave@dcdata.co.za http://www.dcdata.co.za support@dcdat...

Hi everybody, I would like to know whether it is possible to compare to tables for certain parameters. I have these two tables: gene table name chr start end str accession Length gen1 4 646752 646838 + MI0005806 86 gen12 2L 243035 243141 - MI0005821 106 gen3 2L 159838 159928 + MI0005813 90 gen7 2L

...orts, platform Quality Control, and data monitoring. Produce statistical programs as needed. Qualifications: Ph.D. or Master?s in Statistics At least 8 years of experience Prior experience in R, S, SAS and/or S-plus and Design of Experiments (DOE) Prior Data Mining knowledge (PLS, neural networks, OLAP, etc.) Breadth of statistical approaches (Q Value/false discovery rate, P Value, Bayesian, Frequentist, Monte Carlo Methods, multivariate data analysis, logistic regression, chi-squared, Random Forest (RF) predictors) Prior experience in a Life Sciences research and development environment Bioinfor...

...ly) (the old version, MSDE, is also available) - Oracle - 150mb download, if i remember correctly even free to distribute, but check the license - DB2 - 500mb download, currently 90 day version, IBM strong rumour is that early next year the new version will be free. Each commercial DB has some OLAP capability, but I am not sure how much of it is/will be available in the Express version. __________________________________________ Just $16.99/mo. or less. dsl.yahoo.com