Integration

Integration settings control and determine which columns of data you can see and map to in the stage area by a Scenario Type. This section controls the Dimensions that can be updated by the Import Input Type in Workflow and the columns of data that appear in the Stage database when imported data is viewed. It determines the order of processing Dimensions and which are turned on for data integration.If one Dimension has to process before another, which is a rare case, the transformation sequence could be changed.  

Cube Dimensions

This is a list of Dimensions to which a particular Cube can be mapped.

Cube Dimension Name: This cannot be changed.

Transformation Sequence: Order in which a Dimension’s Transformation Rules will be processed for a given Scenario Type.

Enabled: When a Dimension is Enabled, it will appear in the Stage area and data can be imported for a particular Scenario Type. 

Special Dimensions: There are also special fields that can be mapped to the Stage area but not mapped to the Cubes. They can be drilled back from the Cube or used in Derivative Rules. The use of these fields does increase processing times. Below are the following items:

Label Dimensions:

Label: This would be the description for any given Account that was related to a particular line of data. It is imported for reference purposes.

Source ID: This is one of the keys to the data in the Stage and be enabled. It can be mapped in by a Data Source and set to a particular value in a file, the file name, or a tab name from an Excel file. Max length is 100 characters.

TextValue: This is to store large amounts of textual data. Max size is 2GB of text.

Attribute Dimensions

These 20 Dimensions can each store 100 characters of text.

Attribute Value Dimensions

These 12 Dimensions can store numeric data. By default, the Zero Suppression settings for Attribute Value Dimensions are set to True. When developing a Data Source using Attribute Value Dimensions where a specific value is 0, be aware that the data may be suppressed. Therefore, in some cases, Zero Suppression for an Attribute Value Dimension may need to be set to False.

Below are the properties for each item:

  • Alias: This controls the column header that appears for this Dimension when viewing data in the Import Input Type in Workflow.

  • Transformation Sequence: This is the order in which a Dimension’s Transformation Rules will be processed for a given Scenario Type.

  • Enabled: When a Dimension is Enabled, it will appear in the Stage area and data is allowed to be imported into it for a particular Scenario Type.