Financial Reporting Subdimensions

Subdimensions are used to isolate individual characters within the analysis codes for a dimension. Each subdimension is identified by a code, within the dimension. Subdimensions are used by the Financials report writers to select transactions.

Each analysis code can include a maximum of 15 characters, depending on the length defined in Analysis Dimension (AND). You can use subdimensions to isolate individual characters, or groups of characters, within an analysis code for reporting purposes. This is possible where you have a structured analysis code.

It is best explained using an example:

You may have defined an analysis dimension for Product Type which uses three character codes. The following analysis codes have been defined: A10, A20, A30, A50, B10, B30, B40, C10, and C50. The first character, A to C, represents the material from which the product is made. The second and third characters represent the product size. On a report, you may want to group together different product types which use the same material, and on another report you might want to group different product types of the same size.

This type of analysis is done using subdimensions as follows:

1. So:

• Subdimension A would mask out with asterisks characters 2-3 ( **) because only the first character is important.
• Subdimension B would mask out with asterisks character 1 (* ).

• Use Analysis Codes (ANC) to create the subcodes for materials A, B and C and for sizes *10, *20, *30, and so on. When you create subcodes, you should place asterisks to the left of the code to indicate the characters to be ignored. You should not, however, place trailing asterisks to the right of the code. These codes are defined to provide the labels for the subcodes for reporting purposes.
• Refer to the subdimension in the relevant Financial Analysis Layout or Financial Statement Layout.
• When you run the report using Financial Analysis or Financial Statements, you enter the subdimension code ranges. During Ledger Entry, you must always use full analysis codes.