Model: Group Reporting - Specifications for Dimension Table: STRUCTURE HIEARCHY
Attributes
| Attribute |
Description (where applicable) |
| AlphaCONL01 | Structure Level 1 - Alphabetical sort order |
| AlphaCONL02 | Structure Level 2 - Alphabetical sort order |
| AlphaCONL03 | Structure Level 3 - Alphabetical sort order |
| AlphaCONL04 | Structure Level 4 - Alphabetical sort order |
| AlphaCONL05 | Structure Level 5 - Alphabetical sort order |
| AlphaCONL06 | Structure Level 6 - Alphabetical sort order |
| AlphaCONL07 | Structure Level 7 - Alphabetical sort order |
| AlphaCONL08 | Structure Level 8 - Alphabetical sort order |
| AlphaCONL09 | Structure Level 9 - Alphabetical sort order |
| AlphaCONL10 | Structure Level 10 - Alphabetical sort order |
| Child ID | Child ID |
| Description | Description |
| Node Type | Node Type |
| Sort Order Latest | Last available sort order applied on all periods |
| Structure ID | Structure ID |
| Year Period | Accounting Year and Period |
| 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 |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| STRUCTURE HIEARCHY | DIM_CONSOL_STRUCTURE_BY_PER_GC_TM | DIM_CONSOL_STRUCTURE_BY_PER_GC_BI | CONSOL_STRUCT_BIA | On Line |