Skip to main content

General Q&A

Can't find what you're looking for? Ask it here!

  • 1,198 Topics
  • 2,563 Replies
1198 Topics
S
Level 3
sachin.topul13Level 3
posted in General Q&A
What can be reasons for Open Invoices.

What can be reasons for Open Invoices. Any Available views for Open Invoices in Accountz Payable.

00
S
Level 3
K
Level 3
kinsley.leLevel 3
asked in General Q&A
CALC_THROUGHPUT for two activity columns in the same table

Hi,I would like to to apply this function to mesure the cycle time of Change Activities. The activities table looks like this: Case ID2 columns "Change From" and "Change To" along with timestamp columnTime starts counting for each case when Change To = A for the first time and ends when Change from = A for the last time.   The logic Im trying to work around is (just disregard the function syntax- Im just trying to explain the logic.CALC_THROUGHPUT( First_Occurance ('Change to' = 'A') to Last_Occurance ('Change from' =' A '), Remap_Timestamps("Table"."event time", days) What is the right way to implement this logic?Should I filter the table to be "Change to" = 'A' or "Change from" = A and then merge this two columns to form a single column to use calc_throughput? But then how to merge different columns in the same table? Thank you for any suggestion!  

100
K
Level 3
A
Level 3
aldona.potocLevel 3
asked in General Q&A
Select cases with activity event time within a time range chosen from date picker

I have am OLAP table containing cases with event time of activity X and Y and a date picker based on the activity X. When I select a time range from my date picker (i.e. 01-01-2023 to 10-01-2023 or 01-02-2023 to 28-02-2023) I would like to see only these cases for which event time of Y is within the chosen selection with result 'in scope' and 'out of scope'. I don't want to have a second date picker and have to choose the same date range manually.

90
R
Celonaut
academic.allia11
Level 1
academic.allia11Level 1
posted in General Q&A
Business Analyst - Customer Value Analytics (m/w/d)

Business Analyst - Customer Value Analytics (m/w/d)E.ON Energie Deutschland GmbH Loction: Essen (NRW), München (BY)Description: Du unterstützt uns bei der Bewertung des Bestandskundenportfolios anhand verschiedener analytischer Use Cases mit den Schwerpunkten Lifecycle Analysen, Preisanpassung, Portfolio - Analytics und KohortenanalyseDazu screenst du Daten und baust Datenmodelle zur Abbildung der Business Logik aufDu erstellst Analysen und Reportings in PowerBI und Process Mining (Celonis) und entwickelst diese weiterOptional erstellst du auch Analysen und analytische Modelle u.a. mit PythonDu visualisierst Daten aussagekräftig und kannst Wirkzusammenhänge erkennen und erklärenDu erstellst managementtaugliche Präsentationsunterlagen im notwendigen Abstraktionsgrad, um die komplexen Zusammenhänge im Bestandskundenportfolio zu transportierenDu unterstützt im Rahmen der Projekt-/Squad-ArbeitZur Bewerbung: https://jobs.eon.com/de/job/Business-Analyst-Schwerpunkt-Customer-Value-Analytics-m

30
academic.allia11
Level 1
connor.manth
Level 3
connor.manthLevel 3
asked in General Q&A
Why use a variable over a KPI (saved Formula) in Celonis Analyses?

Is there a best practice to chose a KPI (saved Formula) over a variable in Celonis (or vice versa)? For example, I seem to recall that all KPIs are calculated upon loading the analysis? Would that make certain uses more suitable to a variable?

20
michael.tong
Level 2
carsten.erdma
Level 1
carsten.erdmaLevel 1
asked in General Q&A
building a simulation tool

I want to make a Simulation. The Simulation depends on the weekly data of - how many parts do i've to produce- how many peaple are present in this week- the expected duration of the machines (OE)(eg. 100 hours active of 120 possible hours is 83%)- number of shifts is it possible to change the data of the OE for example in an table in the front end to see the impact of this change on the output.

20
carsten.erdma
Level 1
J
Level 3
julia.terec11Level 3
asked in General Q&A
I would like to add a status selection functionality in the studio. I would like to have a default status of 'To checked' and for the user to be able to change to 'to be checked'. Does anyone have an idea how to do this?

I would like to add a status selection functionality in the studio. I would like to have a default status of 'To checked' and for the user to be able to change to 'to be checked'. Does anyone have an idea how to do this?

10
J
Level 3
S
Level 2
subhankar.ghosh12Level 2
asked in General Q&A
I would require some help on predictive analytics use cases for p2p process. Any help on this would be appreciated

I would require some help on predictive analytics use cases for p2p process. Any help on this would be appreciated

10
I
Level 1
T
Level 2
taysa.carvaLevel 2
asked in General Q&A
Hello all!I work as global improvement lead and I am currently working on communication templates when developing new use cases for the company. I would like to check if anyone has any good practice to share in this topic?

I think communication is key when developing something new. However, when we are dealing with people all over the world, we need to think it in a smart way. I am looking for something opened and clear, also friendly and not full of formality. Hopefully you are able to share some good practices :) Looking forward!

00
I
Level 1
V
Level 1
vira.semisLevel 1
asked in General Q&A
How to save draft of data pool using API or Pycelonis?

Hello,  I need to schedule publishing of data pool draft. There is the function publish() for packages in PyCelonis but I haven't found something similar for data pool in API documentation or in PyCelonis.  Is there any way I could run saving of data pool draft or adding a new version for unpublished drafts? Is sync of data pool an option for this? Thank you very much!

10
I
Level 1
silke.norri
Level 2
silke.norriLevel 2
asked in General Q&A
Why does the Automation Rate with time dimension Eventtime change ex post?

Hi all, we report the Automation Rate with Eventtime as time dimension. We were expecting, that the Automation Rate therefore should be stable e. g. for the past year 2022 regardless whether we extract the data in March or in June. Unfortunately we have changes even though we did not change the measurement.We have deviations in the number of activities as well as the number of cases.  Formula:AVG(CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_<%= language %>" IN (<%= whitelist %>) THEN NULL WHEN ISNULL( "_CEL_O2C_ACTIVITIES"."USER_TYPE") = 1 THEN NULL WHEN "_CEL_O2C_ACTIVITIES"."USER_TYPE" IN (<%= auto_user_type %>) THEN 1.0 ELSE 0.0 END) Remark: We have not changed the whitelisted activities nor the user types included in the variable auto_user_type.Any ideas? Thanks in advance 

00
silke.norri
Level 2
G
Level 2
gurbachan.chadhLevel 2
asked in General Q&A
I'm looking for a study group at NY/NJ/PA or virtual for Celonis Data Analyst Certification. Can you please advise? Thanks!

I'm looking for a study group at NY/NJ/PA or virtual for Celonis Data Analyst Certification. Can you please advise? Thanks!

20
I
Level 1
farouk.abdel
Level 2
farouk.abdelLevel 2
asked in General Q&A
Hello All, can anyone share how to best respond to customer concern on subjecting their tables to cloud environment and is there any on premise option in Celonis? Thanks you

Hello All, can anyone share how to best respond to customer concern on subjecting their tables to cloud environment and is there any on premise option in Celonis? Thanks you

00
I
Level 1
H
Level 3
himanshu.sharm16Level 3
asked in General Q&A
Hi, How can I "hide" a published package inside a space? Just like i can hide (Visibility On/Off) the assets inside a package, i was looking for a solution for hiding the whole package. thanks

Hi, How can I "hide" a published package inside a space? Just like i can hide (Visibility On/Off) the assets inside a package, i was looking for a solution for hiding the whole package. thanks

80
H
Level 3
J
Level 3
julia.terec11Level 3
asked in General Q&A
I would like to do a dropdown but I keep getting a message that "The aggregation function SUM cannot be used toether with dimension function input. I tried making saved formulas for my code, but also I've got error.Have you got idea how to do it?

I would like to do a dropdown but I keep getting a message that "The aggregation function SUM cannot be used toether with dimension function input. I tried making saved formulas for my code, but also I've got error. Have you got idea how to do it?

210
J
Level 3
S
Level 2
siemen.deseyLevel 2
asked in General Q&A
Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)?Thanks for the help!

Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)? Thanks for the help!

