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/
