Opportunity Item

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
tdsmi113	Items by Opportunity

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Company	tdsmi113_compnr
Opportunity	tdsmi113.opty
Position	tdsmi113.pono
Select Item	tdsmi113.seli
Select Item Filter	tdsmi113.seli
Select Item Sort	tdsmi113.seli
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields