On Mon, 3 Jul 2006, allank wrote: > Hi Damian, > I managed to solve the earlier problem, I simply deleted all existing > the configurations using martj then started again by selecting 'naive' > and the web site was able to use the naive configuration well. I then > opened the xml in a text editor and modified portions to include > portions of xml I had generated using xsl from my table database schema. > But a new problem arised, using two main tables where one main table > inherits the all the fields of the other table and uses the other > table's PK as it's FK, and having dimension tables from both the main > tables (each dm table referenced only one of the main tables), very > many records were being returned in the output section, perhaps a > cartesian product was being returned.
Do you have some sample SQL to illustrate this. BTW you can uncomment the warn($sql) in BioMart::Dataset::TableSet to see what the mart software is doing - is useful for debugging these sort of things > So I reverted to using only one main table (by combining the main > tables), for the dimension table that referenced only the main main > table and now only a subset of the new main table, for each row in the > main table that matched a given row in this dm table, I created a > duplicate row for it in the dm, that way each similar record in the main > table is represented in the dm table. > so is it all working ok now then? best wishes Damian > Allan. > > Damian Smedley wrote: > > >On Sat, 1 Jul 2006, allank wrote: > > > > > > > >>Hi all, > >>Is there any XML schema or dtd for biomart 0.4 xml configuration > >>document I would use to validate the configuration document I am > >>generating against. > >> > >> > > > >The DTD we had was pretty basic so not that useful for validation. > >MartEditor does a lot of validation checks when you export the XML to the > >databases such as checking the tables and fields exist, internalNames are > >not duplicated etc. > > > >Are you still having the same error - send us your XML if you want me to > >take a look at it > > > >cheers > >Damian > > > > > > > > > >>Allan. > >> > >> > >> > > > > > > > >
