Product Q&A

My company is changing its brand name, also all employee e-mail addressses change. How can we manage this change with Celonis?

For using celoextractor we would need on-premise system and dataconnection in particular VM?

Hi, I need PQL code for below query. 1) Need Sum total of "BSEG"."WRBTR" column based on a new manually created column having concatenation of "BSEG"."LIFNR" and "BKPF"."XBLNR".

Example in the below picture is one of the scenarios: 1. Invoice is posted in Jan 2023 but paid in May 2023. Hence, the total open invoice amount should be accountable for not only Jan but also for feb, march and april. Unfortunately, I get the Total open invoice amount accounted from the posting month followed by all the rest of the month in the data set.  My current approach:Round(Posting Date) column: RANGE_APPEND(((ROUND_MONTH("O2C_AR_BSEG"."CPUDT"))), '1M')Total RUNNING SUM column: RUNNING_SUM( SUM(  CASE WHEN ROUND_MONTH("O2C_AR_BSEG"."CPUDT") <> ROUND_MONTH("O2C_AR_BSEG"."AUGDT")  THEN  (  CASE WHEN ISNULL("O2C_AR_BSEG"."AUGDT") = 0  AND ROUND_MONTH("O2C_AR_BSEG"."CPUDT") < ROUND_MONTH("O2C_AR_BSEG"."AUGDT")  THEN "O2C_AR_BSEG"."WRBTR_CONVERTED"  END)  END  )) I know that I should set a start and end range to my PQL query: R

In the celonis View do we have any component to create a pivot table similar like in Analysis.Please let me know the steps if there is a possibility in Views(to create pivot table)

I want to create a variable in new view which would add every current year automatically into the table. Please help.

Since Custom Extractors are implemented por REST APIs only, what is the best strategy to consume a SOAP web service? I successfully consumed it via a Python request, using an XML body. Is Celoxtractor the only way to upload the data, or is there a more straightforward way to connect to a SOAP WS? Thanks

Is a procedure as described in the screenshots possible with extractor builder?

Is there a way to share a link for a view (also package) to a user with access rights, but the link is easier for them to open the dashboard?

Is it possible to connect multiple sources into one process ,with different type of sources (ARIBA +SAP ECC , Success factor + SAP ECC, MS-SQL + SAP ECC) ?

I know it might seem simple question but i am struggling with uploading BPMN file for my conformance sheet. can anybody tell where and how to upload it ?

I would like to have the green start where the blue stop (Stacked graph)- how can I do that? 

I want to know who is my Partner Manager Urgently: Thanks gabriel.cifuentes@cliptecnologia.com

Hi,  I wanted to implement the open target quantity in celonis. Therefore I used the RUNNING_TOTAL function to add up the quantities as shown in the screenshot. After, I wanted to subtract the RUNNING_TOTAL from the target quantity, the code for this looks like that: "CONTRACT_INFO"."KTMNG" - RUNNING_TOTAL("EKPO"."MENGE") That constantly gives me the following error:  The running aggregation function RUNNING_TOTAL cannot be used together with a dimension function input. Please check that there are no moving aggregations and dimensions used together as function inputs. Even if I try to use e.g. AVG(), SUM(), LAST() in front of "CONTRACT_INFO"."KTMNG" , it's not working. Only if I use RUNNING_TOTAL() in front of "CONTRACT_INFO"."KTMNG" it's working, but obviously this is giving me wrong results. Thanks for your help.

I have add the action send an email for the enhanced view for a table but when i select the button to execute the action it is giving me a pop up. Any way to resolve it

In extraction I want to change data type of a column from text to timestamp. Format of data is 2022-10-27 07:27:19.01 +00:00. Now I want to change it to timestamp and enter format for it in extractions. What format will be accepted there. 

Can i change my name after completing training track and get certificate with the changed name?

@Sophia Stephenson​ @Brian Dees​ 

Hi Everyone, I'm trying to create a dropdown in legacy views, it should work as filter if I select value from the dropdown and it should update the variables too.

Schedule transformations for individual perspectives for object-centric process mining (2024-05-07) This is a Limited Availability functionality. Instead of running the complete OCPM data job to create objects and events for all your enabled processes, you can now set up schedules to run the transformations for one perspective at a time (or more than one if you want). This feature is currently in Limited Availability - if you'd like to try it out now, open a Service Desk ticket to request it. We're planning to have it in General Availability soon. When you run the OCPM data job through a schedule where you've selected perspectives, we'll identify all the objects and events that are part of those perspectives. Then we’ll run only the transformations that are needed to create those objects and events from your source system data. You can create dedicated schedules for the Celonis-supplied perspectives for the Celonis catalog processes, and also for your custom perspective

Hi team, I am working on creating a profile view, for which the identifier in record is required. As DISTINCT and usage of two tables is restricted while creating an identifier, I am using PU_FIRST and using same table and column in target and source.  I am able to make records unique, but I am facing problem when I am adding KPIs for this profile view dimension. It looks like it is showing duplicates. Can someone please let me know why this approach is not right and any alternative solution for the same ?

I registered a few days ago for c4c and have not heard anything since. Just to be sure, how long does it normally take until I have been vetted? (I still have enough to do in the Academy but it would be nice to know a timeframe) Thx Mark

 Hello, Actually I have passed 3 out of 4 sections in my first attempt itself but I failed in one section which is Section 2: Process Mining Fundamentals. For this section I failed in my first 2 attempts. So now I want to give it try but I am unable to. So, the instruction say that we have 4 attempts in total. First two and then 2 days cool-off and again last 2 attempts. So now it's been more than 2 days since my last 2 failed attempts but still I haven't got my last 2 attempts, it's saying 0 attempt left.

Hello, Actually I have passed 3 out of 4 sections in my first attempt itself but I failed in one section which is Section 2: Process Mining Fundamentals. For this section I failed in my first 2 attempts. So now I want to give it try but I am unable to. So, the instruction say that we have 4 attempts in total. First two and then 2 days cool-off and again last 2 attempts. So now it's been more than 2 days since my last 2 failed attempts but still I haven't got my last 2 attempts, it's saying 0 attempt left. So please help me with this.

I did not use my attempts but it is showing 0 attempts remaining What should i do?