Bookshelf Home | Contents | Index | PDF |
Siebel Business Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Tables > Reviewing Foreign Keys for a Logical TableYou can use the Foreign Keys tab to review the foreign keys for a logical table. CAUTION: It is recommended that you do not have foreign keys for logical tables. However, you can create logical foreign keys and logical complex joins using either the Joins Manager or the Business Model Diagram. A logical key for a fact table must be made up of the key columns that join to the attribute tables. For more information, see Defining Logical Joins. Joins and Fact TablesIn fact tables, it is recommended that you use complex logical joins instead of foreign key logical joins. If complex logical joins are used, then there is more flexibility in defining the primary key. If the physical table has a primary key, then this field can be used as a logical key for the fact table. NOTE: This is the method recommended for the analytics repository. To review foreign key information for a logical table
|
Siebel Business Analytics Server Administration Guide |