Opportunity

The Opportunity fact includes measures based on Opportunities (tdsmi110).

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:

Opportunity star schema