Mapping to a flat source table
- Select Dashboards > OLAP > Edit Database.
- 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.
- Optionally, add comments to the mapping.
- In the Data Connection field, select the data connection that connects the application to the staging database.
- Select Flat Table as the source data type.
- Select the source table.
-
In the Element Name Column field,
select the source column that identifies the name of the elements in the source.
For example, a CurrencyName column in a currency table, or a ProductName table in a table of products.
- Optionally, in the Element Type Column field, select a source column that identifies the type of elements in the source.
- Optionally, in the Element Order Column field, select the source column that identifies the order of the elements.
- Optionally, map attributes to columns in the source table.
- Click Save.