SAP Knowledge Base Article - Public

3250988 - Currency column shows an error when importing data into Process Intelligence.


Why when I import data into a process in Process Intelligence does my currency column show the error ''50% of the data is not compatible'.


SAP Signavio Process Intelligence 3.0

Reproducing the Issue

  1. Open Process Intelligence.
  2. Create a new process via the 'New Process' button on the right hand side.
  3. Name the process and press 'Create'.
  4. On the data tab, click the browse button in the Import data box.
  5. Select a file that includes negative values shown by using preceded with (slashes) and press import.
  6. In the newly opened page, select the column in your excel sheet which will act as the Case ID, the Activity Name and the End Timestamp.
  7. See that when you finish this selection the currency column will say 50% of the data is compatible.


The data is being shown as 'not compatible' in our system as we at SAP Signavio use negative exchange rates for inverting currency conversions. That is, we show negative values by preceding numbers with minuses (-). You are  however preceding your values with slashes (/) instead and is thus causing the error.


To fix the issue, please swap out all the slashes (/) you use in your data to represent negative numbers for minus (-) signs.


process, intelligence, import, data, investigation, minus, slash, 50%, fifty, percent, not, compatible, error , KBA , BPI-SIG-PI-DS , Data Source (CSV, Connector) , Problem


SAP Signavio Process Intelligence 3.0