00
kailash.potha12
Level 5
ariane.reis
Level 3
ariane.reisLevel 3
asked in General Q&A
Hy Guys!I would like to count how many activities started from the year 2023 ?You know?

Hy Guys! I would like to count how many activities started from the year 2023 ? You know?

00
kailash.potha12
Level 5
C
Level 3
claudio.tatiy12Level 3
asked in General Q&A
Hi Community! How can I use the View Variable into a Filter expression?

Hi Community! How can I use the View Variable into a Filter expression?

690
kailash.potha12
Level 5
R
Level 2
rafikahamed.moham12Level 2
asked in General Q&A
I need access for PQL Queries Certification which I almost near to pass the exam and already used Couple of time.

I need access for PQL Queries Certification which I almost near to pass the exam and already used Couple of time.

00
K
Level 1
Z
Level 2
zhiang.chenLevel 2
asked in General Q&A
We are seeking to access detailed data from the accounts receivable demo, but we are unsure of the process to export this data. Could anyone kindly provide guidance on how we can achieve this?

We are seeking to access detailed data from the accounts receivable demo, but we are unsure of the process to export this data. Could anyone kindly provide guidance on how we can achieve this?

10
Z
Level 2
O
Level 2
oded.tzukLevel 2
asked in General Q&A
Hi all, can you advise the SAP table number that is used for Plant Maintenance.Is there an example log file for Plant Maintenance or table scheme?Thank you.

