Bookshelf Home | Contents | Index | PDF |
Siebel Analytics Server Administration Guide > Setting Up Aggregate Navigation > Create Dimension Sources for Each Level of Aggregated Fact DataIn addition to creating the source for the aggregate fact table, you should create corresponding logical dimension table sources at the same levels of aggregation. Using the example of a monthly sales table containing a precomputed sum of the revenue for each product in each store during each month, you need to have three other sources—one for each of the logical dimension tables referenced in the example:
Although you have a choice to specify aggregate content by logical level or column, it is recommended that you use logical levels exclusively. This source content information tells the Siebel Analytics Server what it needs to know to send queries to the appropriate physical aggregate fact tables, joined to and constrained by values in the appropriate physical aggregate dimension tables. Be sure that joins exist between the aggregate fact tables and the aggregate dimension tables in the Physical layer. One recommended way to accomplish this is to select an aggregate fact table source and the corresponding aggregate dimension table source and show the physical diagram (selected tables only). Verify there is a join from the tables in the logical dimension table source to the tables in the logical fact table source. Creating Sources for Each Logical TableUse this procedure to create sources for logical tables. To create the sources for each logical table
|
Siebel Analytics Server Administration Guide |