Ask questions and get answers about Celonis products from experts and peers.
Recently active
In generell the dropdown filter would start at 0:00 and end at 23:00 depending on a table with timestamps. In this case the occurances of events for different hours (e.g. 05:35, 05:12 ..) from timestamp table have to be agglomerated and each hours should be distinct (e.g. 05:35, 05:12 --> 05:00). Thank you for your help!
I'm trying to configure my machine learning workbench, but it seems I still don't have the proper permission to do it. Any clues on how I'd be able to get the updated ML license?
Hello Team,While creating Action flow, by using Get rows Celonis module. After selecting appropriate Knowledge model only few KPI's are shown, recently created KPI are not shown. How can I access newly created KPI?Thank you in advance.
Here the amount is still in ascending order even after sorting it as descending.
Who knows it?Sometimes I get DPO like this: 466,243,595,672,831,872 daysFor example: one vendor, two invoices, sum of these two invoice is 0 €. I think it is a problem with the sum of 0 €. But how can I resolve it in the PQL formula?
Hallo Team, I have been using the P2P dataset provided by the academy. Had used the following statement to calculate the PU_median according to each case - PU_Median("LFA1", "_CEL_P2P_ACTIVITIES_EN"."EVENTTIME"). I have diffculties understanding the outcome (in pic attached) - Why do I get the PU_Median time calculated in seconds format?How can I convert the O/P format in seconds to DD-MM-YYYY ? - Had tried using {t } function, but it was an failureEven though there are different time stamps for each case wrt to activity - why do I get the same median time (1245079800000) for all the cases? Can any I detail it . Thanks in advance.
Can any provide a sample Table-ABAP-Configuration.xlsx file
Hello, Anyone knows how to reference array without keys (1. Value A2. Value B)or just a string ("Value A, Value B) in a outlook recipients module? I've tried several approaches but nothing seems to be working properly. I do not want to send multiple emails to single recipient (1 mail = 1 recipient). I want to send 1 email to multiple people in both "TO" and "CC" fields. It's improtant as we've got dynamic recipients list. Usually I end up with one of two errors: or Best Regard,Mateusz Dudek
I have started creating more of my use cases as "Views" and realized I am unable to use the "Generate PDF Report" action flow with them... Seems like Views are what will be the preferred destination for use cases premade and custom. I would like to be able to use them the same in action flows
Hello guys,I'm trying to find a solution to modify the maximum execution timesout in one of my Action Flow, it stops before all data are transfer in one of my google sheet file. Do you have an idea ? Thanks !
Helo everyone, I struggle with a topic that has came up twice now in different data models:. Following scenario with the folowing data model:[MSEG] N --- 1 [MARC]1 --- N [MARC] I have a frontend table with different MARA and MARD information. It showcases each Material, their storage location inside a plant and several other information. Now I want to add a certain field from MSEG: The last time a material was moved inside a storage location (inside plant). Now I have to use a PU-function since MSEG and MARD are not connected, only through the MARC-Table. The issue is, that MARC aggregates all data on the plant level, but I want to have the date on storage location level. Example: Material A is stored in storage locations 10 and 20 in plant X. (Info in the MARD and MSEG table) Material A in storage location 10 and plant X was last moved on the 01.01.2023. (Info in MSEG table)Material A in storage location 20 and plant X was last moved on the 03.01.2023. (Info in MSEG table) A simple f
We have built an Action Flow to capture daily stats from an analysis and store it in a SharePoint. When we try to execute this Action flow manually, it does not give an error and works properly but when scheduled, it gives the below error. "Function 'getResponseBody' finished with error! Script execution timed out after 10000ms." How to mitigate this?
Hi everyone, i got following activity table structure:Item ID (case ID), Activity (activity), Timestamp (timestamp), Item position ID One Item ID can have multiple Item Position IDs; so 1:n relationship. Some activities tend to repeat themselves for each distinct Item Position ID, example: Item 1, Activity A, 08.08.2023 10:00, -Item 1, Activity B, 08.08.2023 10:01, ItemPosition 11Item 1, Activity C, 08.08.2023 10:02, ItemPosition 11Item 1, Activity B, 08.08.2023 10:03, ItemPosition 12Item 1, Activity C, 08.08.2023 10:06, ItemPosition 12Item 1, Activity D, 08.08.2023 10:07, - I want following throughput time calculation to be considered for each Item Position ID, which i am not able to generate. CALC_THROUGHPUT ( FIRST_OCCURRENCE [ 'Activity B' ] TO FIRST_OCCURRENCE [ 'Activity C' ] , REMAP_TIMESTAMPS ( "Activity_Sheet"."TIMESTAMP" , MINUTES )) Output expected:ItemPosition 11, 1 min.ItemPosition 12, 3 min. Generally i would create 2 activity l
Hi All,Im trying to find the count of throughput time in buckets in views. The histogram are the way to go but in views they only accomodate integer and floats but not dates. Im trying to come up with it in Chart but unable to.Please let me know if someone has any idea.
Hi, Does anyone know how to make an input for an automation skill optional?The option is greyed out for me. I would like to be able to trigger a skill using an action without having to fill fields if they are empty. Thanks!Teun
The documentation feature in Process-Analytics (https://docs.celonis.com/en/export-technical-documentation.html) is a great one to keep track of the logic developed and is of great use for developers and business users. Is there something similar in Studio fpr knowledge models?
Is this official Celonis email address: partner@celonis.com from which you are sending the newsletter to your customers?
There is no sign-up functionality for Celonis for Consulting Partnership. I signed up but as a Guest and no feature to change from Guest to Partner signup. Can you please kindly change my sign up to a Partner in the name of Sceamdo Technologies? Thank you
Want PQL Query for Paid Early.
Hello, I open this question that was already asked by another user 5 months ago and not answered from Celonis. Moreover, I'm not allowed to comment or ask for update on that post if the post is older than 30 days. I would like to query data in an Action Flow from the Knowledge Model and not from the Data Model. Currently I have an Action Flow connected to a Data Model and I have modules like Tools (set multiple variables) replicating the same KPIs I have in the Knowledge Model. If I need to update a KPI in the Knowledge Model I have to remember to update it as well in the action flow, this causes high maintenance and possibility of error. This feature is critical since one of the main goals of using Studio is the centralization of KPI definitions into a single source of truth, the knowledge model. If you have any update on this topic I'd appreciate if you can share it with the community. Thanks. BRAlejandro
How to force load empty csv/xls files using pycelonis? Its a client requirement
Starter Kit version for object-centric process mining (2023-07-18) An Accounts Payable Starter Kit version that supports object-centric process mining is available now from the Celonis Marketplace. The object-centric Accounts Payable Starter Kit version 1.0.0 uses the Accounts Payable perspective that’s supplied with our object-centric data model, or a custom Accounts Payable perspective that you have created in your team. Before you set up the object-centric version of the Starter Kit, you’ll need to load the object-centric data model with your data and validate the Accounts Payable perspective. The Starter Kit uses the objects and events that you’ve already built from your source system data and stored in the OCPM Data Pool. To get started, see Quickstart: Extract and transform your data into objects and events. To use this version of the Starter Kit, you'll need a Celonis EMS subscription that includes object-centric process mining. If you can't see the Data > Objects and
Hi everyone! I am trying to set up triggers on my sanbox enviroment but It does not has that.. Does anyone know why?
Dear Experts , I have P2P activity logs and i have users column along with it infront of activity who executed it. Is it possible to create a network diagram using network explorer with each node being users along with value of transactions they are executing ? Can you advise ?
コンポーネントのアクティビティエクスプローラーで検索されるアクティビティを固定したいです。 通常の状態だとアクティビティエクスプローラーのアクティビティを選択しても、パッケージを移動すると値がリセットされてしまいます…
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.