Using Reports and Analytics

Creating Custom Reports

Objective

After completing this lesson, you will be able to customize a new report and explain how to view and analyze the data.

Custom Reports in SAP Sales and Service Cloud

To effectively manage a sales organization, leaders need clear, accurate visibility into their forecasting and pipeline. While standard reports provide a robust foundation, businesses often have unique requirements that necessitate custom reporting solutions. In this lesson, you will explore how to translate business requirements into custom reports using the reporting wizard.

Business Case: SAP Premier

Review the requirements for SAP Premier. During an initial discovery meeting, the company identified several critical visibility issues that impact their strategic decision-making.

Current Challenges

The sales leadership at SAP Premier currently struggles with poor and inaccurate visibility into their forecasting and sales pipeline. Without a clear view of where opportunities stand, it is difficult to allocate resources or predict quarterly revenue accurately. Specifically, they need to report on the exact phase of the sales cycle for every active opportunity in the system.

Reporting Goals

To address these issues, SAP Premier has defined the following objectives for their analytics implementation:

  • Standardization: Leverage out-of-the-box standard SAP Sales and Service Cloud reports and dashboards wherever possible to maintain consistency.

  • Phase Analysis: Implement standard reports specifically for opportunity analysis categorized by sales phase.

  • Extensibility: Utilize custom extension fields as reporting data to capture unique business metrics not found in the standard configuration.

Custom Report Wizard

In SAP Sales and Service Cloud, the reporting wizard is the primary tool for creating custom analytics. It guides you through a step-by-step process to define the data source, select the necessary characteristics and key figures, and set up the initial layout.

When building a custom report for sales phases, you must first identify the correct Data Source. Data sources are the building blocks of reports, containing the fields (characteristics) and measurable values (key figures) required for analysis. For this business case, you would typically look for data sources related to "Opportunities" or "Sales Cycle Phases."

Once the data source is selected, the wizard allows you to:

  1. Select Key Figures: Choose the metrics you want to measure, such as the number of opportunities or the expected value.

  2. Select Characteristics: Choose the attributes used to filter and segment the data, such as Sales Phase, Account, or Owner. This is also where you include any extension fields identified in the business case.

  3. Define Variables: Set up filters that allow users to limit the data shown (for example, filtering by a specific Sales Organization or Date Range).

Create a Custom Report

In the following simulation, you'll learn to use the wizard to create a custom report based on Sales Cycle Phases.

Summary

  • Custom reports bridge the gap between standard analytics and unique business requirements like those at SAP Premier.

  • Accurate visibility into the sales pipeline and forecasting is essential for identifying bottlenecks in the sales cycle.

  • The Reporting Wizard provides a structured workflow to select data sources, key figures, and characteristics.

  • Extension fields can be added to custom reports to ensure that specialized business data is available for analysis.