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.
The associated objects refer to the primary association only e.g. Primary Contact, Primary Campaign.
This subject area can answer the following business questions:
What are the top 10 products by revenue during the past quarter/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?
What Pricebook has the most number of Won/Lost Products sold in the last year?
Which are the Top 10 Products with won scheduled revenue and Quantity in the last year?
The following duty roles secure access to this subject area:
Navigator > Sales > Opportunities > Products
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..
The grain is at the Opportunity Line Item level.
None.
Copyright © 2019, 2025, Oracle and/or its affiliates.