Symptom
You want to know why the Sales Quote Funnel data source has two Key Figures with the same name - Net Value.
Reproducing the Issue
- Go to Business Analytics Workcenter.
- Go to Design Data Sources view.
- Search for the Data Source - Sales Quote Funnel
- Click on Preview.
- Find two copies of the same Key Figure - Net Value.
Cause
Sales Quote Funnel data source is a Combined Data Source of Sales Quote Item data source and Sales Order Item data source. Hence the view element names have been repeated.
Resolution
The two Net Value Key Figures correspond to Sales Quote and subsequently the Sales Order values. For those Sales Quotes where a Sales Order is not created, one of the Net Value Key Figures shows 0. The Net Value Key Figures are calculated by summing Total Item Net Value and Freight.
You can verify the values by navigating to the respective Sales Quotes and Sales orders and then by navigating to the Pricing tab. There you can refer to the Total pricing section under which the summation of the Total Item Net Value and Freight gives you the Net Value.
To avoid confusion, you can also re-name the Net value Key Figures as desired by making copies of the existing Net Value Key Figure. This functionality is available in Business Analytics work center->Design Key Figures->New Key Figure.
Keywords
KBA , AP-SLO-SO , Sales Order , How To