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
- Create a Custom Analytical Query
- Set the dimension Format to Text
- 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