Configuration lines

The second part of a configuration file defines the configuration lines for related dimensions except for the Period dimension. A configuration line defines how the data in the data file is arranged and how the data is associated with the fact table in the database. Dimension configuration lines can be specified by member name or ID. These two lines are valid:

• Schedule, ID, 2
• Currency, Name, 3

The last part of a configuration file defines the configuration lines for the Period dimension. Periods must be identified by member name, not member ID. This line is valid:

Period, May, 14

while the next line is invalid:

Period, ID, 14

Use this convention for dimension configuration lines.

<dimension | Ownership_Property ownership parameters>, <ID | Name>, <location in data file>

For example:

Year, ID, 1
Schedule, ID, 2
Unit, ID, 3
Version, ID, 4
Product, ID, 5
Sales Channel, ID, 6
Period, Opening Balance, 7
Period, January, 8
Period, February, 9
Period, March, 10
Ownership_Property, Name, 1
Year, ID, 2
Version, ID, 3
Top_Unit,ID,4
Holder, ID, 5
Invested, ID, 6
Cons_Unit, ID 7
Period, January, 8
Period, February, 9
Period, March, 10

<dimension | Ownership_Property> is the dimension name defined when setting up the database or the phrase Ownership_Property. Ownership_Property is used to specify the columns for different ownership property data or the column for consolidation percentages. These values can be specified in the Ownership_Property column.

Value	Description
DOP	Specifies the data line to be loaded into the Own_Holdings_Base table.
ECP	Specifies the data line to be loaded into the Own_EffectiveControlPct_Base table.
EOP	Specifies data line to be loaded into the Own_EffectiveOwnershipPct_Base table.
OVR	Specifies the data line to be loaded to the Own_Override_Base table.
CON	Specifies the data line to be loaded to the Own_ConsolidationPct_Base table.

If you have specified Ownership_Property, you must also set the ownership properties.

Value	Description
Year	Specifies the year to which the ownership data applies.
Version	Specifies the version to which the ownership data applies.
Top_Unit	Specifies the ID of the top parent in the hierarchy to which the holder and invested units belong.
Holder	Specifies the ID of a leaf level descendant of the Top_Unit unless the Holder owns 100% of the Invested unit.
Invested	Specifies the ID of a leaf level descendant of the Top_Unit within the same organizational hierarchy as the Holder unit.
Cons_Unit	Specifies the ancestor unit for the consolidation units. This parameter is ignored if you have specified DOP as an ownership property.

<ID | Name> specifies whether the member ID or member name is used in the data file. For Ownership_Property this must be set to Name.

<location in data file> specifies the location of the member data within each line of the data file. The data file format determines the conventions used for this component.

For delimited files, <location in data file> specifies the order of the member on the data line. For example:

Version, Name, 1

For fixed format files, <location in data file> specifies the position range of the data. For example:

Version, Name, 5, 15

In general, dimension order is not important except the Period dimension must be last.