Defining a Map from Source Model to Master Model

1 Minute to read

Print
Dark
Light
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?

What's Next

Using a Calculation to Load Data into the Master Model