General Q&A - TO REMOVE

Hi, a customer of mine is looking for working instructions for CoE team members. Has anybody any experience with that or even some examples?Thanks

I have to create a date filter (which should be a dropdown), that only filter the components in that particular sheet. I think this can be done using a sheet filter by setting a variable using a button dropdown. The problem is that the date is in DateTime format, and it writes to the variable like this : "Sun Jan 03 2016 05:30:00 GMT+0530 (India Standard Time)", I am new to pql and I don't know how to convert it into a proper format so that it can be used with FILTER statement in load script. Please help me out.

I'd like to restore an analysis I have done in the past using Celonis. I have exported json file, but I don't know how to import the file into Celonis. Could you please give me instructions?

Could you please tell me how to create bar chart in celonis studio?

Ready to seize unlimited opportunities?Visit the EMS Marketplace from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners.Visit the EMS Marketplace or find your team. Recently Added: IBM work order management for manufacturing IndustryWork Order Management application provides an operational dashboard to monitor, plan and streamline the end to end lifecycle of a work order, Identifying bottlenecks and processing differences based on various dimensions for continuous improvement and faster lead times, digitally transforming the work order process to improve data quality and reporting & providing automation for faster fixes. IBM record to analyze month end close:

Hi,  I am trying to display the time difference in days on the 2nd column between each task on the 1st column (which is shown in the process flow explorer already) but I would like it in a table format.  So instead of giving me the overall throughput time from process start to end, is it possible to get the days between tasks? This can be seen below: 

Can we create Boxplot in View ?

Problem: In the dataset I am working with, a mistaken batch process in the source system added extra timestamps which are throwing off throughput times.  Objective: My objective is to map to null all activities in my activity table which are repeated back to back. Example: In the simplified table below, I would want the final activity to map to null since it is a repeated activity "c" of the same work order "3" Table = "Celonis_Remap_Practice_csv" Partial Solution:I created a custom dimension on a variant explorer with the following code: CASEWHEN   "Celonis_Remap_Practice_csv"."Activity" = ACTIVITY_LAG ("Celonis_Remap_Practice_csv"."ACTIVITY")   AND INDEX_ACTIVITY_ORDER ( &quot

If yes - can this include parallel gateways to reflect activities that can de done at the same time?

Hi, I have this pie chart and was wondering if there's a way to hide null values? (the grey area)  thanks,terence

Hello,I have manage engine skills that I created from my olap tables.Whenever some cases occurs I want to take some actions with my action flow sequence.But how do I get these datas from my skill. Celonis data query module does not confirm my needs because my query uses match activity etc.

Hello, Does there exist any existing documentation or external links that can be used to start a customer training roadmap? You have a client that you have engaged with C4C+. As expected, the client is excited with your findings, presentations and what Celonis can do. The client wants to go to the next step: purchase Celonis and start ramping up.. Is there any material, documentation or other that could be provided as a roadmap to the client to bring them up to speed so they could be adept at using Celonis? I suspect this would include Celonis Academy but what topics for what role? (before the Academy upgrade there was a good list of courses to take per client role but that is no more). thank you.Rob

Would you like happier customers 🙂 and cut costs ✂️? Join us for the next Lunch & Learn session: Maximise execution capacity in Order ManagementDate: Tuesday 29 March at 11:15am GMTLunch is on us!*  Key Takeaways:How to get happier customers, reduce rework and cut costsUsing Celonis to intelligently priorite, automate and optimize order handlingAchieving automated sales order entry with 100% accuracy Click here to book your place  *voucher availability is limited and dependent on your country of residence

Hi,adding custom KPI such as "Automation Rate" can by done in the Process Explorer of an Analysis. But this option is not available in the Process Explorer within a View. Is this by purpose? If yes, what's the intention behind it? I would like to show a low automation rate in order to use ML to automate incoming orders. Thanks!

We need to upload files of more than 1 Gb size. Is the IBC Loader that can be downloaded from GitHub recommended by Celonis? Is there any other way to upload big files? Thanks

Hi,  I am currently using this code: SUM("Sheet1"."Column1".'1' / SUM("Sheet1"."Column1") and I am essentially trying to find out how many 1s, 2s, and '-' there are, in the form of a percentage. I tried doing "Sheet1"."Column1".'1' so specific which value I am trying to calculate but I don;t think the code is correct? Thanks,Terence

Ready to seize unlimited opportunities? Visit the EMS Store from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners. Visit the EMS Store or find your team. Recently Added: Payment Behavior Advanced:Incoming invoices that are paid too early or paying dunning charges for invoices that are paid too late can lead to a considerable decrease of the liquidity. The analysis of the payment behavior and the optimization of payment based on this analysis is therefore essential for liquidity management. With this app you can analyze your Payment Blocks, see where you are not taking advantage of Cash Discounts and avoid losses due to Early/Late Payments.SAP ECC O2C Customer Scorecard Advanced:

Our jobs are running on SSMS. So we are planning to trigger Data model on Celonis after the job is completed using a shell script. I would Like to know if this is possible? Or if there is any other way to trigger the Data model after our job is done?

We have a high interest and demand in the market to use & implement Celonis for helping the clients in migrating to S/4HANA. I reviewed the frictionless system migration (S/4HANA) webinar. it was useful and insightful, it also showed how Celonis can support their clients throughout the different migration phases.  As stated, in the design phase that Celonis can help in Master data consolidation, Testing, and data transformation. but unfortunately, it wasn’t stated exactly in details how can Celonis help throughout the migration in the previously mentioned areas. Thanks in advance.

Hi Can someone please help with PQL script to calculate duplicate invoices

You're invited to a Lunch & Learn session: Sustainability | Tuesday 22 February 11:15am - 12pm GMT Topic: Learn how to apply sustainability metrics to your business Organizations are driven by processes and by making business processes more efficient, companies can remove unnecessary waste and further their sustainability efforts. Learn how to:Embed sustainability metrics within every processTrack and mitigate Co2 emissions in logisticsSystematically target waste in the supply chainAdd supplier sustainability ratings for every purchase order. Ask our expert questions live.  Lunch is on us! We’ll send you a voucher to enjoy lunch or a coffee when you register for the session.* Book now - s

Hi, I have a data table that has 3 columns: -, 0, 1with a load of data rows below them. How do I go about calculating the total percentage for each column? I would potentially want a KPI in my dashboard that immediately tells me0 = x%1 = y%- = z% thanks,Terence

Hi, the link "Please reload and link the data models as stated in this guide" leads to a protected google drive ressource and is therefore not available (I requested access with my gmail account, but nothing happened the last days)What needs to be done?Thanks in advance!

Hi all, First post here. Pleasure to meet you.  I just finished the Solution Professional Track and would like to start taking the exam soon, but one thing striked me as curious.  Except I have been missing it, VSQL was not included in the training except the "Best-Practice" module. That was like being thrown into the cold water, since I do not have a technical background. The Exam Prep mentiones SQL knowledge as prerequisite for the exam.  Since the academy does not seem to provide for a course, is there anyone who could tell me the depth which is needed to pass the exam and where I could learn that (i.e. youtube)?  Ideas would be appreciated. If someone is willing to do a personal exam prep and offers on fiverr or similar, feel free to shoot me a message. Best wishes