Skip to main content
Solved

How can I find, which variables and formulas are not used in EMS?

  • March 11, 2024
  • 2 replies
  • 4 views

michael.kaemp
Level 5
Forum|alt.badge.img

I thought, I could use the generic technical documentation for Analysis sheets. But it turned out, that it's incomplete as it does not include design components like button dropdown.

Best answer by matt.witty13

The only real way to do it is through Python. You'd have to pull in every component with every KPI you have and then do a comparison. I've got a script that pulls all KPIs which have been built, but it doesn't say whether we're using it because there's added complexity to that.

 

It is possible but likely much easier Sverre's way by documenting ahead of time and carrying a comprehensive change log.

2 replies

Sverre Klein
Level 10
Forum|alt.badge.img+14
  • Level 10
  • 204 replies
  • March 12, 2024

Hi @michael.kaemp,

 

There isn't a direct way to identify unused variables and formulas in Celonis to the extend of my current knowledge. Normally I document which variables & Formula's that have been used per sheet in the EMS to avoid these kind of questions..

 

Best thing you could do is request the documentation for the dashboards that were build.


matt.witty13
Level 10
  • Level 10
  • 123 replies
  • Answer
  • March 14, 2024

The only real way to do it is through Python. You'd have to pull in every component with every KPI you have and then do a comparison. I've got a script that pulls all KPIs which have been built, but it doesn't say whether we're using it because there's added complexity to that.

 

It is possible but likely much easier Sverre's way by documenting ahead of time and carrying a comprehensive change log.