On 21 Dec 2006, at 16:37, David Croft wrote:
Hi Arek,
if you want to fix it and they intend to be unrelated just change the
dataset
name for one of them e.g.
call one
test_reactome_18
and the other
test_reactome_19
or something like that.
You will probably tell me to RTFM,
nope :) I think our docs have still big room for improvement :)
but...how do you change the
dataset of a main table? Does the Mart Editor let you do that?
Not sure what state is your xml now after all this copying and pasting
but assuming that you had one xml for test_reactome_18 table
then you would have to rename the other to 'something_else' and then
simply run update on your xml to pick it up
or starting from scratch, you would to 'naive' for one and for the
other one
Do I then have to copy the dimension tables into the new dataset?
yes I am afraid and they have to share the same name of the dataset.
Do your main tables share the same dimensions at the moment?
That's interesting. We only see it if the main tables are related ei one
is 1:n to the other. In this case you can create a composite dataset
exactly like
you had before but one of them would have an additional key., For an
example
look at ensembl gene and transcript main tables
a.
Cheers,
David.
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------
