Attributes

The mapping guide describes the available attributes for each dimension.

This table shows the dimensions targeted by the opportunity item fact:

Dimension	Type	Note
Company	Conformed	tdsmi110.compnr
External Sales Rep	Conformed	tdsmi110.crep Assigned To
Financial Company	Conformed	Read from Sales Office, equal to Company if Sales Office is empty
Item	Conformed	tdsmi113.item
Opportunity	Domain specific	tdsmi110.opty
Opportunity Detail	Domain specific	Junk dimension
Opportunity Item	Domain specific	tdsmi113.opty Opportunity tdsmi113.pono Position
PCS Project	Conformed	tdsmi113.cprj
Project	Conformed	tdsmi113.cprj
Sales Office	Conformed	tdsmi110.cofc
Sold-to Address	Conformed	tdsmi110.ccor Postal Address
Sold-to BP	Conformed	tdsmi110.bpid
Time	Birst	(1) Close Date
Transaction Currency	Conformed	tdsmi110.ccur Currency
Transaction Unit	Conformed	tdsmi113.cuqs Order Unit

(1) Measures are available to analyze by Close Date.

Close Date = Actual Close Date, Expected Close Date if there is no Actual Close Date, Date of First Contact if there is no Expected Close Date.

Individual dates are available in the Opportunity dimension.