Symptom
You are using the key figure Days in Sales Phase (technical ID: CODOPPU_CKF_04) in a custom or standard report and the values are not fully clear to you.
Environment
SAP Hybris Cloud for Customer
Reproducing the Issue
-
Go to the Business Analytics Workcenter.
- Go to the Design Reports View.
- Show all and search for report Opportunity Analysis (technical ID CODOPPU_Q0018) or any other report based on data source Opportunity Header and Item (technical ID CODOPPU).
- Run the report with your selection.
- The key figure Days in Sales Phase shows a value that is not clear to you.
Cause
The key figure Days in Sales Phase is based on another key figure Phase Sales Date. When you open the key figure documentation, you will find the formula.
Formula: Days in Sales Phase = Today - Phase Start Time.
When you add key figure Phase Start Time to the report, you will notice that it displays the last date available, so it is the maximum of all dates.
Resolution
This is the expected system behavior and it works as designed.
To avoid any confusion, we would recommend to always use the key figure Days in Sales Phase with an additional characteristic (Opportunity for example).
Keywords
Days in Sales Phase, key Figure, Opportunity, Sales Phase, Sales Date, report, result , KBA , opportunity header and item , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To