3638396 - Dimension Format configuration is not correctly applied to KPI Reports created through Custom Analytical Queries

You created a Custom Analytical Query using the "Custom Analytical Queries (F1572)" application and inside the "Display" tab you have defined a Dimension Format to display only the "Text" from your dimension. However, when creating a Custom KPI Report using the "Manage KPIs and Reports (F2814)" application, the Dimension Format configuration is not getting applied in the preview and the dimension data is displayed as "Text + Key". 

Example: You have the element "Customer" which displays as default the Customer Name and ID (Key) "TestSAPCustomer (00112233)". When you select the Dimension Format "Text", the field is displayed as "TestSAPCustomer" in your Custom Analytical Query preview, but in the KPI Report it is displayed as default. The configuration in the Dimension Format is not getting applied. 

SAP S/4HANA Cloud Public Edition 

1. Go to Custom Analytical Queries app and click on "Edit"
2. Go to "Display" tab 
3. Configure the "Dimension Format" for your dimension element 
4. Publish the Query 
5. Preview the Query and check that the data is displayed as expected: Only the text
6. Search for your KPI Report or create a new one using "Manage KPIs and Reports" app 
7. Check the element and the data is displayed as "Text + Key"

There is a new application named "Custom Analytical Queries and Services (F1572A)" which is designed for modelling analytical queries within a CDS data model and improve on the previous version of CDS Analytical Queries.

The goal is to provide a clear separation between the general data model and the service-specific presentation, leading to cleaner code and easier maintenance.

While in the old Custom Analytical Queries app the "Dimension Format" is not applied to KPIs Reports, in the new app, Custom Analytical Queries and Services, the "Dimension Format" is relevant for KPIs Reports created from the Queries.

In order to create your KPI Report as desired, you need to migrate your Custom Analytical Query from the old app to the new one and re-create your KPI Report. Check the steps below:

1. Open the Custom Analytical Queries and Services (F1572A) app
2. Click on "Manage Queries" on the "Links" card
3. Click on "Migrate" button
4. Search for the Custom Analytical Query that you want to migrate
5. Select the Query and click on "Ok"
   At this moment, you can also check the KBAs 3603185 – Migration of Queries to Projection Views and 3603149 – Rework tasks after migration to understand in details this migration process.
6. As per the KBAs above, you'll need to define again the Dimension Format, because this is not migrated with the Query. For that, go to "Model" tab and select the dimension 
7. In "Dimension Format", select which display format do you want (In the example, it would be "Text Only")
8. Click on "Check" and after it's checked, click on "Publish" 
9. Once the Query is published, you'll need to create a new KPI Report. This is an important step, the KPI will not be automatically updated. It is necessary to create a new one using the Query as a datasource again.
10. Once the report is created, the element will be finally displayed as desired

For your reference, check the following documentations:

• SAP Help Portal | Custom Analytical Queries and Services
• SAP Help Portal | Configuring the Fields

KPI, report, dimension, format, key, text, custom analytical queries, custom analytical queries and services, F1572A, F2814, F1572, manage KPIs and Reports, wrong, display, UI, description , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem