Analysis Hierarchy Labels - Input Payload Overview

The input payload is divided into four sections:

  • <User> identifies the User.
  • <SunSystemsContext> identifies the Business Unit.
  • <AnalysisHierarchyLabels> contains the data items that identify the Analysis Hierarchy Label to be created or amended.
  • <AnalysisHierarchyCodes> contains the data items that identify Analysis Hierarchy Codes to be created or amended for the parent Label.

For further information, refer to the Input Payload Element Definitions section.

Specifying the Analysis Dimension

In the payload, you can specify the Analysis Dimension as either the text equivalent that is displayed in SunSystems, for example, 'ACCOUNT CODE', or its internal SunSystems database representation, '13'. This feature is intended for use by developers.

The following table shows the values for Analysis Dimensions, with the SunSystems database representation and the matching text equivalent:

Database Representation Text Equivalent
02 BUSINESS TYPE
03 LEAD SOURCE
04 REPORT GROUP
05 ACCOUNT MANAGER
06 ASSET CLASS
07 ASSET LOCATION
08 ASSET SUPPLIER
09 ASSET INSURER
10 ASSET MAINTAIN
11 PRODUCT
12 DEPARTMENT
13 PROJECT
14 EMPLOYEE
15 CUSTOMER
16 TAX
17 LOCATION (ANL)
18 ACCOUNT CODE
19 ASSET
20 CURRENCY
21 ZONE
22 WAREHOUSE
23 SUPPLIER
24 SALES TYPE
25 MOVEMENT TYPE
26 REPORT LOCAL
27 ITEMCODE
28 CUST TYPE
29 CUST VAT
30 UNIT LABEL

Analysis Hierarchy Relationships

It may help to think of the Analysis Dimension as a parent of an AnalysisHierarchyLabel and an AnalysisHierarchyLabel as the parent of an AnalysisHierarchyCode. That is, an AnalysisHierarchyCode 'belongs' to an AnalysisHierarchyLabel that in its turn 'belongs' to an Analysis Dimension.

When creating Analysis Hierarchy Codes, you must ensure that the correct AnalysisDimension or AnlCat_SHead payload value is the correct one for the AnalysisHierarchyLabel payload value and that the AnalysisHierarchyLabel value is the correct one for the AnalysisHierarchyCode payload value.

Case Conversion

Any character you type in the following fields is automatically converted on the screen into upper case:

  • Analysis Dimension
  • Analysis Hierarchy Label
  • Analysis Hierarchy Label Look Up
  • Analysis Hierarchy Code
  • Analysis Hierarchy Code Look Up.

SASI/DJI Differences

Whilst this DJI method replicates (as far as possible) the SunSystems SASI AnalysisHierarchyLabels CreateOrAmend method, there are the following differences:

  • In the DJI method some error messages have been clarified.
  • When creating or amending Analysis Hierarchy Codes, the DJI method allows you to omit the Analysis Dimension (<AnalysisDimension>) and the Analysis Hierarchy Label (<AnalysisHierarchyLabel>) from the <AnalysisHierarchyCodes> element. If omitted, the values from the parent Label are used. If you are creating or amending Labels and Codes in bulk, this reduces the size of the input payload. The SASI method requires you to duplicate the Analysis Dimension and the Analysis Hierarchy Label values within the <AnalysisHierarchyCodes> element an error message is displayed if they are not present.
  • The DJI method issues an error message if an Analysis Hierarchy Label and/or Analysis Hierarchy Code <Status> value is outside the allowable range of 0-3, where 0=Open, 1=Hidden, 2=Suspended/Held and 3=Closed. The SASI method updates the database setting the Analysis Hierarchy Label and/or Analysis Hierarchy Code Status to 0 (Open).
  • The DJI method issues an error message if an invalid Analysis Dimension (<AnalysisDimension>) value is specified. The SASI method ignores the Analysis Dimension (<AnalysisDimension>) value and uses the <AnlCat_SHead> value instead.
  • The DJI method does not issue an error message if the <AnlCat_SHead> value is omitted from the payload and instead uses the Analysis Dimension (<AnalysisDimension>) value if specified. This feature is intended for use by developers. The SASI method requires a value for the <AnlCat_SHead> element to be present and ignores the <AnalysisDimension> value.
  • The DJI method issues an error message if the <AnlCat_SHead> value and the Analysis Dimension (<AnalysisDimension>) value refer to different Analysis Dimensions. For example, where <AnalysisDimension> is specified as '11', (corresponding to 'PRODUCT') and <AnlCat_SHead> is specified as 'ACCOUNT CODE' (corresponding to Analysis Dimension '18'). This feature is designed for developers. The SASI method ignores the inconsistency of the data and uses the <AnlCat_SHead> value instead.