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.
| Attribute | Description (where applicable) |
| ID | ID |
| PARTITION_BY_MONTH | Partition Column to partition the data by month for incremental loading |
| PARTITION_BY_DATE | Partition Column to partition the data by date for incremental loading |
| ROWVERSION | Column to be used as the "Detect Changes" column for incremental loading |
| Model Name |
| General Ledger |
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 |
| IL ANALYSIS | FACT_IL_ANALYSIS_PQ_BI | FACT_INTERNAL_LEDGER_ANALYSIS | On Line |