Defining a Map from Source Model to Master Model
- 1 Minute to read
- Print
- DarkLight
- PDF
Defining a Map from Source Model to Master Model
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The Source Model is a 2-dimensional table of data whereas the Master model is a multidimensional model, so you will need to map the fields from the Source Model to the dimensions and members in the Master model.
Go to Model > External Source Model > Source Map.
Enter a name for the map.
Select the Master model from the Model drop-down.
Select the Source Model from the Source Model drop-down.
Select Data for Type.
Optionally set Append Missing Dimension Members to Yes. This option detects if there are leaf members detected in the Source Model that are not in the Master model and adds them dynamically at runtime.
Now specify the fields from the Source Model that map to a member in the dimension hierarchy of the Master model. Generally, fields that are text are mapped to dimension members. Fields that are numeric are mapped to values. Not all fields must be mapped.
Save the map.
Note:
Mappings are not case-sensitive.
Was this article helpful?