Question in SSAS for y'all. I am trying to define a one-to-many relationship in an OLAP SSAS cube environment. However, I am having problems defining a primary key. The following are examples of tables. The relationships between the first three tables are easily defined (TradeDate, NYMEX Trades and NYMEX Contract). However, my goal is to create a one-to-many relationship between the NYMEX contract and the model contract. In other words, data from 1 NYMEX contract will be used several times in the model contract data set.
Table: TradeDate
- TradeDate (PK)
- Year
- Month, etc ...
Table: NYMEX Trades (NO PK)
- Contractname
- TradeDate
- Price
Table: NYMEX Contract
Table: Model Contract
- ModelContractName (PK)
- Contractname
" " NYMEX ... " ". ?
- → . " " .