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.
SAP S/4HANA CLOUD 1702 / 767
Reproducing the Issue
- Create a Custom Analytical Query
- Set the dimension Format to Text
- Run the query
This is expected behavior.
- 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
dimension key sort fiori, custom analytical query sort , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem