This view contains a “Distribution Partner” User Controlled Attribute that was created for the Customer Parent dimension. This example will show master data being imported to populate the attribute with data.
An import file containing key values for the associated dimension and master data values for the attribute was set up in Excel. One column has dimension key values while the other has attribute values. A heading row contains names that identify information in the columns, which is helpful to the user when mapping data into Stratum.
The user initiates the import from the Master Data Import list window.
After choosing the Excel file for the import, the user provides basic import configuration details including which dimension to use in the import.
Then, the user maps the import data to Stratum. The mapping window has drop-down lists to define the type of information in each column, where in Stratum to import data from the import file, and which columns, if any, to ignore in the file.
Imported data can be used in views as soon as the import completes processing. Here is the view from earlier in the example, showing the “Distribution Partner” User Controlled Attribute populated with the imported master data.
