Model: General Ledger - Specifications for Dimension Table: COUNTERPART STRUCTURE 1

On this page you will find the specifications regarding the Model: General Ledger and Dimension Table: COUNTERPART STRUCTURE 1.

Contains the Counterpart structure no 1.

Attributes

Attribute Description (where applicable)
Counterpart Counterpart code, connects to the Fact tables
Description The description, displayed text in the counterpart structure
Structure Id The Id for the structure seleted (by configuration) to be shown in this counterpart structure
tmp Item above description, values on all rows including top level

Hierarchies

Hierarchy Level
Counterpart Structure 1
CPSL01
CPSL02
CPSL03
CPSL04
CPSL05
CPSL06
CPSL07
CPSL08
CPSL09
CPSL10

USED BY MODEL(S)

Model Name
Cash Planning
General Ledger

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
COUNTERPART STRUCTURE 1 DIM_GL_COUNT_STRUCT_1_TM DIM_GL_COUNT_STRUCT_1_BI DIM_GL_COUNT_STRUCT_1 On Line