Bookshelf Home | Contents | Index | PDF |
Siebel Marketing Installation and Administration Guide > Configuring Marketing Module Metadata > Setting Up Marketing Segmentation Metadata > Setting Up Conforming Dimension LinksConforming dimensions can be used when a star might include a dimension with the target-level ID. A conforming dimension links a fact that contains target-level IDs to a fact that does not contain target-level IDs by navigating along a dimension that is shared by both fact tables. Conforming dimensions can be chained. For example, the Siebel Data Warehouse might have an Offer-Product Star schema. To segment individuals who are offered a particular product, you need to set up the following two conforming dimension links:
The marketing module reads these links and identifies the campaigns that included the products that were offered and then identifies all the contacts that were targeted in those campaigns. To setup conforming dimension links
To duplicate a conforming dimension link
Conforming Dimensions ExampleA bank might track service requests at bank-account level and not the contact level. In this example, there is an intersection fact that identifies the contacts that belong to each account (Contact-Account) and another fact table that tracks the service histories of the service requests on the accounts. The bank needs to perform the following mappings: |
Siebel Marketing Installation and Administration Guide | Copyright © 2006, Oracle. All rights reserved. | |