Dear mart dev team,
is there a possibility to create a composite primary key (multiple
columns) for a dimension table, which can be used in the key fields of
filters?
I want to query synonyms in the following scenario:
protein_main
protein_id_key
protein_synonym_dm
protein_id_key
protein_synonym
species
in protein_synonym_dm neither protein_id_key nor protein_synonym is
unique but the composite of all three fields. Can I specify at some
point a composite key? Which consequences are expected, if I use a non
primary key in the "key" field of filters?
Thank a lot,
Thomas
--
Thomas Burkard
CeMM - Research Centre for Molecular Medicine of the Austrian Academy of Science
Lazarettgasse 19/3. floor, A-1090 Vienna, Austria
Tel.: +43/1/40160 70 021
Fax.: +43/1/40160 970 030
Email: [EMAIL PROTECTED]
URL: http://www.cemm.at
