In SAP Marketing Segmentation you want to use the 'Total Amount' or 'Amount' Filter of the 'Sales Data' attribute group. Instead of the preview an error related to 'Currency/Unit conversion Error' is displayed.
SAP Marketing Cloud Edition
Reproducing the Issue
- Log on to Fiori Launchpad in the SAP Marketing Cloud
- Create a new segmenation model
- Click on the 'Total Amount' attribute to display the preview
- Instead of the preview following SQL error is shown.
This error is raised due to missing exchange rates required for currency conversion when retrieving sales related interactions with currencies other than the default currency.
- Figure out affected currencies.
In segmentation use the attribute 'currency' from the 'interactions' attribute group to preview all currencies used in any interaction:
- Make sure to have the exchange rates maintained for the default currency and all retrieved currencies.
Access the 'Maintain Exchange Rates' app - the app is available in the business role template Administrator Marketing (SAP_BR_ADMINISTRATOR_MKT)
Make sure that the exchange rate is maintained for all currencies.
When looking at the example from the currency segment, the currency ZAR is maintained in the app, so won't cause any issues. For the currency FRF however there are no exchange rates maintained, this will therefore cause the SQL error.
SQL error in segmentation (ADBC); SQL-Fehler bei Segmentierung (ADBC); currency/unit conversion error; could not determine valid conversion rate for value Segmentation; Total Amount; Sales Data; Currency; Currency Exchange Rates; Interactions; Segmentierung; Gesamtbetrag; Verkaufsdaten; Währung; Umrechnungskurse pflegen; Interaktionen; , KBA , CEC-MKT-SEG , Segmentation , CEC-MKT-BF , Basic Functions , Problem