BI Content for Sales Analyses (New) Locate this document in the navigation structure

Technical Data

Product Version

SAP NetWeaver 7.0 BI Content Add-On 5 SP01

Area

Sales

Country Relevance

Valid for all countries

 

As of SAP NetWeaver 7.0 BI Content Add-On 5, the following BI Content for sales analyses is available in SAP Customer Relationship Management (SAP CRM). These queries supply Xcelsius Dashboards, which are used to visualize the sales analyses. However, you can also use the queries independently of the Dashboards. You can use the queries to analyze the areas of leads, opportunity pipeline, sales cycle, and sales revenue development.

Query

The following queries use InfoProvider 0CSALMC03:

  • Sales Order (0CSALMC03_Q0006)

The following queries use InfoProvider 0CRM_C04:

  • Opportunity (0CRM_C04_Q0001)

  • Remaining Pipeline Total (0CRM_C04_Q3001)

  • Remaining Pipeline by Deal Size (0CRM_C04_Q3004)

  • Top 10 Deals for Selected Stage (0CRM_C04_Q3005)

  • Expected Sales Volume (Weighted) by Stage (0CRM_C04_Q3010)

  • Expected Sales Volume (Weighted) by Closing Month (0CRM_C04_Q3011)

  • Aging By Stage (0CRM_C04_Q3012_1)

  • Pipeline Health Scorecard (0CRM_C04_Q3013)

  • Revenue Generation by Quarter (0CRM_C04_Q3020)

  • New Opportunities by Quarter (0CRM_C04_Q3021)

  • New Opportunities by Source (0CRM_C04_Q3022)

  • Marketing Contribution by Quarter (0CRM_C04_Q3023)

  • Average Sales Cycle (0CRM_C04_Q3030)

  • Lost Revenue by Quarter (0CRM_C04_Q3031)

  • Lost Revenue by Sales Stage (0CRM_C04_Q3032)

  • Loss Reason (0CRM_C04_Q3033)

  • Industry and Sales Org. List (0CRM_C04_Q3034)

  • Win Rate Versus Lost Revenue by Quarter (0CRM_C04_Q3040)

  • Sales Cycle Duration (0CRM_C04_Q3050)

  • Win Rate (0CRM_C04_Q3051)

  • Employee Responsible List (0CRM_C04_Q3052)

  • Top 10 Opportunities (0CRM_C04_Q3066)

The following queries use MultiProvider 0CRM_CNT2:

  • Top 10 Contracts (0CRM_CNT2_Q3031)

The following queries use MultiProvider 0CSAL_C05:

  • Employee List (0CRM_CSAL05_Q3010)

  • Quote Success Rate (0CRM_CSAL05_Q3011)

  • Expiring Quotes Not Accepted (0CRM_CSAL05_Q3012)

  • Revenue Stream per Quarter (0CRM_CSAL05_Q3013)

  • Top Quotes (0CRM_CSAL05_Q3014)

  • Top 10 Quotations (0CSAL_C05_Q3031)

  • Top 10 Quotations (0CSAL_C05_Q3031)

The following queries use InfoProvider 0CSALMC01:

  • Top 10 Customers by Revenue This Year (0CRM_CSALMC01_Q3011)

The following queries use InfoProvider 0CRM_OPPH:

  • Top 10 Deals (0CRM_OPPH_Q3011)

The following queries use InfoProvider 0CSAL_C03:

  • Pipeline Health Scorecard from Sales Order (0CSAL_C03_Q3014)

The following queries use MultiProvider 0CSALMC02:

  • Employee List for Sales Manager (0CSALMC02_Q3000)

  • Sales Actual and Opportunity (0CSALMC02_Q3001)

  • Sales Revenue Progress Current Quarter (0CSALMC02_Q3002)

  • Sales Actual and Opportunity Current Quarter (0CSALMC02_Q3011)

The following queries use MultiProvider 0CSALMP05:

  • Average Deal Size (0CSALMP05_Q3000)

  • Top 10 Customers (0CSALMP05_Q3031)

The following queries use MultiProvider 0MKTGMP02:

  • Top 10 Leads (0MKTGMP02_Q3031)

The following queries use InfoProvider 0CRM_C11:

  • Top 5 Competitors (0CRM_C11_Q0001)

  • Current Pipeline by Sales Stage (0CRM_C11_Q0002)

  • Recent 5 Opportunities (0CRM_C11_Q0003)

  • Win Rate Versus Lost Revenue by Quarter (0CRM_C11_Q0004)

  • Loss Analysis (0CRM_C11_Q0005)

  • Top 5 Sales Representatives (0CRM_C11_Q0006)

  • Recent 5 Open Opportunities (0CRM_C11_Q0007)

More Information

For more information about these queries, see SAP Help Portal at   http://help.sap.com   SAP NetWeaver 7.02 BI Content Add-On 5, SP 00   BI Content   Customer Relationship Management   CRM Analytics   Sales Analyses  .

For more information about visualizing reports in SAP CRM using Xcelsius Dashboards, see SAP Help Portal at   http://help.sap.com   SAP NetWeaver   BI Content   BI Content 705   Extension BI Content 705  .

.