Opportunity

When a record is deleted in LN, the deleted field is set in the dimension. Records are not removed from the dimension. An open opportunity (with status Preliminary, In Process or Dead) that is deleted in LN, will be hidden in the degenerate dimension in Birst. Closed opportunities that are deleted (with status Canceled, Lost or Won) will not be hidden and remain available for analysis.

This table shows the table from which fields are retrieved for the dimension:

Table	Description
tdsmi110	Opportunities

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Actual Close Date	tdsmi110.acdt
Company	tdsmi110_compnr
Created by	tdsmi110.user
Creation Date	tdsmi110.crdt
Date of First Contact	tdsmi110.fcdt
Expected Close Date	tdsmi110.dcdt
Last Transaction Date	tdsmi110.ltdt
Opportunity	tdsmi110.opty
Opportunity Desc	tdsmi110.dsca
Opportunity ID Desc	tdsmi110.opty + tdsmi110.dsca
Probability Percentage	tdsmi110.sccp
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields