You are able to display Key Figures with multiple unit/currencies in HTML5 UI, however in RUI you see the message 'Aggregation not possible. Multiple Unit/Currency used' on the screen instead.
SAP Cloud for Customer
Reproducing the Issue
- Log into the system on RUI mode
- Go to Home and check on the Report Tiles
- See the message displayed 'Aggregation not possible. Multiple Unit/Currency used'
- Log into HTML5 UI mode and see that the results are displayed on this UI
In HTML5 tiles, the unit is displayed with '*', which means that the currency could not be determined. In other words, the values contain different currencies or units and aggregating these values may not bring meaningful results.
For example: In HTML5, if the values are 10 USD and 20 EUR, the system shows '30*' on the tile, which is not meaningful or correct result. So in RUI, this error message is shown to prevent that wrong results come in the Home Tiles, since the system cannot aggregate values in different units / currencies.
Ensure to maintain a unit/currency conversion in the report for the issued key figure. You need to ensure that the key figure shows all values in the same currency/unit, then it shows the correct aggregation on the home page.
You can refer to document: '1957737 - The Report Does Not Convert the Currency of the Key Figures' for further details on the resolution.
aggregation not possible, business analytics, report, home page, multiple unit currency , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To