Category Information Window

Color Coding –The color of text in this window offers a clue to which dimensions will be impacted by an import. Blue text indicates the dimension will get populated based on the import data. Black and grey text indicates the dimension is not impacted by the import data and will be populated with only the dimension’s default value.

Dimension – This window lists all dimensions that belong to the category you selected as the Target for your import. Any virtual dimensions* that belong to a dimension, if there are any, display indented and in italicized text under the parent dimension from which they are associated.

*Note: Virtual dimensions are created from the attribute relationships of a dimension.

Source – Details listed here tell you what dimensions have been directly mapped to the import data and what other additional dimensions will be impacted by the import.

  • Import File – means the data for this dimension will come directly from the import file. This dimension has been directly mapped in the Data Mapping window for the import.

  • “Always sourced from a ... Attribute” means that the data for this dimension will be derived from its associated parent dimension. These are virtual dimensions created from an attribute of their parent dimensions.

  • “Sourced from … Previous Level Definition” means that the data for this dimension will be derived from another dimension using Stratum previous level relationships.

  • None – means the dimension wasn’t included in the import file or values for it couldn’t be sourced from previous level definitions or an attribute of a parent dimension. The only place import data will go to for these dimensions is their default value (typically represented by the “?” character in views).

In the following example, the import was directly mapped to the Customer Sold-To, RepBroker and Sales Director dimensions. Therefore, their source is Import File. All virtual dimensions under those dimensions (RepBroker State, RepBroker Type,and Sales Director Town) will have their data sourced from their associated parent dimensions. Four other dimensions will have their data sourced from previous level definitions– they are Customer Priority, Customer SIC Code, Customer Type, and Region.