title: SSAS One to Many Dimensional Relationship
body: <p>Question in SSAS for y'all.  I am attempting to define a One to Many relationship in an OLAP SSAS cube environment.  However, i'm running into problems with defining a primary key.  Example tables are below.  Relationships between the first 3 tables are easily defined (TradeDate, NYMEX Trades &amp; NYMEX Contract).  However, my goal is to create a one to many relationship between NYMEX Contract and Model Contract.  In other words, the data from 1 NYMEX Contract will be utilized multiple times in the Model Contract dataset.  </p>
  
  <p><strong>Table: TradeDate</strong></p>
  
  <ul>
  <li>TradeDate (PK)</li>
  <li>Year</li>
  <li>Month
  etc...</li>
  </ul>
  
  <p><strong>Table: NYMEX Trades (NO PK)</strong></p>
  
  <ul>
  <li>ContractName</li>
  <li>TradeDate</li>
  <li>Price</li>
  </ul>
  
  <p><strong>Table: NYMEX Contract</strong></p>
  
  <ul>
  <li>ContractName (PK)</li>
  </ul>
  
  <p><strong>Table: Model Contract</strong></p>
  
  <ul>
  <li>ModelContractName (PK)</li>
  <li>ContractName</li>
  </ul>
  
  <p>I need to create a one to many relationship between NYMEX Contract and Model Contract...however my PK is on the wrong column in Model Contract.  Any ideas?</p>
  
  <p>To help clarify - i am attempting to define a dimension --> dimension relationship.  The Table "Model Contract" is a lookup table.</p>