General Q&A - TO REMOVE

With REMAP_VALUES I was successfully able to remove an unwanted activity from my process flow. Now I am trying to use it with the load script to use it for the whole screen, but it doesn't work. Tried several syntax, but no success. Is there a way using it?

The relevant colums are 'status', which shows the ticket status, e.g. accepted, solved, closed, etc, and the column 'emailaddress', which shows the emailaddress of the employee who changed the status. A ticket should be solved and closed by different employees. Thus, when an employee closes a ticket, this should not be a ticket which that employee solved. I would like to see a ratio of the number of tickets that were solved and closed by the same employee and the number of tickets that were solved and closed by a different employee. Thank you in advance!

hello, I'm trying to analyze the changes on the delivery headers (LIKP) but I wanna filter a specific plant. When I try to creat an OLAP table with the changes and the plant (LIKP.VSTEL) I get the following error message:"No common table could be found. The tables ["_CEL_O2C_ACTIVITIES"] and ["LIKP"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [_CEL_O2C_ACTIVITIES]N <-- 1![VBAP]!1 --> N[VBFA]N <-- 1[LIPS]N <-- 1[LIKP]. For more information on the join path, search for "Join functionality" in PQL documentation.", Does anyone know how to join these two tables ?Thank you!

Hello, In the analysis view, I would like to multiply a set of values with a random operator similar to RAND() in excel however I cannot find anything like this in the documentation. Does anyone know if there is such an operator ?Thank you

Hello, I'm trying to know how many different Materials I have inside a shipment. This shipment can have multiple DNs, when I try to create an OLAP table with Shipment Nº/Delivery No./ Material I get the following error: "No common table could be found. The tables ["VTTP"] and ["LIPS"] are connected but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [VTTP]N <-- 1![LIKP]!1 --> N[LIPS]. For more information on the join path, search for "Join functionality" in PQL documentation.". How can I solve this issue? Thank you

【FY23​ Partner Award 発表】先日のCeloPEG Summit #2に於いて、FY23のPartner Awardを発表させていただきました。詳細は先ほど共有させていただいた資料にもありますが、受賞された各社をご紹介させていただきます。​■Market Performance New Logo 部門 (Market Performance 2)1位 日本アイ・ビー・エム株式会社2位 アクセンチュア株式会社3位 アビームコンサルティング株式会社​■Market Performance Sales ACV 部門(Market Performance 1)1位 アクセンチュア株式会社2位 日本アイ・ビー・エム株式会社3位 株式会社システムサポート​■Project Delivery 部門1位 アビームコンサルティング株式会社2位 株式会社システムサポート3位 伊藤忠テクノソリューションズ株式会社​■Certification 部門1位 アクセンチュア株式会社2位 日本アイ・ビー・エム株式会社3位 アビームコンサルティング株式会社​■CeloPEG FY23 Award Trip 受賞者アクセンチュア株式会社Market Performance 部門 Sales ACV 2位Market Performance New Logo 部門 1位Certification 部門 1位​ 日本アイ・ビー・エム株式会社Market Performance 部門 Sales ACV 1位Market Performance New Logo 部門 ２位Certification

I am doing Accounts Payable Case Study ( Celonis DB and CASESTUDY schema). It looks like the CPUTM column in BKPF and UTIME column in CDHDR tables are not correct. When I load the activities in Process Explorer, flow goes in all directions. Please help.Data in the CPUTM column in BKPF and UTIME column in CDHDR tables are '11/13/2018'. So the flow seems to be incorrect. Please clarify. Thanks!

I would like to add a column to the OLAP table that lists the number of processes that go through a particular activity and the number of processes that do not go through a particular activity. How do I code a PQL that calculates the number of processes that go through a particular activity A?

I would like to create an OLAP table containing the following KPIs.Could you please provide me with the formulas for the following four PQLs? Number of cases passing through a particular activityNumber of cases that do not pass a specific activityThe number of cases coming from a specific activity to a specific activityThe number of cases that go from a specific activity to a specific activity

Hello, i trying to check if a item on a delivery note was created manually or by a bot. however my lips table is not retrieving data from deliveries that are not LF (final product) or LR(Returns) leaving out in house transfers that appear on SAP.

I have created dropdown but unable to build or cant find any option where I build select all checkbox.

【Celonis for Sustainability Transformation Webinarのお知らせ】以前からご案内しております英語での開催の技術セミナーですが、直近ではSastanability Transformatioについてご案内します。お申し込みは下記のリンクより行えますので、ご興味のある方はぜひご参加ください。​https://academy.celonis.com/courses/celonis-for-sustainability-transformation​開催日程：3月29日 10PM(JST)アジェンダ：1. The Celonis sustainability approach2. Sustainability use cases and apps, including demo3. How to get started with sustainability4. Q&A.​​内容は英語でのご案内になります。​

Hi all, My interest is to calculate the THROUGH PUT time for all the desired set of process flows. I would like to view the distribution over a BOX PLOT. I am using the below approach.CASE WHEN PROCESS EQUALS 'event A' TO ANY TO 'eventB' then 'Process1'WHEN PROCESS EQUALS 'event B' TO ANY TO 'eventC' then 'Process2'ENDThe above formula will act as dimension axis for my box plot. I am calculating the tp time accordingly. However, since most of my cases(for e.x. 97%) satisfy the first condition, i cannot seem to calculate the tp time independently for other event or process correctly. The tp is calculated only for the remaining cases.Kindly suggest any other approach for the same. Thank you in advance :)

any function used in pql to calculate days between the two date column such as in excel networkdays does (consider start date and end date , exclude weekends, ignore timestamps)

Is there any function in PQL which calculate days such as networkdays (used in excel and it will ignore timestamps, exclude weekends ,conside start and end date )does?

hello to everyone, is there an example how action flows interact with rpa ?

Anybody has been able to use KM from an Analysis?  I am trying but, although I can use any KPI defined in the KM, I can not use a Record from an Analysis (i.e. in a OLAP table)

How can we create second Process Explorer in my Analysis?

Are there any experience reports from the connection of the Data Warehouse to Celonis?I want to connect the data warehouse and still have some questions about the concept. Have you created an intermediate database and duplicated the required tables? Or did you let Celonis access the entire data warehouse directly? I would be pleased if suggestions were made here, taking data security into account. 

I want to complete the elective course Data Integration Case Study - Accounts Payable inside Get Data into the EMS, but I have some problem at the step Transform - Add an Activity: Enter Invoice in SAP. No problems when I write the code with the INNER JOIN, but I'm not able to run the code whit clause WHERE EXISTS. In attachment you can find both codes. The "WHERE EXISTS" code returns the following error:Execution error: ERROR: Missing FROM-clause entry for table "BKPF". Where I'm wrong? I tried to follow the syntax reported in the Get Data into the EMS course but I'm in a dead end. Thanks in advance.

Hi, If a Data Job fails, then an email has to sent to a DL (which contains 10 emails) - Is this possible? I don't see an option for it. All I could see is 'Enable Alerts' in the Data Job Settings, but it will send an email only to me. Any Thoughts?

I was thinking of reading all the fields of the table and then performing a group by. Is this the right way?

I'm doing a date change analysis to understand how many days a sales order delivery date is changed up or out. I have the change from and change to dates. Anyone know of a way to incorporate the day of week? Ex, changed from monday to tuesday?

Iam trying to find out or compare RC vs Delt job vs Full Load, when to use and why

How many characters are supported for naming convention for any object in Studio? For example if I am naming a ID for a KPI, how long can I keep the name? Do we have a constraint in that?