On 7-May-08, at 11:56 AM, Thomas Burkard wrote:
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
Hi Thomas,
sorry for the later reply but you mail somehow disappeared from our
radar screen.
there is no need for the key on dm to be unique, you are expected to
use an FK (protein_id_key) in your dm table
and everything will work fine as far as I can see
a.
--
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
