Other
This dimension type has been provided to enable you to customize your application. This dimension can be hierarchical or flat. If you need another dimension that applies to all schedules, you can choose to use an Other dimension.
| Property or Attribute | Required | Required by the Import Wizard when Adding Members | Required by the Import Wizard when Updating Members | Notes | Default set by Import Wizard if value is missing from import file |
|---|---|---|---|---|---|
| ID | Required | Optional | Required (if Name not provided) | For hierarchical dimensions, a member named No dimension name with an ID of 0 must be defined to store the data for accounts not associated with the dimension. | The ID is automatically generated if not included. |
| Name | Required | Required | Required (if ID not provided) | The name can have up to 40 characters. Must be unique within the dimension. | No default. User must supply. |
| Description | Optional | Optional | Optional | The description can have up to 255 characters. | If not specified, defaults to the name. |
| Group | Required | Optional | Optional | Assigns the member to the named group. | Defaults to the base group in the hierarchy if the member is a reporting unit and its parent exists in the hierarchy. |
| Parent | Required | Required | Required | The member's parent. Applies only if the dimension is hierarchical. | No default. User must supply. |
| Hierarchy | Required | Optional | Optional | The hierarchy to which this member belongs. Applies only if the dimension is hierarchical. | The hierarchy of parent. |
| Consolidate | Required | Optional | Optional | Indicates whether this member should be consolidated (Y-Yes) or ignored (N-No) for rollup. Applies only if the dimension is hierarchical. | Y-Yes |
| Preceding Member | Optional (used to derive a related required field, Mem_ Order) | Optional | Optional | Specifies the member's position in the hierarchy. Applies only if the
dimension is hierarchical. Use the wild card character (*) to indicate the member is the first in the list. By default, members are placed in the order in which they are added to the hierarchy. |
For flat dimensions, placed after the last member. For hierarchical dimensions, placed after the last member of the hierarchy. |
This is the minimum format to add members to this dimension:
- Name
- No Change
- Best Case
- Worst Case
- Buy Competition