Cloud Documentation
Advanced Search


Oracle Sales Cloud Reporting and Analytics for Business Users
Close Window

Table of Contents

Show All | Collapse

31 Who is the Primary Sales Resource Associated With Each Opportunity For This Customer?

This tutorial shows you how to determine who is the primary sales resource with each opportunity for a selected customer. A report is based on an analysis that defines the information that you want to see in the report. So to create a new report, you first need to create an analysis.

In this tutorial you need to determine who the primary sales resource is for a customer and the associated opportunity. Each customer may have one or more sales resources and one or more opportunities. You use the Primary Sales Resource Associated With Each Opportunity For This Customer report to evaluate and review a specific targeted opportunity.

How to determine who is the primary sales resource associated with each opportunity for this customer

To create the Primary Sales Resource Associated With Each Opportunity For This Customer report:

  1. From the Navigator menu, select Reports and Analytics.

    This image is described in surrounding text.

    The Reports and Analytics page is displayed.

  2. In the Contents pane, click Browse Catalog.

    This image is described in surrounding text.
  3. In the Oracle BI Catalog page, click New, and then click Analysis.

    This image is described in surrounding text.
  4. In the Select Subject Area list, select Sales - CRM Pipeline.

    This image is described in surrounding text.
  5. In the Subject Areas pane, expand the Opportunity folder, and then double-click Opportunity Name to add the column to the Selected Columns pane.

    This image is described in surrounding text.
  6. Similarly, add the following columns to the Selected Columns pane:

    • From the Opportunity folder: Owner First Name

    • From the Opportunity folder: Owner Last Name

    • From the Customer folder: Customer Name

    This image is described in surrounding text.
  7. In the Filters pane, click the Create a filter for the current Subject Area button, and then select Customer Name.

    This image is described in surorunding text.
  8. In the New Filter dialog, perform the following steps:

    1. Select is equal to/is in from the Operator list.

    2. In the Value field, enter Agile Solutions. (Note that you can also select one or more values from the Value list, or you can search for a value.) This image is described in surrounding text.

    3. Click OK. The filter is added to the Filters pane.

      This image is described in surrounding text.
  9. Click Results. Your analysis is displayed.

  10. Save the analysis as follows:

    1. Click Save.

      This image described in surrounding text.
    2. The Save As dialog is displayed. In the Name field, enter Primary Sales Resource Associated With Each Opportunity For This Customer.

    3. In the Folders list, select the folder in which you want to save the analysis.

      The folder in which you save the analysis controls whether the analysis is available only for your personal use or available to other users.

      If you save the analysis in My Folders, then it is available only for your personal use. If you save the analysis in Shared Folders\Custom, then it is available to all users who can access Shared Folders\Custom.

      This image is described in surrounding text.
    4. Click OK.

      The final report is saved in the specified folder. You can now navigate to the analysis.

How do I read the Primary Sales Resource Associated With Each Opportunity For This Customer report?

This report contains the following metrics:

  • Opportunity Name — The name of the opportunity associated with the primary resource and the customer.

  • Owner First Name — The first name of the primary sales representative (resource) who owns this opportunity.

  • Owner Last Name — The last name of the primary sales representative (resource) who owns this opportunity.

  • Customer Name — The name of the sales representative's customer.

    The following image shows an example of the Primary Sales Resource Associated With Each Opportunity For This Customer report.

    This image is described in surrounding text.