Map Dimensions and Measures

Mapping defines the relationship between cube dimensions and measures and the corresponding fields in a data source. This ensures that the cube uses the correct data from the source when building or refreshing. Without proper mapping, dimensions or measures in the cube will be empty if their data source fields are not linked. Only the dimensions and measures that exist in the current data source need to be mapped — unmapped cube elements are treated as empty during refreshes.

Benefits of mapping

• Matching field names: Link fields to cube dimensions and measures even when names differ.
• Converting data types: Map fields to compatible cube data types to prevent format errors.
• Integrating multiple sources: Apply consistent field links across multiple data sources.

Make the cube editable

1. In the Administration page, select OLAP Manager from the sidebar.
2. In the cube list, select the cube where you want to create a data source.
3. Clear the In Production checkbox.
4. Click Save.

Map dimensions and measures

1. In the Options panel on the right, click the Navigation icon.
2. Select Data Sources.
3. In the Options panel, click the Data Source icon.
4. Select Dimension Mappings or Measure Mapping.
5. In the Cube Dimensions/Cube Measures panel on the left, drag a dimension or measure into the Mapped Dimensions/Mapped Measures column. Click Add All to map all cube dimensions or measures.
6. In the Data Source Fields panel on the right, drag a field into the Mapped Fields column. Click Add All to map all data source fields.
7. Arrange the mapped dimensions/measures and fields in matching order.
8. Click the Link icon between a dimension/measure and a field to create a link and define its status.
9. In the Options panel, click Save Mapping.

tip

In the Options panel, click Auto Map to automatically align dimensions/measures and fields with the same name.

Linked legend

In the Options panel on the right, click the Legend icon to view the meaning of link statuses.

Status	Description
	Indicates a fully compatible link between the cube element and the data source field. Data maps directly without requiring transformation and without risk of data loss.
	Indicates a valid mapping, but some precision or length may be lost due to data type conversion. Examples: mapping Int64 to Int16, mapping String[50] to String[20].
	Indicates mapping is valid only if the field’s data matches the target data type format. Examples: String "ABC" to Int64 is invalid because it contains non-numeric characters. String "XYZ" to DateTime is invalid because it does not match any recognized date format.
	Indicates the mapping is invalid. The cube element will not receive data from this field until the link is corrected.