Skip to main content

General Product Q&A

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

  • 1,432 Topics
  • 3,387 Replies
1431 Topics
muthappan.alaga
Level 4
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.   

20
S
Level 1
K
Level 1
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.

00
S
Level 1
S
Level 1
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?

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?

10
abhishek.chatu14
Level 7
jonas.frisc
Level 3
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?

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?

00
jonas.frisc
Level 3
H
Level 2
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

00
H
Level 2
S
Level 2
shubhanshu.vaibh12Level 2
asked in General Product Q&A
Which Algorithm does Celonis use for Process Discovery and Conformance Checking?

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

10
G
Level 8
A
Level 3
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.

20
A
Level 3
sree.c
Level 4
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?

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

30
R
Level 4
J
Level 3
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!

60
R
Level 4
B
Level 1
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

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 things?

00
teuku.faruq13
Level 5
luis.carra12
Level 2
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!   

00
teuku.faruq13
Level 5
H
Level 1
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?

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?

00
teuku.faruq13
Level 5
W
Level 2
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. 😀

10
teuku.faruq13
Level 5
dany.moual11
Level 3
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?  

10
dany.moual11
Level 3
felixkonstantin.allgö
Level 2
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?

00
H
Level 2
michael.chung
Level 2
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

00
michael.chung
Level 2
V
Level 4
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

00
V
Level 4
frederick.coutr12
Level 3
frederick.coutr12Level 3
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

20
teuku.faruq13
Level 5
M
Level 2
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

00
B
Level 1
andres.naran12
Level 4
andres.naran12Level 4
asked in General Product Q&A
Hi guys! Is there any way to reload only updated data inside the process data model? I mean I need only the updated data supplied but the process data model always makes a full reload, deletes the old data, and leaves only the new one.

Hi guys! Is there any way to reload only updated data inside the process data model? I mean I need only the updated data supplied but the process data model always makes a full reload, deletes the old data, and leaves only the new one.

20
andres.naran12
Level 4
luis.carra12
Level 2
luis.carra12Level 2
asked in General Product Q&A
Tech info on how works the pql.PQLColumn() function of Python for Celonis?

Hi, all.  I need to know how works the pql.PQLColumn() function of Python for Celonis. Does anybody knows where is the technical documentation?  I've tried https://celonis.github.io/pycelonis/1.7.6/ , and docs.celonis.com but is not enough. In this case I need to know how to use the format argument. Thanks!   PD.I've found only this short info when hovering over the function in the VS Code editor (class) PQLColumn(query: str = None, name: str = "Unnamed column", format: str = None, sorting_index: str | int = None, sorting_direction: str = None, not_included: bool = False) A PQL Column dictionary that can be added to a PQL query statement. Behaves like dict. Corresponds to Dimension and KPI in Celonis.Args:    query: The PQL query of the column (KPI or Dimension).    name: The name of te column.    format: The formatting of the column.    sorting_index: The sorting index of the column in a table (starts at 0).    sorting_direction: The sorting direction. One of [ASC, D

40
luis.carra12
Level 2
K
Level 2
ketan.sathe11Level 2
asked in General Product Q&A
what is a difference between EMS IPs as Target and EMS IPs as source, though for whitelisting we need to give EMS IPs as target. Please refer to the image attached

00
K
Level 2
E
Level 1
edina.varga12Level 1
asked in General Product Q&A
--Business Miner--Does anyone know where can I find the Process Workspace needed for setup this new feature of Celonis? Thank you!

--Business Miner-- Does anyone know where can I find the Process Workspace needed for setup this new feature of Celonis? Thank you!

00
muthappan.alaga
Level 4
sarina.somme
Level 3
sarina.sommeLevel 3
asked in General Product Q&A
Can I create my offset in the Delta Filter Statement in the Extractions for two columns?

Hi all, I currently have the following challenge. My source table unfortunately does not have a timestamp, but has a column with the date and a column with the time. Now I would like to retrieve in my Delta Filter Statement the data that has been added or that has changed in the last 15 minutes. How can I write this in the delta filter statement?  Thank you and best regardsSarina

10
sarina.somme
Level 3
T
Level 1
thrivikram.bairaLevel 1
asked in General Product Q&A
HiRecently I started learning about Celonis tool .Already i gone through the training tracks but still i didn't get an idea and clarification how and where to we will use this tool. Can anyone help me to find the solution.

Hi Recently I started learning about Celonis tool .Already i gone through the training tracks but still i didn't get an idea and clarification how and where to we will use this tool. Can anyone help me to find the solution.

00
teuku.faruq13
Level 5

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2024