- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

1,413 Topics
3,352 Replies

When you subscribe we will email you when there is a new topic in this category

1413 Topics

Recently active

Most replies Most views Newest first

sushmith.dechaLevel 3

asked in General Product Q&A

Is there a possibility for us to connect Microsoft Sharepoint online module with Celonis?

217

1 year ago

oliver.köhneLevel 3

asked in General Product Q&A

Task Mining Google Chrome Extension Console Error: "Uncaught TypeError: Cannot read properties of undefined (reading 'forEach')".

Hi, I created a project using the Task Mining Workforce Productivity Quickstart and ran an initial trial to capture data. Everything worked fine. Since the second run to capture data, the error message noted in the question and screenshot appears in the browser console every time an event is supposed to be triggered to be captured by the Chrome extension.This means that events such as element changed are not recorded, even though they should be recorded by configuration.Reinstalling the extension and restarting the project did nothing.

113

1 year ago

sree.cLevel 4

asked in General Product Q&A

How to push a csv file to data pool as a table in global scope?

1 year ago

pavan.bhara13Level 3

asked in General Product Q&A

Is there a way to hide the Marketplace, Action Engine, Process analytics and other unused options for "Member" Access in Business apps?

1 year ago

preethi.p12Level 4

asked in General Product Q&A

How to dynamically set a value in chart title instead of using a textbox component in view?

I want the value to be update after every load and it has to be dynamic.I can consider the value field in textbox component.But I’m trying to figure out if this can be done in chart title itself in a view

1 year ago

sanghyeok.kwakLevel 3

asked in General Product Q&A

Can't use data integration in snap account?

I mainly use the training account, but I'm trying to upload a csv file to test on the snap account, but data integration doesn't work. I have to use the quick starter to upload the data. I wonder if there is something I missed.My account is an administrator and I am registered as a member alone in snap.

1 year ago

muthappan.alagaLevel 4

asked in General Product Q&A

Have anybody worked on Extracting XLSX file from sharepoint and pushed to celonis using action flow?

i am able to extract the xlsx file, but i am not sure about the next steps on pushing it to celonis database. i am able to do a csv file using standard template by converting it to json. but how to do xlsx file.

1 year ago

kiran.ramkr16Level 1

asked in General Product Q&A

What is the alternative for backup_content() function in PyCelonis 2.0+?

We have implemented a version control mechanism for data transformations using backup_content() function. The newer version of PyCelonis does not seem to support this function. Is there an alternative to this function in the lastest version of PyCelonis? Thank you.

1 year ago

sebastian.darenLevel 1

asked in General Product Q&A

Hello - I'm trying to set up Workforce Productivity as part of the Task Mining learning track but getting a msg telling me to contact my Customer Value Mgr or submit a support ticket. (See screenshot below)Can you please advise?

1 year ago

jonas.friscLevel 3

asked in General Product Q&A

Is it possible to go back continuously one year from the current date in the StartDate parameter. So that only the past year is in the system?

1 year ago

harmeet.singh12Level 2

asked in General Product Q&A

How to connect Smartsheets with Celonis?