Hi all, can you advise the SAP table number that is used for Plant Maintenance. Is there an example log file for Plant Maintenance or table scheme? Thank you.

00
O
Level 2
H
Level 3
himanshu.sharm16Level 3
asked in General Q&A
Hi Community,can anyone tell me if there is a maximum number of eventlogs (activity tables) that can be used in a data model? ThanksHimanshu

Hi Community, can anyone tell me if there is a maximum number of eventlogs (activity tables) that can be used in a data model? Thanks Himanshu

00
H
Level 3
M
Level 2
marcia.cristina.silvaLevel 2
asked in General Q&A
I would like to know more about Signal Link Explorer

I am trying to understand how can I use a Signal Link Explorer (SLE) component in a view.  I found in Celonis documentation orientation about Network Explorer (NE), even it is mentioned that exists SLE, but I didn't find further information about it.  I would like to access an explanation about the YAML components of it.  I found it applied at Inventory Management app and I would like to use it, but I didn't understand how to get there.  I hope someone is able to help me on it. 

60
andré.tafur
Level 4
S
Level 2
siemen.deseyLevel 2
asked in General Q&A
Hello All. For our Clients process, we need activities that are happening in the process, but should not be shown as a process step, because it's a violation. How can we implement that?

Hello All. For our Clients process, we need activities that are happening in the process, but should not be shown as a process step, because it's a violation. How can we implement that?

20
gabriel.okaba11
Celonaut
V
Level 1
victor.tittoLevel 1
asked in General Q&A
Hi Community. Quick question here. Do we have any success story avaliable with big numbers in Telko for:Rework activitiesStock avaliablity/ succes rate on minimum stockOr something similar? Thanks

Hi Community. Quick question here. Do we have any success story avaliable with big numbers in Telko for: Rework activities Stock avaliablity/ succes rate on minimum stock Or something similar? Thanks

10
R
Celonaut

Badge winners

  • Qualified to Build Analyses
    viktoria.nikol12has earned the badge Qualified to Build Analyses
  • Qualified to Manage Change and Scale Adoption
    lasse.muellhas earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Identify and Drive Opportunities
    lasse.muellhas earned the badge Qualified to Identify and Drive Opportunities
  • Qualified to Write PQL Queries
    leo.ebert12has earned the badge Qualified to Write PQL Queries
  • First Post
    NHARNIShas earned the badge First Post
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025