Model: General Ledger - Specifications for Dimension Table: IL ANALYSIS

On this page you will find the specifications regarding the Model: General Ledger and Dimension Table: IL ANALYSIS.

Represents the Internal Ledger specific analysis source.

Measures derived from the base amounts will be available in IL ANALYSIS MEASURES.

Attributes

AttributeDescription (where applicable)
idID

USED BY MODEL(S)

Model Name
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 TableDW Source view (SQL Server)BI Access ViewReferenced Information SourceRecommended Access Type
IL ANALYSISFACT_INTERNAL_LEDGER_ANALYSIS_TMFACT_IL_ANALYSIS_PQ_BIFACT_INTERNAL_LEDGER_ANALYSISData Mart