|
Analysis Dimensions and Codes Setup |
|
|
|
|
Sun Documentation -
General Ledger
|
|
Page 4 of 6 Analysis HierarchyOnce the Analysis Dimensions have been created, it is then be possible to create Analysis Hierarchies. This will enable analysis to be captured at the lowest level, speeding up data entry, and then grouping for reporting purposes. Therefore codes that are grouped together do not need to be in sequential ranges. Hierarchies can be used when, looking at our example, the organisation wishes to analyse the countries in which it has made sales, and then group those countries into regions for reporting. Instead of creating composite codes for each different combination, a hierarchy of regions could be created to capture the necessary analysis codes. An Analysis Code would also be able to belong to a number of different hierarchies but it would not be able to belong to more than one subset of a single hierarchy. An analysis hierarchy allows you to divide the analysis codes for a dimension into logical groups. It provides a second, higher level of analysis for reporting purposes. This enables analysis to be captured at the lowest level, speeding up data entry, and then grouped and summarized at a higher level. The flexibility of grouping codes in a hierarchy is that the analysis codes within a group do not need to be in sequential number ranges. If we continue to use the example of our new Analysis Dimension – Country – we can show how the codes we have created could be grouped in regions: Analysis Dimension
| Analysis Code
| Analysis Hierarchy
| Country
| UK
| Europe
|
| Spain
|
|
| France
|
|
| USA
| The Americas
|
| Argentina
|
|
When codes move between different groups, e.g. Departments after a restructuring, both the old and the new hierarchies can be maintained, allowing reporting on either basis, as appropriate. Lets now create the Analysis Hierarchy as shown in the table above. |