How to: |
You can manually code the relationship between parent and child fields in a Master File, and, optionally, provide descriptive captions to display in reports in place of the specified hierarchy field values.
FIELD=parentfield,...,PROPERTY=PARENT_OF, REFERENCE=[seg.]hierarchyfld, $ DEFINE name/fmt=expression;,PROPERTY=PARENT_OF,REFERENCE=hierarchyfld, $
where:
Is the parent field in the hierarchy.
Identifies this field as the parent of the referenced field in a hierarchy.
You can specify attributes in every field. Therefore, you can define multiple hierarchies in one Master File. However, an individual field can have only one parent. If multiple fields have PARENT_OF attributes for the same hierarchy field, the first parent found by traversing the structure in top-down, left-to-right order is used as the parent.
Is the segment location of the hierarchy field. This is required if more than one segment has a field named hierarchyfield.
Is the child field in the hierarchy.
PARENT_OF is also allowed on a virtual field in the Master File:
DEFINE name/fmt=expression;,PROPERTY=PARENT_OF,REFERENCE=hierarchyfld ,$
The following attributes specify a caption for a hierarchy field in a Master File:
FIELD=captionfield,...,PROPERTY=CAPTION, REFERENCE=[seg.]hierarchyfld,$ ,$
where:
Is the name of the field that contains the descriptive text for the hierarchy field. For example, if the employee ID is the hierarchy field, the last name may be the descriptive text to be displayed on the report in place of the ID.
Signifies that this field contains a descriptive caption to be displayed in place of the hierarchy field values.
A caption can be specified for every field, but an individual field can have only one caption. If multiple fields have CAPTION attributes for the same hierarchy field, the first parent found by traversing the structure in top-down, left-to-right order will be used as the caption.
Is the segment location of the caption field. This is required if more than one segment has a field named captionfield.
Is the hierarchy field.
CAPTION is also allowed on a virtual field in the Master File:
DEFINE name/format=expression;,PROPERTY=CAPTION,REFERENCE=hierarchyfld ,$
The CENTGL Master File contains a chart of accounts hierarchy. The field GL_ACCOUNT_PARENT is the parent field in the hierarchy. The field GL_ACCOUNT is the hierarchy field. The field GL_ACCOUNT_CAPTION can be used as the descriptive caption for the hierarchy field.
FILE=CENTGL ,SUFFIX=FOC SEGNAME=ACCOUNTS,SEGTYPE=S01 FIELDNAME=GL_ACCOUNT, ALIAS=GLACCT, FORMAT=A7, TITLE='Ledger,Account', FIELDTYPE=I, $ FIELDNAME=GL_ACCOUNT_PARENT, ALIAS=GLPAR, FORMAT=A7, TITLE=Parent, PROPERTY=PARENT_OF, REFERENCE=GL_ACCOUNT, $ FIELDNAME=GL_ACCOUNT_TYPE, ALIAS=GLTYPE, FORMAT=A1, TITLE=Type,$ FIELDNAME=GL_ROLLUP_OP, ALIAS=GLROLL, FORMAT=A1, TITLE=Op, $ FIELDNAME=GL_ACCOUNT_LEVEL, ALIAS=GLLEVEL, FORMAT=I3, TITLE=Lev, $ FIELDNAME=GL_ACCOUNT_CAPTION, ALIAS=GLCAP, FORMAT=A30, TITLE=Caption, PROPERTY=CAPTION, REFERENCE=GL_ACCOUNT, $ FIELDNAME=SYS_ACCOUNT, ALIAS=ALINE, FORMAT=A6, TITLE='System,Account,Line', MISSING=ON, $
The CENTSYSF data source contains detail-level financial data. This is unconsolidated financial data for a fictional corporation, CenturyCorp. It is designed to be separate from the CENTGL database as if it came from an external accounting system. It uses a different account line system (SYS_ACCOUNT) which can be joined to the SYS_ACCOUNT field in CENTGL. Data uses natural signs (expenses are positive, and revenue are negative).
FILE=CENTSYSF ,SUFFIX=FOC SEGNAME=RAWDATA ,SEGTYPE=S2 FIELDNAME=SYS_ACCOUNT , ,A6 , FIELDTYPE=I, TITLE='System,Account,Line', $ FIELDNAME=PERIOD , ,YYM , FIELDTYPE=I,$ FIELDNAME=NAT_AMOUNT , ,D10.0 , TITLE='Month,Actual', $ FIELDNAME=NAT_BUDGET , ,D10.0 , TITLE='Month,Budget', $ FIELDNAME=NAT_YTDAMT , ,D12.0 , TITLE='YTD,Actual', $ FIELDNAME=NAT_YTDBUD , ,D12.0 , TITLE='YTD,Budget', $
WebFOCUS |