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
- 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
SAP Knowledge Base Article - Public