Organization structure (Unit)

Organization structures are the units, locations, departments, or other organizational pieces of the company where financial data is specified or consolidated.

You can define multiple hierarchies for the same dimension using the Hierarchy attribute. You can include reporting members in multiple hierarchies. However, consolidating members that are in multiple hierarchies must have the same children and parent and child relationships in each hierarchy.

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) 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 For any hierarchical dimension, this attribute assigns a dimension member as belonging to the group named. Defaults to the base group in the hierarchy if the member is a reporting unit and its parent exists in the hierarchy.
Preceding Member Required Optional Optional Specifies the position of the member in the hierarchy.

Specify the member that precedes this member. Use the wild card character (*) to indicate the member is the first in the list.

Placed after the last member in the hierarchy.
Parent Required Required Required The member's parent. No default. User must supply.
Hierarchy Required Optional Optional The hierarchy to which this member belongs. The hierarchy of parent.
Currency Required Optional Optional Identifies the unit's functional currency that will be represented within the application as the local, untranslated currency. All data input through data entry or data loading, is initially assigned as local, untranslated currency. The first currency (based on member order) in the Currency dimension other than the one assigned to reserve local currency (ID=0)
Elimination Status Optional Optional Optional Units can have one of these identifiers:
  • " " No identifier indicates no special characteristic or usage
  • E (Elimination): a special unit used to collect intercompany elimination posting during the consolidation process
  • A (Affiliate): a unit that participates in the intercompany process; intercompany transaction balances can be entered for this unit
  • O (Ownership): a special unit used to collect ownership journal postings during the consolidation process. Do not use this unit type if the ownership process is turned off.

Units with an elimination status of O or E must be leaf-level members with at least one ancestor member.

Null
Consolidate Required Optional Optional Indicates whether this member should be consolidated (Y-Yes) or ignored (N-No) for rollup. Y-Yes
% Ownership Required Optional Optional Percent of total to aggregate into parent. 100%
Class Optional Optional Optional Links units and schedules. Used by the Data Loader. Null

This the minimum format to add members to this dimension:

  • Name, Parent
  • Total Company, *
  • Cost Center, Division
  • Country, Cost Center
  • Division, Total Company
  • Unit, Country
  • Entity, Legal Rollup