5.3.7 Dimension Leaf Member Set-Up
Dimension Leaf Values can have a maximum of 14 digits.
Only 26 Key (processing) Dimensions are allowed in the database. Examples of Seeded Key Leaf types are Common COA ID, Organizational Unit ID, GL Account ID, Product ID, Legal Entity ID.
The maximum number of columns that the Oracle Database allows in a unique
index is 32. This is the overriding constraint. After subtracting IDENTITY_CODE,
YEAR_S, ACCUM_TYPE_CD, CONSOLIDATION_CD,
and
ISO_CURRENCY_CD,
this leaves 27 columns available for Key
Processing Dimensions (Leaf Dimensions). BALANCE_TYPE_CD
is now part of
the unique index so this brings the maximum number of Leaf columns down to 26.