Model: Group Reporting - Specifications for Dimension Table: REPORTING ENTITY

On this page you will find the specifications regarding the Model: Group Reporting and Dimension Table: REPORTING ENTITY.

This model dimension represents the Reporting Entity and is based on the IFS Cloud dimension DIM_REPORTING_ENTITY. All models that refers to this dimension will have the attributes and hierarchies as described below.

Natural parent is master company, i.e. each master company structure has its own set of Reporting Entity values.

Attributes

Attribute Description (where applicable)
Actual Ledger Type Actual Ledger Type
Budget Ledger ID Budget Ledger ID
Budget Ledger Type Budget Ledger Type
Company Code Company Code
Ledger ID Ledger ID
Rep Currency Base Rep Currency Base
Reporting Company Code Represents the CODE of the Reporting Company connected to the Reporting Entity
Reporting Entity Reporting Entity
Reporting Entity Code Reporting Entity Code
Reporting Entity Code Desc Reporting Entity Code and Description
Reporting Entity Currency Code Reporting Entity Currency Code
Reporting Entity Desc Reporting Entity Description
Reporting Entity Type Reporting Entity Type

USED BY MODEL(S)

Model Name
Group Consolidation
Group Reporting

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
REPORTING ENTITY DIM_REPORTING_ENTITY_GR_TM DIM_REPORTING_ENTITY_GR_BI DIM_REPORTING_ENTITY On Line