General Product Q&A

Winning in Accounts Payable : Value through Process Mining (November 17th, 11:00 - 12:00 CET)  Together with Lotte Schepers from Van Oord, our EMS Consultant Maxine Widemann will be talking you through Van Oord’s process mining journey within the Global Financial Shared Service Center to optimize their Accounts Payable process. What can you expect?·          How we provided transparency into the complex process of accounts payable and identified its bottlenecks and inefficiencies·          Finding the root causes of why you are not paying your invoices on time·          The importance of monitoring your invoice booking process in real-time and prioritizing payments·          How process mining can assist further teams in the Global Financial Shared Service CentersInterested to find out how you can streamline your Accounts Payable process? Then make sure to attend this webinar. Register here

Hi, is there a possibilty to filter an OLAP Table for the top 10 countries, based on e.g. sum of net order value? I think it could work with index order, but when I aggregate, I get an error message. Thanks for your help! Many greetings Lukas

Hi everyone, for O2C we want to be able to analyze the top 10 customers (based on net order value) vs the other customers. Is there a dynamic way to define/filter the top 10 customers based on the net order value?

I was checking materials such as value tree in Asset Library,Currently, I can't find materials such as value trees in the Asset Library. Where can I find the latest version of the document?

Is the Celonis approach accepted by clients? If we have to take the standard approach using COGS, is this connected to order management? The standard formula seems to combine AP with O2C. Please clarify.

 I mean the table which you call <%= unit_name_1 %> etc.

I’m trying to use filter table.column = LAST(table.column) im getting errortried taking last(table.column) in a variable to use in case when but getting error that dimension function cannot be used with aggregation function

How to convert string(format YYYYMMDDHHMMSSSS) into the timestamp(date) value using either PQL?

Is it possible to take SAP material master update detail with sale order as reference .

Currently we are using the csv module to generate the report, however it does not allow formatting of numbers and headers. We also tried to use the excel 365 module but it only allows inserting information row by row which does not allow generating a large volume of data.  

Hello Team, How to use the Line (Horizontal Rule) in Views?As there's no component available under the drop down in Create Component in Visual Editor for Line Component. Thanks!

I am trying to connect snowflake to EMS through key pair authentication but not able to success. could you please provide the solution.

Hi,I am working on a dummy data and while executing the vertica sql code, getting above error.Can anyone please help me with this.

I would like to move the contents (data models, packages) of on team to another team.Since the teams are on different clusters (eu-1 and eu-5) this does not seem to work with the regular "copy to" function. This question has already answered that this is possible with the Machine Learning Workbench.Is there another way we can do this without using the ML Workbench?Thank you!

Hi,Is there a way to use conditional formatting with icon sets, similar to what it's done in Excel? I need to replicate the RR column of the table Status X Area (last column of the picture).ThanksLDRH

Hello, I would like to know if its possible to get a count of all the flows that are in total in the whole Process explorer. (Including all reworks and cases flows). To show it in a Card.

I actually found a solution for a similar question here. Proposed was the following formula: FILTER "xx"."yy" =CASE WHEN <%=option1%> = 'a' THEN 'value'WHEN <%=option1%> = 'b' THEN 'value2'END; However, as a whole list of purchasing groups needs to be excluded instead of '=' or '!=' we would need to work with NOT IN / NOT LIKE... Meaning something like: FILTER "xx"."yy" NOT INCASE WHEN <%=option1%> = 'a' THEN ('Value1', Value2', ...)END; But somehow I don´t get the syntax, right? Can anyone help?  Thanks a lot :)  

Hello everyone,i have a small problem with the representation of activities in my Celonis. For some reason a few activities are not in order when i look at them via the Variant/Process Explorer. However, if i look into my data via SQL Vertica in the Data Jobs, the Activities are in order. I believe this, because each Activity has a sorting number (descending). Usually i would expect the Activity/Process Explorer to show me the Cases in accordance with their sorting number, however this is not the case for every activity/case. Some are Ok, but some don't fit. Is there any (easy) solution for my problem? What causes this deviation?

Dear Experts,We are planning for Celonis Task mining product demo to one of our client , We wanted to understand whether Task mining capabilities is also part of Celonis EMS product package or do we need to procure separate license to make use of celonis task mining capabilities.Thanks in Advance. Regards,Navalan Veerapandian

Dear sir. I am a student please change my categery. Acadamic

Hi ,I need a tech support here. Here is the stiation. I have cases like Case 123Activity 1 - Attribute A = XActivity 2 - Attribute A = Y Case 231Activity 1 - Attribute A = WActivity 2 - Attribute A = Z Case 321Activity 1 - Attribute A = QActivity 2 - Attribute A = X Now I need to create an olap table likeCAse 1 -Attrubute A - Case 2123 ------- X ---------321 because their both Attr. A = X right ?but how ? I think domain table is not for it.

How to remove leading zeroes from any column in OLAP table?

We need to find the best way to form a connection. How do we go about this? Would it be best to do it on-prem and download the extractor server? If so Would a JDBC connector work? But don't we need to open up access to any firewall ports if needed for that-which is a problem in our case-right? We have thought about the ServiceNow connector offered by Celonis however I think we cannot use it due to the firewall issue. Would an extractor builder work? Celoxtractor via python? What alternatives can we use?

I am looking for any information or documentation which Celonis might (could be connector, or general information advice) on developing process mining for Procurement process using data from Fusion. Any help would be appreciated. Thanks

Hi, is there a free trial version for Celonis EMS to install locally rather than a cloud instance of Celonis EMS ?