Product Q&A

Hello everyone. I am looking for anyone who might have achieved integration between Celonis and ServiceNow. The documentation provided - in my view - is not clear. What I have achieved so far:Created a user - basic authenticationCreated a custom roleAdded the rest_service, soap_query, custom role to the userCreated the ACL for the sys_db_object and incident table (filtering on the assignment group) and attached the custom role.Successfully connected between celonis and ServiceNow However, I receive the following error message when a full load is executed:  Any insights or help as to what is missing? FYI - i am no Celonis administrator - anything Celonis related tasks, I have someone within my team that is executing those Celonis tasks. Thank you.

 Hey guys, I would like to transform the access user in Celonis (user.celonis@outlook.com) into just the name. Example: User Celonis I looked in the PQL documentation but I couldn't find it.I looked in the PQL documentation but I couldn't find it.

Hello all, I would like to send an xlsx file as an e-mail attachment. The file is generated by a Python script in ML Workbench. Due to the formatting of the xlsx file, it is not possible to load this file into the data model without further ado. Is it still possible to send the file automatically, e.g. via an action flow or skill?  Best regardsChristoph 

Is there any way to download PDF report on views? ( Action Flow or Skill)

Hi,  I have stumbled upon an warning message that states "The join between table "_CEL_P2P_CASES_6" and table "_CEL_P2P_ACTIVITIES_6" did not find any matching rows."  Prior to this warning message, I have assigned the activities and case table respectively as well as assigned their foreign key, "Case_ID".  Is there a way to fix this error message?

Action Flow to Update a Augument Attribute Error: Validation failed for 1 parameter I would like get an Augument Attributes from an Excel file using an Action Flow. So, I tried the following steps: 1. Creating a record called “Clientes Comercial” and created a Augument Attribute called “Gestor” in the Knowledge Model. Attached 1 – Record: “Clientes Comercial” Attached 2 – Augument Attribute: “Gestor” 2. Creating an action flow called “carga executivo e adm de vendas”:2.a. Creating a of Microsoft 365 Excel component - List Worksheet Rows and set it to get the data in a sharepoint address. Attached 3 - Microsoft 365 Excel component - List Worksheet Rows2.b. Creating a Celonis Component – Update Augumented Attribute and set to update Attached 4 - Celonis Component – Update Augumented 3. When I run the action flow, I got the following error: Validation failed for 1 parameter(s). Attached 5 - Validation failed for 1 parameter(s)But both, Excel value and Augumented Attributed was

Hi, I need to create a table with the infos related to activities linked to a given activity.It's like a Process Explorer but in table form, where the user selects an activity and the table provides infos (name and other columns) related to the activities linked to the selected one. Is there a PQL statement that allows me to do so?

For Power BI, I've failed to find any information about how to do it.

How can we get access to Training Analytics Tab in Celonis?

How can I schedule a Action Flow?

In the Celonis Academy training environment, there is no configuration screen for scheduling event triggers. Is it possible to check in the training environment?

How to schedule a syncronization of data? I have some tables on another connection, from SAP Ariba (Purchase Requisition e Sourcing)We use some of these tables on data model on P2PSo I need to run detal load every day on all jobs.How can I syncronize automatically data from another connections, once when scheduling I only found the option to do it manually?Thanks

@Vildan Aslan​ @emre.karad​ 

Hello Celopeers, I have built KPI dashboards and doing some analysis on process explorer. Manually going through analysis. Heard Process AI will automatically detects deviations and find root causes.  Need to deep drive. if any one knows the link from learning portal pls suggest.   

Hi,Im trying to add a table from Datapool to datamodel and i found this function, add_table_from_pool in the release notes of 1.5Now when i try its not present. Is this deprecated?If so, are there any alternatives?Please let me know. Now the error: 

I have multiple values (20 of them) for example orders which I need to insert into filter, but after entering and confirming it, the filter is not applied. I tried to even change format in excel to number before, but still not working.

hi all, Now I'm trying to update data connector and dashboard to latest version.(I found some difference between my celonis version and latest O2C asset.) In one time upload case, do I need to create celonis at first: I mean, add data connector, upload data and add dashboard? or do we have a way to add something patch to my old celonis environment? Thanks and regards, 

Basics of Process Mining

Hello, I have an activity "OCH_Activities". "Source_Queue_TXT" and "OCH_Activities". "Target_Queue_TXT".I want if source and target are the same, that I get the value 1 for example.I have already tried COUNT( CASE WHEN "OCH_Activities". "Source_Queue_TXT" = "OCH_Activities". "Target_Queue_TXT" THEN 1 ELSE 0 END)but this does not compare the two activities. What would be the correct approach here.Thanks

Dear Celopeers, we are connectiing Celonis with a Salesforce production environment using the standard Celonis Extractors/Process Connectors. This connector, as stated on the Celonis documentation, uses Rest API. Using rest API impacts the limit of concurrent calls that the platform can support (25 in parallel with a maximum duration of 20 seconds). This means that the Celonis connector competes with calls from other applications causing possible service interruptions. Is there any option within Celonis extractor/connector to set API limits and ensure that extractions do not have a negative impact on the productive Salesforce system performance? Or, can such API limits be set only within Salesforce?

I have requirement , user wishes to upload some excel files downloaded from external tool till integration is well established. What can we do so that User can place the file in one fixed folder and Celonis can upload on regular interval like monthly. Can you please guide me here ?

I have a category table, table2 and Activity tablerelation is category(N) - table2(1) - Activity(N)in a bar chart, I want to show group from category table and count of activities for each group. I’m getting no common table error while configuring a component.how to fix this for a relationship N:1:N 

I’m using Knowledge models & Views for this requirement.I’m trying to create use the option as shown in the attached image file.I’m able to add onClick to the Kpi list component in view,but not understanding how this can be used to update a different component.Thank you

Hi All, I am facing an issue while uploading data to Celonis. My transformations are working fine but it fails at the data model load stage with the following error: "The Data Model Load experienced an issue with the Data Pipeline Orchestrator." Has anyone faced this issue before or knows of a solution to fix this. Thanks,Dhruv