Many thanks Richard, that did the trick. Dr. Jay Moore Senior Research Fellow in Bioinformatics -- Warwick Systems Biology Centre Coventry House University of Warwick Coventry CV4 7AL U.K. +44 (0)24 761 50332 http://www2.warwick.ac.uk/fac/sci/systemsbiology/
-----Original Message----- From: Richard Holland [mailto:[email protected]] Sent: Wed 4/29/2009 10:59 AM To: Moore, Jonathan Cc: [email protected] Subject: Re: [mart-dev] Problem with boolean optimiser columns The MartView front-end currently expects boolean columns to be non-null for true, and null for false. When generating the boolean columns, you'll notice you've got different optimiser types in MartBuilder. I think you've probably selected the one that says "0/1" or similar. If you change the type to the one that says "1/null" and regenerate then it should work nicely. In the meantime, a 'quick fix' is to do a SQL update statement that replaces all the 0 values in your existing table boolean columns with nulls. cheers, Richard Moore, Jonathan wrote: > In our mart I have set up a main gene table and a number of dimensions, > with boolean optimiser columns in the main table, using martbuilder. > > In the resulting mart database, I have checked in the columns in the > main table and they have the correct values (a mix of 0 and 1). > However, in the results from martview, filtering to Include on an > optimiser column always returns all records and filtering to Exclude on > an optimiser column always returns no records. When I look in the > mart's dimension tables, the records for the non-existant rows do exist, > but all values are null except for the gene ID (key). > > Any ideas as to the problem? > > Dr. Jay Moore > Senior Research Fellow in Bioinformatics > -- > Warwick Systems Biology Centre > Coventry House > University of Warwick > Coventry CV4 7AL > U.K. > +44 (0)24 761 50332 > http://www2.warwick.ac.uk/fac/sci/systemsbiology/ > -- Richard Holland, BSc MBCS Finance Director, Eagle Genomics Ltd T: +44 (0)1223 654481 ext 3 | E: [email protected] http://www.eaglegenomics.com/
