Star schema selected the type the dimension table

152Oracle Essbase & Oracle OLAP: The Guide to Oracle’s Multidimensional Solution

3. Associate the attribute with levels by selecting the levels in the Apply Attributes To area. For this example, select CHANNEL.

Mapping Dimensions
As we described previously, we have source data for the dimension contained in either a table or a view. We must now tell AWM how to relate this source data to the dimension levels. This is done through a process called mapping.

There are three basic steps to mapping dimensions:

The mapping tool supports mapping standard star schemas, snowflake schemas, and source collections. This section covers the two basic types of mappings: star schema and snowflake schema.

Mapping Dimensions using a Star Schema In the following procedure, we map the demonstration data to dimension members and attributes using a star schema. After the procedure, we discuss the differences that would occur if we selected a snowflake schema instead.