On this page you will find the specifications regarding the Model: Group Reporting and Dimension Table: STRUCTURE HIEARCHY.
Represents the structure as a hiearchy. Can be used for Structure based analyis.
| Attribute | Description (where applicable) |
| Year Period | Accounting Year and Period |
| Description | Description |
| Sort Order Latest | Last available sort order applied on all periods |
| Structure ID | Structure ID |
| Child ID | Child ID |
| Child Long ID | Built as Company + Structure + Year Period + Parent ID + Child ID |
| Hierarchy | Level |
| Structure Alphabetical Order | |
| Structure ID | |
| AlphaCONL01 | |
| AlphaCONL02 | |
| AlphaCONL03 | |
| AlphaCONL04 | |
| AlphaCONL05 | |
| AlphaCONL06 | |
| AlphaCONL07 | |
| AlphaCONL08 | |
| AlphaCONL09 | |
| AlphaCONL10 | |
| Structure By Sort Order | |
| Structure ID | |
| CONL01 | |
| CONL02 | |
| CONL03 | |
| CONL04 | |
| CONL05 | |
| CONL06 | |
| CONL07 | |
| CONL08 | |
| CONL09 | |
| CONL10 |
| Model Name |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| STRUCTURE HIEARCHY | DIM_CONSOL_STRUCT_BY_PER_PQ_BI | DIM_CONSOL_STRUCT_BY_PER_PQ | On Line |