Opportunity Item

The Opportunity Item fact includes measures based on Opportunities (tdsmi110) and Opportunity Items (tdsmi113).

Transformation of extracted data:

Deleted lines

Deleted opportunities are stored in the Opportunity fact table. These facts are hidden for open opportunities (status Preliminary, In Process or Dead). Closed opportunities that are deleted in LN (status Canceled, Lost or Won) will not be hidden and remain available for analysis.

This diagram shows the star schema: