Skip to main content
Solved

Good Practice for Displaying Historical KPIs in Celonis (Without Source Data Overwrite)

  • June 11, 2026
  • 6 replies
  • 848 views
Krzysztof_G
Level 3
Forum|alt.badge.img

Hi everyone,
 

I’m looking for advice on how to track and display historical KPIs in Celonis so the values are not overwritten as source data changes over time.
 

Example:
I want to track the % of maintenance tariff codes for purchase order items (i.e., EKPO.BEST_STAWN filled vs. all items). Some of my KPIs also use relationships between EKPO, MARA, and LFA1.

I need to calculate and store these KPIs in monthly intervals—to know exactly what the maintenance value was for each month in the past, not just recalculate it on current data.
 

1 What’s the best way in Celonis to store unchangeable monthly KPI values?
2 Is it better to use Automated Table Snapshots (copy/freeze tables) or KPI Snapshotting (export results), or something else?

3 If table snapshots are best, should I build them in the backend (SQL/jobs) or can I do it inside Celonis using Action Flows or some built-in module?
 

Thanks!

Best answer by fabian.wende

Hi Krzysztof,

if I get your requirements right, would be the KPI Snapshot Feature the most easy to implement: KPI Snapshots

 

However, these data isn’t also not written back to your source system.

 

Best regards,

Fabian

    6 replies

    Kamil Deren
    Level 3
    Forum|alt.badge.img+1
    • Kamil Deren
    • Level 3
    • June 11, 2026

    Hi Krzysztof,

    If I understood you correctly, you want to take snapshots of current status month by month and show the progress on some kind of chart or table right?

    I am using simple Action Flow for that (example where I track number of duplicates in Vendor Master Data):

     

    In “Get Rows” module I am querying current state of my KPIs:

    And then writing it back to the table that I add to my Data Model:


     

     

    I have also tried to use automated SQL snapshots but I found this way easier and more reliable.

     

    Hope that helps! ​​​​​​​

      G
      Level 9
      Forum|alt.badge.img
      • gil.liu
      • Level 9
      • June 12, 2026

      ​@Kamil Deren , you are writing figures back to SAP table ?

        Kamil Deren
        Level 3
        Forum|alt.badge.img+1
        • Kamil Deren
        • Level 3
        • June 12, 2026

        Hi ​@gil.liu ,

         

        With this solution no. This data is stored in the Data Pool table and added as a table into the Data Model, so it can be used in Views.

         

        However, writeback to SAP is possible using SAP modules in Action Flows, but that was not the goal of this project.

        fabian.wende
        Level 6
        Forum|alt.badge.img+1
        • fabian.wende
        • Level 6
        • Answer
        • June 18, 2026

        Hi Krzysztof,

        if I get your requirements right, would be the KPI Snapshot Feature the most easy to implement: KPI Snapshots

         

        However, these data isn’t also not written back to your source system.

         

        Best regards,

        Fabian

        Krzysztof_G
        Level 3
        Forum|alt.badge.img
        • Krzysztof_G
        • Author
        • Level 3
        • July 8, 2026

        Hi Krzysztof,

        if I get your requirements right, would be the KPI Snapshot Feature the most easy to implement: KPI Snapshots

        However, these data isn’t also not written back to your source system.

         

        Hi ​@fabian.wende 

        Thanks for your reply. I understand that the snapshot data is not stored in the source system, but is it stored somewhere within Celonis (KPI Snapshots Data Model / Data Pool?)?

        For example, is there a table where the KPI Snapshot values are saved and can be accessed later?

        Thanks for your help!

         

         

         

         

        L
        Celonaut

        Hi Krzysztof,

        if I get your requirements right, would be the KPI Snapshot Feature the most easy to implement: KPI Snapshots

        However, these data isn’t also not written back to your source system.

         

        Hi ​@fabian.wende 

        Thanks for your reply. I understand that the snapshot data is not stored in the source system, but is it stored somewhere within Celonis (KPI Snapshots Data Model / Data Pool?)?

        For example, is there a table where the KPI Snapshot values are saved and can be accessed later?

        Thanks for your help!

         

        Hi ​@Krzysztof_G,

        Regarding the Kpi Snapshots, the data is actually stored in the data pool related to the source Knowledge Model of the KPIs you configure to track (More info here). There is a set of tables created with a unique random alphanumeric suffix (per pool) that stores the Kpi Snapshots data: snapshot_{{suffixId}}, tag_{{suffixId}}, filter_{{suffixId}}, dimension_{{suffixId}}, dimension_value_{{suffixId}}, kpi_{{suffixId}}, kpi_log_{{suffixId}}, kpi_log_metadata_{{suffixId}} 

        You can consume this data by creating a custom data model.

        There is also a central data pool that consolidates all the different Kpi Snapshots into a single data pool that can be either used via Transformation Hub in Views or directly consumed by the Data Model present there.

        Regards,
        Loveen.
         

        Community Code of ConductAccessibility statement