Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Setting Up Aggregate Navigation > About Aggregate Navigation >

Create Dimension Sources for Each Level of Aggregated Fact Data

---

In the source that references an aggregate table, you define a content specification, as described in Specify Content of Source. The content specification (in the Advanced tab of the Logical Table Source window) in the example in Specify Content of Source specifies an aggregate fact table at the Product.Product_Name, Store.Store_Name, and Time.Month levels. In addition to the source for the aggregate fact table, you should create corresponding logical dimension table sources at the same levels of aggregation.

Using this example, you need to create three other sources—one for each of the logical dimension tables referenced in the example:

A source for the Product logical table with the following content specification:

GROUPBYLEVEL (ProductDimension.ProductLevel)

or

GROUPBYCOLUMN (Product.Product_Name)

A source for the Store logical table with the following content specification:

GROUPBYLEVEL (StoreDimension.StoreLevel)

or

GROUPBYCOLUMN (Store.Store_Name)

A source for the Time logical table with the following content specification:

GROUPBYLEVEL (TimeDimension.MonthLevel)

or

GROUPBYCOLUMN (Time.Month)

NOTE:  If the sources at each level already exist, you do not need to create new ones. You need to have at least one source at each level referenced in the aggregate content specification.

You do not have to use GROUPBYCOLUMN or GROUPBYLEVEL exclusively. You can mix the use of both expressions.

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, as described in Dimension-Specific Aggregation Rules.

Creating Sources for Each Logical Table

Use this procedure to create sources for logical tables.

To create the sources for each logical table

In the Business Model and Mapping layer of the Administration Tool, select the Sources folder under the logical table and select New Logical Table Source from the right-click menu.
In the General tab of the Logical Table Source window, enter a name for the source.
Click Add to select the physical tables that populate the source.

For example, if the Product_Name column comes from a physical table in a database named OrderEntry, navigate to that table in the Browse window, select the table and click Select. This adds the table to the Logical Table Source window.

Map any columns in the logical to physical mapping area of the window.

Any physical columns with the same names as the logical columns are mapped automatically.

In the Content tab of the Logical Table Source window, describe the content specification of the source. To use the Expression Builder to configure the content specification, click the button to the right of the content pane.
Set any necessary WHERE clause constraints.
Repeat this process for each source corresponding to the logical tables in the aggregate table's content specification.

Bookshelf Home | Contents | Index | Search | PDF