Skip to main content
Solved

Augmented Attribute Tables - store historic data of a worklist with a timestamp

  • April 10, 2024
  • 10 replies
  • 74 views
julia.bauer
Level 9
Forum|alt.badge.img+6

Hello everyone,

 

I want to build a worklist in Celonis with exception messages that purchasers should process. New exception messages should be marked with an augmented attribute (Status: NEW). I also have another augmented attribute - Comment field. I now want to store every changes made manually (change status from e.g. NEW to in Clarification or changes in comments) into a table as this table is needed to train an AI model. Is this possible - has anyone made experience with this and is willing to share their experience?

 

Thank you!

 

Best regards,

Julia Bauer

Best answer by matt.witty13

Hi Julia!

 

Yes you can! I recently implemented an action flow that takes augmented attributes and writes them back to a data model.

 

imageYou need the "Get Rows" module to get rows from your knowledge model. Within the Get Rows module, you can select records from your knowledge model. In there, you'll select the augmented attributes you want.

 

The latter half of the action flow is the "Push CSV Data to Data Integration" AF.

https://docs.celonis.com/en/push-csv-to-data-integration.html

 

This should do what you're hoping!

10 replies

roland.czaba
Level 3

Hi Julia,

 

If I understand correctly and you would like to see several "edits"/comments on cases with timestamps that you would like to analyze later, then you could achieve this with tasks:

 

https://docs.celonis.com/en/involve-business-users-with-tasks.html

https://docs.celonis.com/en/task-augmentation.html

 

One huge advantage is that while you can have only 1 value (without cumbersome workarounds) in an augmented attribute, you can have multiple tasks, therefore I think it might suite your needs.

 

Regards,

Roland

dennis.pflug
Level 10

Hi all,

 

very interesting question. We are currently also having exactly the same question and although I like the idea of Roland to use tasks instead of comments it doesn't solve the situation that it would be benefitial having some sort of change log / history of augmented attributes available.

 

Thanks,

Dennis

julia.bauer
Level 9
Forum|alt.badge.img+6
  • julia.bauer
  • Author
  • Level 9
  • April 10, 2024

Hi Julia,

 

If I understand correctly and you would like to see several "edits"/comments on cases with timestamps that you would like to analyze later, then you could achieve this with tasks:

 

https://docs.celonis.com/en/involve-business-users-with-tasks.html

https://docs.celonis.com/en/task-augmentation.html

 

One huge advantage is that while you can have only 1 value (without cumbersome workarounds) in an augmented attribute, you can have multiple tasks, therefore I think it might suite your needs.

 

Regards,

Roland

Thank you very much Roland. I'll try this "workaround" as the history of augmented attributes is not avaiable (yet) as @dennis.pflug mentioned.

 

Best regards

Julia Bauer

matt.witty13
Level 10
  • matt.witty13
  • Level 10
  • Answer
  • April 11, 2024

Hi Julia!

 

Yes you can! I recently implemented an action flow that takes augmented attributes and writes them back to a data model.

 

imageYou need the "Get Rows" module to get rows from your knowledge model. Within the Get Rows module, you can select records from your knowledge model. In there, you'll select the augmented attributes you want.

 

The latter half of the action flow is the "Push CSV Data to Data Integration" AF.

https://docs.celonis.com/en/push-csv-to-data-integration.html

 

This should do what you're hoping!

dennis.pflug
Level 10

Hi Julia!

 

Yes you can! I recently implemented an action flow that takes augmented attributes and writes them back to a data model.

 

imageYou need the "Get Rows" module to get rows from your knowledge model. Within the Get Rows module, you can select records from your knowledge model. In there, you'll select the augmented attributes you want.

 

The latter half of the action flow is the "Push CSV Data to Data Integration" AF.

https://docs.celonis.com/en/push-csv-to-data-integration.html

 

This should do what you're hoping!

Really cool.

And when and how do you trigger this Action Flow?

matt.witty13
Level 10

Really cool.

And when and how do you trigger this Action Flow?

It sends data to a data model that's refreshed nightly, so I have it triggered automatically at the end of the work day before the nightly refresh goes off

dennis.pflug
Level 10

Really cool.

And when and how do you trigger this Action Flow?

ok so your data is getting saved once a day.

What if you want to log all insets / updates of comments where it can happen that one and the same row is getting updated several time per day. In this case it would be necessary to trigger the AF per each insert / update of an augmented attribute.

roland.czaba
Level 3

Hi Julia!

 

Yes you can! I recently implemented an action flow that takes augmented attributes and writes them back to a data model.

 

imageYou need the "Get Rows" module to get rows from your knowledge model. Within the Get Rows module, you can select records from your knowledge model. In there, you'll select the augmented attributes you want.

 

The latter half of the action flow is the "Push CSV Data to Data Integration" AF.

https://docs.celonis.com/en/push-csv-to-data-integration.html

 

This should do what you're hoping!

Hi Matt,

That is a great workaround as well! Very interesting solution. So basically you save daily snapshots of the augmented attributes? I guess with the last change date, you can even optimize it to send only those that have been updated during the day. The only downside is that the updates within the day are not captured, but of course that might not be needed for all the scenarios.

Thanks for sharing!

dennis.pflug
Level 10

Hi Matt,

That is a great workaround as well! Very interesting solution. So basically you save daily snapshots of the augmented attributes? I guess with the last change date, you can even optimize it to send only those that have been updated during the day. The only downside is that the updates within the day are not captured, but of course that might not be needed for all the scenarios.

Thanks for sharing!

Not sure if someone tried this already but wouldn't it be possible to execute a Skill for each update of an Augmented Attribute (setting KM - Augmented Attribute - On edit - Execute a Skill) and this Skill is triggering an Action Flow (Execute Action Flows in Skills (celonis.com) that is setup similar to what Matt is doing?

 

But I am not sure what is happening if many users are working within the view and doing changes on augmented attributes or if multiple rows are selected and an augmented attribute is getting updated for all of them.

matt.witty13
Level 10

Hi Matt,

That is a great workaround as well! Very interesting solution. So basically you save daily snapshots of the augmented attributes? I guess with the last change date, you can even optimize it to send only those that have been updated during the day. The only downside is that the updates within the day are not captured, but of course that might not be needed for all the scenarios.

Thanks for sharing!

So my AF captures all augmented attribute changes. In apps/views, it'll display PU_LAST so it is the most recent change. This allows for a full change log.

 

But yes @dennis.pflug in theory you could execute a skill/action flow to write it back as the change is happening. You should be able to mass update, but I would recommend building in a SLEEP module for a couple of seconds as to not overload the data integration side of things

Community Code of ConductAccessibility statement