Model: General Ledger - Specifications for Dimension Table: BUSINESS PLANNING

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

Represents the business planning specific analysis source.

Measures derived from the base amounts will be available in BUSINESS PLANNING MEASURES.

Attributes

Attribute Description (where applicable)
ID ID
PARTITION_BY_MONTH Partition Column to partition the data by month for incremental loading
ROWVERSION Column to be used as the "Detect Changes" column for incremental loading
PARTITION_BY_DATE Partition Column to partition the data by date for incremental loading

USED BY MODEL(S)

Model Name
General Ledger

Data source Information

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
BUSINESS PLANNING FACT_PLAN_TRANS_VALID_PQ_BI FACT_PLAN_TRANS_VALID_PQ On Line