Measures
This table shows the opportunity item measures:
Measure | Mapping | Note |
---|---|---|
Opportunity Item Canceled Amount | Opportunity Item Net Amount for status Canceled, else 0.0 | |
Opportunity Item Canceled Amount Ratio | Opportunity Item Canceled Amount / Opportunity Item Net Amount | |
Opportunity Item Canceled Count | 1 for status Canceled, else 0 | |
Opportunity Item Canceled Count Ratio | Opportunity Item Canceled Count / Opportunity Item Count | |
Opportunity Item Closed Amount | Opportunity Item Net Amount for status Canceled or Lost or Won, else 0.0 | |
Opportunity Item Closed Amount Ratio | Opportunity Item Closed Amount / Opportunity Item Net Amount | |
Opportunity Item Closed Count | 1 for status Canceled, Lost or Won, else 0 | |
Opportunity Item Closed Count Ratio | Opportunity Item Closed Count / Opportunity Item Count | |
Opportunity Item Count | Always 1 but 0 for null records Note: Opportunities without items only appear in the Opportunity fact
table
|
|
Opportunity Item Customer Count Distinct | Distinct count of Sold-to BPs | |
Opportunity Item Deal Size | Opportunity Item Net Amount / Opportunity Item Count | |
Opportunity Item Discount Amount | Opportunity Item Gross Amount – Opportunity Item Net Amount | |
Opportunity Item Discount Amount Ratio | Opportunity Item Discount Amount / Opportunity Item Gross Amount | |
Opportunity Item Duration | End Date - Date of First Contact | |
Opportunity Item External Sales Rep Count Distinct | Distinct count of Sales Reps | |
Opportunity Item Forecast Cancel Amount | Opportunity Item Canceled Amount Ratio * Opportunity Item Open Amount | (1) |
Opportunity Item Forecast Cancel Count | Opportunity Item Canceled Count Ratio * Opportunity Item Open Count | (1) |
Opportunity Item Forecast Lose Amount | Opportunity Item Lost Amount Ratio * Opportunity Item Open Amount | (1) |
Opportunity Item Forecast Lose Count | Opportunity Item Lost Count Ratio * Opportunity Item Open Count | (1) |
Opportunity Item Forecast Win Amount | Opportunity Item Won Amount Ratio * Opportunity Item Open Amount | (1) |
Opportunity Item Forecast Win Count | Opportunity Item Won Count Ratio * Opportunity Item Open Count | (1) |
Opportunity Item Gross Amount | Opportunity Item Ordered Quantity * Price (tdpcg100.pric) | (2) |
Opportunity Item Gross Price | Opportunity Item Gross Amount / Opportunity Item Ordered Quantity | |
Opportunity Item Item Count Distinct | Distinct count of Items | |
Opportunity Item Lost Amount | Opportunity Item Net Amount for status Lost, else 0.0 | |
Opportunity Item Lost Amount | Opportunity Item Net Amount for status Lost else 0.0 | |
Opportunity Item Lost Amount Ratio | Opportunity Item Lost Amount / Opportunity Item Net Amount | |
Opportunity Item Lost Count | 1 for status Lost, else 0 | |
Opportunity Item Lost Count Ratio | Opportunity Item Lost Count / Opportunity Item Count | |
Opportunity Item Net Amount | tdsmi113.amta | |
Opportunity Item Net Amount Ratio | Opportunity Item Net Amount / Opportunity Item Gross Amount | |
Opportunity Item Net Price | Opportunity Item Net Amount / Opportunity Item Ordered Quantity | |
Opportunity Item Open Amount | Opportunity Item Net Amount for status Preliminary or In Process or Dead, else 0.0 | |
Opportunity Item Open Amount Ratio | Opportunity Item Open Amount / Opportunity Item Net Amount | |
Opportunity Item Open Count | 1 for status Preliminary, In Process or Dead, else 0 | |
Opportunity Item Open Count Ratio | Opportunity Item Open Count / Opportunity Item Count | |
Opportunity Item Open Weighted Revenue | Opportunity Item Weighted Revenue for status Preliminary, In Process or Dead, else 0.0 | |
Opportunity Item Opportunity Count Distinct | Distinct count of Opportunities | |
Opportunity Item Ordered Quantity | tdsmi113.qoor | |
Opportunity Item Revenue | Opportunity Item Net Amount if Select Item (tdsmi113.seli) is true, else 0.0 | |
Opportunity Item Weighted Revenue | Probability Percentage * Opportunity Item Revenue | |
Opportunity Item Won Amount | Opportunity Item Net Amount (tdsmi113.amta) for status Won, else 0.0 | |
Opportunity Item Won Amount Factor | Opportunity Item Net Amount / Opportunity Item Won Amount Won Amount Ratio 20% equals Won Amount Factor 5: you need opportunities with a net amount of 50$ to win opportunities worth 10$. |
|
Opportunity Item Won Amount Ratio | Opportunity Item Won Amount / Opportunity Item Net Amount. | |
Opportunity Item Won Count | 1 for status Won, else 0.0. | |
Opportunity Item Won Count Factor | Opportunity Item Count / Opportunity Item Won Count. Won Count Ratio 20% equals Won Count Factor 5: you need 10 opportunities to win 2. |
|
Opportunity Item Won Count Ratio | Opportunity Item Won Count / Opportunity Item Count. |
- (1) Dimensional expression to get the Won Count Ratio or Won Revenue Ratio of the previous year.
- (2) Uses calculation tdpcg.dll0100.calculate.extended.amount.