In our last blog Early Warning Mechanism for Standalone Selling Price Compliance Risks | SAP Blogs, we introduced an automated detection rule, Standalone Selling Price Compliance Risks, which is integrated with SAP Financial Compliance Management. You can use this to detect non-compliant standalone selling prices for performance obligation names. The performance obligation name is used to distinguish between different groups of performance obligations, for example, that represent a product.
How was your experience? Was it easy to understand the overall process, in particular, how the non-compliant standalone selling price is derived? You may wonder if there are ways to visualize how the standalone selling price is tested by comparing the transaction prices that were charged alongside the reasonable SSP range for variable time periods.
To assist further, Revenue Accounting and Reporting provides these two additional CDS queries for the SSP Test explanation and visualization from OP2022 onwards. If you would like to use these two queries in OP2021, please install SAP Note 3127114 – Standalone Selling Price Test for SAP Analytics Cloud.
You can build analytic applications that refer to these 2 CDS queries, such as SAP Analytics Cloud stories.
This blog post provides a step-by-step guide for the process that allows you to explore an end-to-end scenario of consuming CDS views in SAP Analytics Cloud using a live connection to an on-premise system. The augmented analytics capabilities of SAP Analytics Cloud enable you to dig deeper and derive comprehensive insights from the available data.
1. Copy SAP CDS Queries and Release Your Custom CDS Queries
Initially, you should release the CDS queries above to make them available for the SAP Analytics Cloud consumer. How to release them? You can copy the queries directly and perform additional adjustments according to your desired purpose and set the API state as seen below. This can be done by right clicking the view and selecting the API State from the drop-down menu as following:
Select the “Add Use System-Internally(Contract C1)” option:
Fig 1: Release CDS Queries
Set visibility to “Use in Key User Apps”:
Fig 2: Set Visibility
2. Build A Live Connection
If you require real time analysis without the need to store data, you can build a live connection between your SAP S/4HANA system and the standalone SAP Analytics Cloud. Using a live connection, SAP Analytics Cloud provides the business logic and builds the queries required to see your data in your browser. Your browser will then send those queries through a direct live connection to the on-premise data source. The results of those queries are returned to your browser, where visualizations are rendered. A live connection to on-premise data source can be created in the menu below. Please refer to Introducing Direct Live HANA Connections in SAP Analytics Cloud | SAP Blogs for more information.
Fig 3: Build Up Live Connection
3. Create Model
The next step is model creation. There are multiple ways to create models in SAP Analytics Cloud. You can start from scratch, import data from a data source or a dataset, or use a live data connection. For our scenario, we created live data models based on the pre-delivered CDS views. Here, two data models are created. You can select the Live Data Model option as seen here:
Fig 4: Create Live Data Model
The connections window will then be displayed. Select the live connection that is pre-defined in step 2and then select the connection type of SAP BW. Once you select the connection name, it displays the authentication screen and once authenticated, you can select the data source as seen below. The data source is created based on step 1.
Fig 5: Select Data Source
The two analytic queries can now be consumed in the model as shown below. The models can subsequently be consumed within a story.
Fig 6: Standalone Selling Price Test Model
Fig 7: Standalone Selling Price Test Details Model
4. Story Building in SAP Analytics Cloud
Finally, where can you explore and visualize your data for reporting, planning, and analysis? The SAP Analytics Cloud story presents data in a variety of formats such as charts, tables, and graphics. You can create multiple pages that are set up as responsive, canvas, or grid. For example, a column chart can be built to present the SSP Compliance% per Calendar Year Quarter:
Fig 8: Column Chart in SAP Analytics Cloud
Here is a sample SAP Analytics Cloud story that is based on these 2 pre-delivered CDS queries. In the sample story, you can get an overview of the SSP Test and details about the performance obligations (POBs) related to the SSP Test.
To start the story, you need to define the variables for your business purpose using Prompts. For example, in the sample story, you would like to analyze the SSP for POBs with POB Names that are LICENSE USER and only focus on the POBs created between Jun 30,2020 to Sep 30 2021. To obtain SSP Compliance, you should identify the corridor and threshold too. Here, you would set the corridor to 15% (Corridor = Interval as % * Interval Scope as %) and the threshold as 80%. The business selections are entered as follows:
Fig 9: Variables for SSP Test
You will see two pages are created in the story:
1: SSP Compliance Overview page: You can review the overall status of the SSP for different calendar year quarters. This page helps answer the following questions:
What is the SSP Compliance% per each calendar year quarter?
What is the threshold for non-compliant definition?
How many non-compliant POBs per calendar year quarter?
What is the Maximum Interval Amount, Minimum Interval Amount, Standard SSP and Corridor that are used for SSP Compliance% calculation?
How many POBs are there per each Interval Amount Range? The Interval Amount Range is the interval calculated based on Standard SSP and interval as %.
Fig 10: SSP Compliance Overview
Of course, you are free to select a dedicated calendar year quarter for analysis using the input control on the left-side panel.
2. POB Detail page: You can review all detailed information about POBs to understand how the SSP Compliance% is calculated and carry out further business adjustments. This page helps answer the following questions:
What is the Unit Contractual Price and the Unit Standard Selling Price for each POB?
When was the POB created?
What's the Interval Amount Range for each POB? The Interval Amount Range is the interval in which the Unit Contractual Price falls.
Fig 11: POB Details
You can build your story by referring to the sample. If the model does not sufficiently meet your requirements, you can also create additional measures in the SAP Analytics Cloud. For example, you can create a calculated measure as follows:
Fig 12: Create Calculation Measures in SAP Analytics Cloud
Stories can be made more appealing by adding comments, images, smart insights, and much more.