SF - Opportunity Line Item
Description
This subject area provides information on all the Opportunity Line Items created in the application, and the associated Account, Opportunity Owner, Primary Campaign, Contact, Product, and Pricebook._x000D_
The associated objects refer to the primary association only e.g. Primary Contact, Primary Campaign.
Business Questions
This subject area can answer the following business questions:
-
What Pricebook has the most number of Won/Lost Products sold in the last year?
-
What are the top 10 products by revenue during the past quarter or year?
-
What is the Quantity of Products won in the last quarter vs current quarter?
-
What is the total schedule amount and quantity for the next quarter?
-
Which are the Top 10 Products with won scheduled revenue and Quantity in the last year?
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Navigator > Sales > Opportunities > Products
Time Reporting
This subject area supports historic analysis/time-based reporting of Opportunity Line Items based on the Opportunity Close Date, Opportunity Created Date, Line Item Created Date, Line Item Product Date, Line Item Schedule Date.
Time dimension is linked to There are multiple role playing time dimensions achored to the following dates: 1. Opportunity Close Date 2.Opportunity Created Date 3. Line Item Created Date 4. Line Item Product Date 5. Line Item Schedule Date.
Transactional Grain
This subject area returns data at the grain of the Opportunity Line Item level.
Special Considerations
None.