Mapping fact tables to a cube

Select Dashboards > OLAP > Edit Database.

Select the database to administer.

Select the Cubes node of the Database Structure.

Click the Mappings icon of the cube to map.

Click New Mapping.

Specify a name for the mapping.

Specify a unique name for the mapping.

Optionally, add comments to the mapping.

Select the data connection to the relational data source.

Select the source table or view from which to load the fact data.

Click the Column Mapping tab.

Select one of these options:

Option	Description
Single	Select if the source table contains a single value column. Select the column that contains the values.
Dimension Driven	If the source table is dimension driven, select the dimension that drives the value.

For each dimension, select the mapping type.

Select whether to map to a source column or to a target element.

In the Element if not Found and Element if Empty columns, specify alternative elements to use if the specified target element is not found or has a null value.

Depending on the selected mapping type, select the appropriate source column name or target element name for each dimension.

You can use a custom setting in the Target Element Name column.

Optionally, turn off Clear Values.

If Clear Values is on, regions of the cube are cleared before the fact data is loaded. The regions are defined by the selections in the data area table. These rules apply:

If a target element is specified for a dimension then only values for that element are cleared.
If a target element is a consolidated element then the values of its descendants are cleared.
If a source column is specified for a dimension, and no elements are specified in the Clear Cube Area column, then the values for the entire dimension are cleared.
If a source column is specified for a dimension, and an element of that dimension is specified in the Clear Cube Area column, then only values for that element are cleared.
You can use a custom setting in the Clear Cube Area column.

Select one of these writing mode options.

Option	Description
Add	If a cube cell has a value, the new value is added to the current value.
Overwrite	If a cube cell has a value, then that value is overwritten by the most recently processed value from the source table.

Click the Run Settings tab and select one of these error handling options.

Abort at the first error, commit nothing
Commit all data and ignore errors
Try to run over errors, commit nothing if an error occurs

Optionally, select Log warnings for element name replacements.

If selected, this option logs every instance of an element being replaced during import.

Save the mapping.