SAP Knowledge Base Article - Public

3783193 - Order to Cash dashboard uses calendar year instead of fiscal year – SAP S/4HANA Cloud Public Edition

Symptom

Data follows calendar year instead of fiscal year in the selection/filter options of the Order to Cash Dashboard.

Environment

  • Product: SAP S/4HANA Cloud Public Edition
  • Analytics (Public Cloud)

Reproducing the Issue

  1. Review the date-related selection options and observe that the data follows calendar year rather than fiscal year.

Cause

The delivered Order to Cash Dashboard is designed to use calendar year; fiscal year selection is not available in the standard content.

Resolution

  • If there is a requirement to have a field which allows the user to see when the Sales Order header/item was created, the field 'CreationDate' can be used. 
  • This means using the CDS View - I_SALESORDER/CDS View - I_SALESORDERITEM to look up the field "CreationDate" to substitute for the "Fiscal Year" field, which will allow a means to determine when the Sales Order header/item was created.

Keywords

order to cash dashboard, profit center filter, fiscal year, calendar year, filter not available, analytics public cloud, custom cds view, custom analytical query, manage kpis and reports, sales analytics, o2c, reporting filters, s/4hana cloud analytics, dashboard limitation, extensibility , KBA , SD-ANA-2CL , Analytics (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions