-
Select .
-
Select the database to administer.
-
Click the Dimensions node of the database structure.
-
Click the Hierarchies icon of the
dimension for which to create mappings.
-
Click the Mappings icon of the hierarchy.
-
Click New Mapping.
-
Specify a name for the mapping and, optionally, add
comments.
-
In the Data Connection field, select
the data connection that connects the application to the staging database.
-
Select Level-Based Table as the source data type.
-
Select the source table.
-
Optionally, in the Element Order
Column field, select a column of the source table.
The column that you select determines the order in which elements are created.
-
Click the Attributes tab.
-
Click Add Level.
-
In the Level column, specify the top
level.
For example, if the source is a table of countries, the top level might be
Continent.
-
In the Column column, select the column in the source table from which
to populate the level.
For example, if the level is Continent and the source table contains a column
called Continent Name, select Continent Name.
-
Add levels as necessary and click Save.
For example, if the source is a table of countries, the levels might be
Continent, Region, and Country.
-
Select the check box of a level.
The Attribute to Column Mapping for [level name] table is displayed.
-
Click an attribute in the Attribute
column and select the source table column that holds the value of the
attribute.
For example, if the selected level is Region and the attribute is Population,
select the column in the source table that holds the values for region
populations.
-
Repeat steps 16 and 17 for each level.
-
Click Save.