This subject area can be used to analyze or report on activities such as Tasks and Events created for an Opportunity (associated to an Opportunity) in the system.
This subject area can answer the following business questions:
What is the average number of activities before an opportunity is closed/won/lost?
On average how many Activities (Events/Tasks) are needed before an opportunity is won?
What is activity ratio for won and lost opportunities? Are there any trends?
Which are the opportunities that have had no activity in the last week?
The following duty roles secure access to this subject area:
Navigator > Sales > Opportunities > Tasks
This subject area supports historic analysis/time-based reporting of Opportunity Activity based on Activity Created Date, Activity Start Date, Activity End Date, Activity Date, Opportunity Created Date, and Opportunity Closed Date.
Time dimension is linked to There are multiple role playing time dimensions achored to the following dates: 1. Activity Created Date 2. Activity Start Date 3. Activity End Date 4. Activity Date 5. Opportunity Created Date 6. Opportunity Closed Date..
The grain is at the Opportunity Activity level.
None.
Copyright © 2019, 2025, Oracle and/or its affiliates.