Add new members
When importing additional members to a dimension, the structure data must contain, at minimum, the name of the member. For hierarchical dimensions, the parent name must also be specified.
Although schedule name is required for lines (members) within the Schedule dimension; it does not have to be included in the structure data. You can specify a default when mapping the schedule line if the schedule lines being imported belong to the same schedule.
Remember, members are added when updates occur when a member listed in the structure data does not match a member that already exists in the database dimension. See the example structure data:
- Line, Acct, Sign
- SchedLine F, BA, C
- SchedLine C, BA, C
Is imported into this Schedule dimension:
Schedule line | Account type | Natural sign |
---|---|---|
SchedLine A | PR | C |
SchedLine B | PR | C |
SchedLine D | PE | D |
SchedLine E | PE | D |
Then SchedLine C and SchedLine F are changed as shown:
Schedule line | Account type | Natural sign |
---|---|---|
SchedLine A | PR | C |
SchedLine B | PR | C |
SchedLine D | PE | D |
SchedLine E | PE | D |
SchedLine F | BA | C |
SchedLine C | BA | C |