PDA

View Full Version : compound primary keys in schema/dimensions?



tchao
09-29-2003, 10:23 AM
does anyone know if it's possible to create dimensions that have compond primary keys?
i have a table with primary key = (accountid, brandid)
tried primaryKey="ACCOUNTID,BRANDID"
and foreignKey="ACCOUNTID, BRANDID"
in me schema.xml but seem to be having problems
thanks in advance

jhyde
04-07-2004, 11:18 AM
See
https://sourceforge.net/forum/message.php?msg_id=2301689

meteko
12-14-2007, 07:53 AM
Permission Denied

Access to this page is restricted (either to project members or to project administrators) and you do not meet the requirements to access this page. Please contact the administrator of this project for further assistance.

jhyde
12-16-2007, 03:36 PM
Oh sorry, we shut down the SF.net forums. Luckily we made a copy of the SF.net forums at pentaho.org. Here's that forum thread, titled "dimension with 2 fields in PRIMARY KEY": http://forums.pentaho.org/showthread.php?t=46846

Julian