Skip to main content

Hi everyone,

 

We have several ABC Classifications that we need to implement in Celonis and I’m simply curious:

Why is the ABC classification resulting in a 1, 2, 3 ranking? I’m ending up having to convert to string and remap the values for each classification so that it makes sense for the users and while it’s not a huge issue, I think it would be easier if the function just resulted in A, B, C directly. Is it for efficiency by using integers?  

Or does this allow for some further analysis that I’m not seeing at the moment maybe?

 

Best regards,

Benjamin

Hi there,
The ABC classification function in Celonis returns numerical values (1, 2, 3) instead of the letters (A, B, C) primarily for reasons of computational efficiency and analytical flexibility. By using integers (1 for A, 2 for B, 3 for C), the system can perform faster processing, sorting, filtering, and mathematical comparisons downstream, which would be slower and less straightforward with text strings. This design decision prioritizes consistency across the platform's calculation logic. If you need the output to visually display as 'A', 'B', or 'C' for user-facing dashboards, you can easily achieve this by applying a simple CASE statement in your analysis layer to remap the numeric result back into the required string format for presentation purposes.
Hope it helps!

Thanks for the feedback, that makes sense from a technical perspective and you’re right, given that it’s only 3 cases, it’s definitely better to use a Case statement rather than the remap_values statement!

Community Code of ConductAccessibility statement