SAP Knowledge Base Article - Public

2473921 - Sorting of financial year in incorrect when using custom analytical query in Fiori Launchpad Cloud

Symptom

When using a Custom Analyitcal Query to sort a financial year, the result is incorrect. It does not show the month from July as period 1 to May as period 11.

Environment

SAP S/4HANA CLOUD 1702 / 767

Reproducing the Issue

  1. Create a Custom Analytical Query
  2. Set the dimension Format to Text
  3. Run the query

Cause

This is expected behavior.

Resolution

  • If the query is looking to show the key, then set the dimension format to "Key"
  • If the query is looking to show the text and the key, then set the dimension format to "Key and Text" or "Text and Key" any one of these options that work for you

Keywords

dimension key sort fiori, custom analytical query sort , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

SAP S/4HANA Cloud 1702