PDA

View Full Version : dimension with 2 fields in PRIMARY KEY



greatmaster
11-23-2003, 09:00 PM
Hi,
i have a dimension table which have 2 fields composing the FOREIGN KEY. How can i build my schema when i join this dimension with the fact table ?
Is it possible to write :
<dimension name='myDimension' foreignKey='field1,field2'> ????
If not am i obliged to define a PRIMARY KEY on 1 field ??
thanks
eric

jhyde
11-23-2003, 09:48 PM
Mondrian does not support compound keys, and there are no plans to do so. You should modify your schema to use a non-compound key.