Hello together, i am trying to connect Smartsheet with Celonis. I already have a Client ID and Client Secret for Smartsheet but everytime I try to connect both, Celonis/Smartsheets opens a new tab showing an error saying Redirect URI ist missing or wrong. Does anyone know what to fill out in the Developer Settings of Smartsheets in the field APP URL & APP redirect URL ? I have filled in an APP URL (something like https.//xyz.celonis.cloud/package-manager/ui/studio/ui/assets/xxxyyy-11-123) and an APP redirect URL (https://app.smartsheet.com/b/autorize?form.....) and every other mixture of URLs but nothing seems to work out. I have also reviewed various Celonis / Smartsheet Docs but found no answer until now. Thanks in advance

1 year ago

shubhanshu.vaibh12Level 2

asked in General Product Q&A

Which Algorithm does Celonis use for Process Discovery and Conformance Checking?

1 year ago

andré.linkLevel 3

asked in General Product Q&A

How can I calculate the Share of Product Type for each Delivery Number?In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of

How can I calculate the Share of Product Type for each Delivery Number? In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of result.

1 year ago

sree.cLevel 4

asked in General Product Q&A

How to enable Action flow to execute the skill only if we have records from query data?

1 year ago

jurgen.gakovLevel 3

asked in General Product Q&A

Execute an Action Flow automatically with a Skill triggered by new data within in Action Engine

Hello togheter, currenty im trying to set up an action flow which is triggered by new Data in an Action Engine. I read that this can be done via a Skill. The Action Flow starts by using a custom webhook and then quering data from Celonis. For the skill, i first set up an Action Engine Sensor and secondly an "Execute Action Flow" command. Within the Action Engine i filtered the data for the data im looking. Currently I am facing the problem that if I delete all manual inputs in the 2 commands of the skill the skill seems to trigger the action flow but the custom webhook component within the action flow doesnt receive any data. Based on this if I want to put data into the webhook it will be done manually, which is not the point of the aciton engine. So my question is: how can i set up all these components that the skill, based on new data in an action engine, only triggers a action flow without trying to provide data to the action flow? Is that possible? Thank you very much!

1 year ago

bert.scheeLevel 1

asked in General Product Q&A

I've set up a weekday calander in Process Data Models that consist only of the working days (Monday-Friday, all day). Unfortunately in the Process Explorer, Case Explorer etc. the througput times aren't adjusted. Do I have to set up additional t

1 year ago

luis.carra12Level 2

asked in General Product Q&A

Error in the eventtime of the activity table after copying data between teams using pycelonis

Hi, all.I've followed all the steps to copy (pull+push) data between two teams that are detailed in the documentation in pycelonis: https://celonis.github.io/pycelonis/1.7.6/tutorials/api_tutorial The transfer of data is ok but when I process the data model in the target team I get the next error: The load failed: Load failed. Error Message: Timestamp column ["_CEL_SF_CASE_ACTIVITIES"."EVENTTIME"] of activity table ["_CEL_SF_CASE_ACTIVITIES"] must be of type DATE, but got [INT]. It seems that the "push" loads the eventtime data as INT type instead of date time type.An example: the time stamp 15/11/2022 12:02:00 of the source tabla is loaded as 1668681300000000 in the target table. I've checked the source data when extracted in the pandas dataframe before uploading it ot the target table and it's OK.I've checked the data once loaded and it's NOT OK. Any help?? Thanks!

1 year ago

hiroaki.mori11Level 1

asked in General Product Q&A

Regular expressions use ^ as the starting metacharacter and $ as the ending metacharacter, but Celonis doesn't support end-of-line metacharacters. What are end-of-line metacharacters?

1 year ago

willem.van.d11Level 2

asked in General Product Q&A

Pivot Table Columns Order Changeable?Hello fellow Celopeers,I was wondering if there is any function to change the order of the columns in a Pivot Table.

I've looked in the documentation library but it didn't show me the options I'm looking for. I found the option underneath the 'Configure' button which allows me to change the ascending or descending order. If anyone knows more please let me know :) Else I'll make it work with the descending order changes. Thanks in advance for your time. 😀

1 year ago

dany.moual11Level 3

asked in General Product Q&A

How to update Augmented attributes through skills in the O2C and P2P value discovery app on EU-1 cloud project?

Hello, While framing some value which the Value Discovery App, I realized that the Inefficiency Augmented table are not getting actuallized, neither for O2C, nor for P2P on EU-1 cloud, although it works well on EU-3. While digging More, I realized that the Update Augmented Atribute Skill is not availble as shown in the following image. How could I fix the issue snd have the value discovery app working properly?

1 year ago

felixkonstantin.allgöLevel 2

asked in General Product Q&A

I have two activity tables and would like to select the one for the Throughput Time Search Component which is a type of Process Analysis Components.

Ín the documentation for the settings of such components it states in point 5 of the Throughput Time Search section that you can select the activity node and it refers to the selection of the Background Options which unfortunately does not offer the functionality? For the Variant Explorer there is a selection for the process nodes where you can set a custom dimension. Is this also possible for the Throughput Time Search Component or is there a workaround?

1 year ago

michael.chungLevel 2

asked in General Product Q&A

How to get average of record count for 90 day period

Hi All,I need some PQL coding help. I want to get a flat (or mostly flat) averge line for a 90 day period, but am not quite sure what I am missing. output table format:[created date] [id count] [90 day avg of id count] 90 day Avg (PQL):PU_COUNT(DOMAIN_TABLE("Account"."AccountNumber"), "Account"."Id", (CASE WHEN ROUND_DAY("Account"."CreatedDate") BETWEEN ROUND_DAY(TODAY()) AND ROUND_DAY(ADD_DAYS ( ROUND_DAY(TODAY()), -90)) THEN 1.0 ELSE 0.0 END) = 1) /90 Any suggestions on what to adjust?Thank you

1 year ago

vasco.caron11Level 4

asked in General Product Q&A

Unreliable Filter Extractions when using a mix of ANDs and ORs

Like the title says, I'm trying to filter a BSEG extraction as follows: (KOART = 'K' OR BUZID = 'Z' OR EBELN IS NOT NULL) AND (AUGDT >= <%=startDate%> OR AUGDT IS NULL) In English:One or more of the following 3 must be true:Account Type (KOART) = 'K'Line ID (BUZID) = 'Z'PO Number (EBELN) IS NOT NULLAND, One of the following 2 must be true:Clearing Date (AUGDT)>= 2021.01.01 (startDate parameter)Clearing Date (AUGDT) IS NULL Screenshot: However, when looking at the data, I'm not getting any cases where Clearing Date (AUGDT) is nullWhereas, in a previous extraction that omitted AUGDT as a filter field, we have 50K+ Cases with a NULL AUGDT Field, and adhering to the other Filtering Conditions: Therefore I can only assume that there is something wrong with the way that the filtering works.....that OR should always include cases with a NULL AUGDT. Not being able to use AUGDT as a filter is causing me to have to extract a gigantic amount of

1 year ago

frederick.coutr12Level 2

asked in General Product Q&A

Which firewall rules are required for the on-premise extractor to reach the EMS ?

We are installing a Celonis extrator on a internal network and firewall rules must be configured in order to reach the EMS. Address "p-s-business-process-management-ciussse-chus-c4c.us-1.celonis.cloud" on port 443 has been opened as mentionned in the Celonis doc but it looks like authentication also tries to access https://id.celonis.cloud.Can you please provide the precise rules that need to be opened (from Extractor to EMS)? Thank you,Frédérick

1 year ago

mohamed.amer13Level 2

asked in General Product Q&A

Hi All,is there anyone having documentation for MS Dynamics on-premise?thanks

Hi All, is there anyone having documentation for MS Dynamics on-premise? thanks

1 year ago

Page 33 / 57

Badge winners

kohei.kadowhas earned the badge Masterclass in Implementation
gaurav.shekh12has earned the badge Celonis Certified Data Engineer
aravanan.maniv12has earned the badge Qualified to Write PQL Queries
camilla.damashas earned the badge Value Realization Expert
camilla.damashas earned the badge Qualified to Create and Deliver Demos

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook