Use this dialog to verify that Data Load Parameter values have been set correctly, and edit values where necessary. For example, you might want to change a Global Currency Code value from USD to EUR.
The Data Load Parameters pane (or master table) displays parameters and values, and the Group Specific Parameter Values for: pane displays associated Fact Groups or Dimension Groups (if there are any) and their values. You can specify different values for associated Fact Groups and Dimension Groups, except for Non-Overridable Application Specific parameters.
Element | Description |
---|---|
Data Load Parameters |
Use this list to navigate and edit Data Load Parameters. Options:
Columns:
|
Group Specific Parameter Values for: |
Use this list to view and edit parameter values for associated Fact Groups and Dimension Groups. The parameter values specified in this pane are specific to a Fact Group or Dimension Group. For example, you might specify the Time Grain as MONTH for the Order Fulfilment Fact Group, and the Time Grain as WEEK for the Purchase Cycle Fact Group. Global Parameters that are not associated with any Fact Groups or Dimension Groups do not show any records in this table. Options:
Columns:
|
Search (Only displayed when this dialog is invoked directly from Configuration Manager. Search is not available when this dialog is invoked from Functional Setup Manager (FSM)). |
For User Assistance on the Search pane, see Search pane. |
The Manage Data Load Parameter dialog provides several icons for common tasks.
Icon or Menu Option | Description |
---|---|
Application Specific Parameter or Non-Overridable Parameter If displayed in the Data Load Parameters pane (or top list), then this icon indicates an Application Specific parameter. If displayed in the Group Specific Parameter Values For pane (or lower list), then this icon indicates a Non-Overridable Application Specific parameter, which means that each associated Fact Group or Dimension Group must have the same value. In other words, if you change the value for one Fact Group or Dimension Group, then all Fact Groups and Dimension Groups are updated with that value (if you first confirm at a Warning dialog). |
|
Dimension Group This icon indicates that a Group Specific Parameter applies to a Dimension Group. |
|
Fact Group This icon indicates that a Group Specific Parameter applies to a Fact Group. |
|
Global Parameter This icon indicates that the parameter is global (that is, it applies to all (or a majority of) ETL tasks). |
|
Read Only Parameter The Lock icon indicates that you can cannot edit the parameter value. For example, the value might be read-only, or the value might be set in a different part of the application. |
|
Overridable Parameter This icon indicates an overridable Application Specific parameter, which means that each associated Fact Group or Dimension Group can have a different value if required. |
|
Set Before A Full Load The Alert icon indicates that you must set the value of a Data Load Parameter before you perform a Full Data Load. If you change this value after you have performed a Full Data Load, then you must perform a new Full Data Load. |
|
Parameter Category This icon denotes a grouping of related parameters, for example, the Configure Time Dimension category is a group of parameters that is related to calendars. To expand a Parameter Category, click Expand: To collapse a Parameter Category, click Collapse: |