Purchase Contract Line

The Purchase Contract Line fact includes measures based on Purchase Contract Line (tdpur301).

Transformation of extracted data:

Contract and time dimension

Some purchase contract line measures allow aggregation against the time dimension. Two fact tables are populated: Purchase Contract Line and Purchase Contract Line Analysis. Both tables have the same dimensions, but Purchase Contract Line Analysis additionally targets the time dimension. The Purchase Contract Line Analysis fact table stores measures on week level and allows aggregation to Month, Quarter and Year level. A contract has an effective and expiry date; a record is created for each week between these dates. Measures are equally divided across the weeks of the contract.

Deleted lines

Deleted purchase contract lines are stored in the Purchase Contract Line fact tables. Terminated purchase contract lines that are deleted remain available for analysis. However, purchase contract lines with status Free that are deleted, are hidden in the fact tables and are not available for analysis.

Total lines and corporate purchase contracts

Purchase contract lines can be of the contract line type Total, Detail, or Contract Line. For corporate purchase contracts, the total lines are an aggregate of the detail lines. Therefore, total lines for corporate purchase contracts are not stored in the fact table to avoid over-counting.

Note: For non-corporate purchase contracts, the total lines are complementary to the detail lines and are stored in the fact table

Change requests

Change requests are not stored in the fact table.

Purchase contracts without lines

The Purchase Contracts table tdpur300 is used for targeting the Carrier/LSP dimension, but measures are based on the purchase contract line table tdpur301. This means that purchase contracts without lines are not available in the fact tables.

This diagram shows the star schema: