Model: Revenue Recognition - Specifications for Dimension Table: FACT FORECAST AMOUNTS

On this page you will find the specifications regarding the Model: Revenue Recognition and Dimension Table: FACT FORECAST AMOUNTS.

Attributes

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

USED BY MODEL(S)

Model Name
Revenue Recognition

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
FACT FORECAST AMOUNTS FACT_REV_REC_FORC_LINE_ALL_BI FACT_REV_REC_FORC_LINE_ALL On Line