Skip to main content

Solved

341 Topics
M
Level 3
miriam.luttrLevel 3
asked in General Product Q&A
Why do our Delta Loads take more time than our Full Loads?

Good afternoon everyone, We've been looking at our Delta Loads and Full Loads runtimes to try and optimize our Data Consumption and we've noticed that the Delta Loads always take more time than the Full Loads. Is there a reason for this? Is there something we can do to have them be faster? In the below Image you can see some examples of /COCKPIT/THDRV and CDPOS tables which are quite large  Please advise Thank you in advance for your support

39
A
3 years ago
A
Anonymous
asked in General Product Q&A
Execution error: ERROR: Execution time exceeded run time cap of 00:20

Hi there, I am getting a run time error creating a table and I am wondering if this concerns only the editor or also a scheduled transformation job?  Kind regards,Sasa  

12
gabriel.okaba11
Level 2
3 years ago
A
Anonymous
asked in General Q&A
Is it possible to have the data set of the demos on TryCelonis?

Hi All, may I know is it possible to get the data set used in the Procurement TryCelonis Demo? That will be really helpful when we let our users to know what exactly they may need to provide in order to perform process mining. Thank you!

23
gabriel.okaba11
Level 2
3 years ago
M
Level 3
miriam.luttrLevel 3
asked in Process Analysis
Action Engine Migration to Studio Skills

Hello, We are currently in the midst of migrating all our Analyses and Action Engines to Studio. Celonis provided with a functionality to seamlessly migrate the analyses to Studio. Is there an easy way to migrate Action Engine Skills to Skills within Studio?  Thanks

08
M
Level 3
3 years ago
D
Level 3
daniel.diers12Level 3
asked in Data Ingestion & Infrastructure
Data Service Link to OneDrive with variable Purchase Order

Hi all, I try to add a data service link to a OneDrive folder automatically searching for the PO number. SO I've did the following:Created normal variable "PO": "EKPO"."EBELN"Added data service link to an OLAP table with: OneDrive Link...414D1&view=7&q=<=%PO%> (so added the variable add the end to search for that problem: Opens OneDrice and searches for "EKPO"."EBELN" as text but not the Purchase Order number When I use a static variable then it is searching for a Purchase Order number, but not the right one, it is a static one. How is it possible to search for the Purchase Order number for that line in the OLAP table? Thx and brDaniel 

111
K
Level 1
3 years ago
A
Anonymous
asked in General Q&A
Can customer auditors, IT security team members and others get a copy of the SOC2 audit?

This question is being asked because it is one of the requirements in a university medical center RFP for Celonis-like services. Thanks! 

05
K
Level 1
3 years ago
C
Level 3
cristina.oyamaLevel 3
asked in General Product Q&A
Does anyone have ever heard about Celonis integration to Bold 360(Service now chatbots) ? I was asked by a customer and they want to understand better the end-user flow from automated answers to real agent chats.

Genesys Bold 360 is the Service Now chatbot

24
C
Level 3
3 years ago
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
Empty Excel cels break import in CPM46

Hi all, Im prepping some data in Python (pandas data frames) where certain columns dont have a value for each row, e.g. are NULL or NaN for integers and floats. However, when writing the dataframe as Excel file and then loading this into Celonis CPM46 I get the error as below. When writing as CSV I do not get this error on the same data, but the files are far larger and therefore take longer to upload (working from home ) Any idea or tips how to handle this? image865226 13.2 KB

12
joos.buijs
Level 6
3 years ago
A
Anonymous
asked in General Q&A
DAYS_BETWEEN

I have an activity (Claim Denial,) here I'm trying get the count of activities got paid after the Claim Denial,. payment happened before Denial and after denial as well, but I need to consider the first payment made after the Denial,  it can be many payment as well and payment activities we have 5 different type. also payment span should be >= 60. days between(First Denial date , first payment date(after the denial)>=60payment A- 01/01/2021Denial- 02/01/2021Payment B-03/01/2021 PU_FIRST works for First Denial but for Payment if we use PU_FIRST it will look for the Payment A but it should take Payment B date

08
gabriel.okaba11
Level 2
3 years ago
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
Number of open tasks over time

Hi all,I would like to build a chart which shows the number of open activities at a given day.In our data activities are a combination of a task (e.g. modelling or testing), and a (lifecycle) status (e.g. new, in progress, done, rejected). I would like to plot per day the number of open tasks/activities of a certain type.I currently have the activity timestamp aggregated to day as DIMENSION, and the following KPI:MOVING_COUNT_DISTINCT(CASE WHENMATCH_ACTIVITIES(NODE[Testing - In progress] , EXCLUDING[Testing - Done, Testing - Rejected] ) = 1THEN L33_V_MBD_INZICHTEN_STATUS.FEATUREAPGIDELSE NULLEND,-999,0)In (my?) theory this should use the activities up until the day, and then determine whether the case contains an open testing task or not. However, my current result is incorrect:image1223594 18.2 KBWhich trick am I missing?BTW: were on CPM4.6Happy holidays!

13
K
Level 1
3 years ago
S
Level 2
stephen.humphLevel 2
asked in Process Analysis
How can I calculate the total time a case spends in a particular set of states

We have a ServiceNow analysis and the business would like to know how long tickets are spending in a series of states. We are trying to analyse if we are putting calls on hold for too long. We are looking to do two things. For any set of tickets give me the total time this ticket has spent in a particular activity. So the event time of this activity until the next activity. The ticket may be in this state more than once through it's process journey. There are more than one of these states. Report on any tickets that have exceeded a specific threshold of time in one of these states. So the flow might go Ticket Created - Time 1Ticket On Hold - Time 2Ticket Active - Time 3Ticket On Hold - Time 4Ticket Active - Time 5Ticket Resolved - Time 6 I'm looking for the total time between Time 2 & Time 3 added to the time between Time 4 and Time 5. I cannot see a way to do this. Any ideas greatly appreciated.  

26
S
Level 2
3 years ago
A
Anonymous
asked in General Product Q&A
Basic sql behaviour, getting cases with changes in NETPR

Hi there,I am getting this strange behaviour and was wondering if somebody can explain this?I want to create an activity for when NETPR in CDPOS changed to 0 but when I look for 0s the table is empty. Query 1: My first entry happens to be a case that I am looking for.    SELECT DISTINCT FNAME,VALUE_NEW from CDPOS    WHERE FNAME = 'NETPR'   ORDER BY VALUE_NEW   LIMIT 1    FNAME  VALUE_NEW   NETPR  0.00 Query 2: But I get an empty table when I use these conditions.     SELECT DISTINCT FNAME,VALUE_NEW    FROM CDPOS    WHERE FNAME = 'NETPR' AND VALUE_NEW = '0.00'    FNAME  VALUE_NEW   - Next I wanted to see if my VALUE_NEW = '0.00' might be wrong somehow.    Why do I get different smallest values '0.000' and '0.00' from query 3 and query 4 respectively? Query 3   SELECT DISTINCT VALUE_NEW from CDPOS   ORDER BY VALUE_NEW     VALUE_NEW    0.000    1.000 Query 4   SELECT DISTINCT FNAME, VALUE_NEW   FROM CDPOS   WHERE FNAME = 'NETPR'  ORD

18
A
3 years ago
P
Level 2
pritam.roy19Level 2
asked in General Q&A
In the Process Explorer, throughput time other than (Median, Avg, and Trimmed mean) can we get the sum of the time in that group

Hello All, Is there any way to get the sum of the Throughput time other than what is there. For example want to group by with some activities, the throughput only available for the avg, median and mean. If we can get the sum of the same. 

12
R
Level 4
3 years ago
V
Level 4
vasco.caron11Level 4
asked in Process Analysis
Is it possible to cancel a Studio Skill's Ongoing / Queued Executions?

Like the Title says, I have 18 Queued Executions of a Studio Skill that have been pending for 30m Here is a picture of the flow: Does anyone know how I can cancel / restart?It was running fine when I had just a couple of columns being written to the table, I've since added a number of columns and changed the Table Name  Thank you in advance!

12
V
Level 4
3 years ago
J
Level 4
javier.donosLevel 4
asked in General Q&A
Hey Celonis world. I am trying to follow the Assistant Guided tour, but sometime it jumps and restart. is there some docs where we can do the exercises without following the assistant?Thks in advance

Hey Celonis world. I am trying to follow the Assistant Guided tour, but sometime it jumps and restart. is there some docs where we can do the exercises without following the assistant? Thks in advance

02
J
Level 4
3 years ago
M
Level 3
mateusz.dudek11Level 3
asked in General Product Q&A
Hello, I've tried to create new data model for one of our clients in On-Premise Celonis version 4.6.1. Sadly i've got error when loading data, could you advice how to oaccess logs? Manual (CPM4/Exceptions) is unavailable.

23
M
Level 3
3 years ago
A
Level 3
aram.wLevel 3
asked in General Product Q&A
How to show sums above value X and 0 otherwise

Hi, I want to add a column to an OLAP table that shows whether all orders from a given supplier exceed the value of 100 or not. So the final table should show a supplier name, the number of orders, the net worth of orders and either: The net worth value sum if its above 100, else 0An 'x' when the sum of orders exceeds 100 Also, it would be great to see how many single orders exceeded the value of 100. I was trying around for a while with PULL functions and CASE WHEN but I can't seem to make it work with the restriction of '> 100'. For example the query below gives me an error message stating that CASE is not compatible with FLOAT and INT. SUM(CASE WHEN "EKPO"."NETWR_CONVERTED" > 100THEN "EKPO"."NETWR_CONVERTED"ELSE 0END) Thank you very much in advance. Best regardsAram

01
A
3 years ago
L
Level 3
luis.magalLevel 3
asked in General Product Q&A
Is it possible to compare one row with another in an OLAP Table or other element?

The logic is as follows:if a category repeats (like C1), then:for each category, calculate the date difference (DATEDIFF) between "closed at" date of a row with "closed" status and the "opened at" date of the rows with an "open" status. The objective is to have an extra column to the right, with these values:Difference (in days)18 (DATEDIFF(dd,17.09.2021,30.08.2021)16 (DATEDIFF(dd,15.09.2021,30.08.2021)N/A (because its status is closed)N/A (because the category doesn't repeat)N/A (because the category doesn't repeat) Suggestions?

02
L
Level 3
3 years ago
G
Level 3
guilherme.luz11Level 3
asked in General Q&A
Fix mistake in data upload with Float number

Hello all, I'm enrolling Celonis Summer School and almost in the end of the analysis I noticed that I made mistake at the beggining while uploading "_APX_WDCRP_CASES.csv. Basically in "event collection" »» "File uploads" »» "Decimal Operator", I didn't change "." to "," and so the program is not recognizing the numbers as decimals.  As I'm having my first steps with Celonis, can anyone let me know if this is possible to fix without need of making the analysis from scratch?? Thank you for your kind.Guilherme Luz

02
G
Level 3
3 years ago
G
Level 3
guilherme.luz11Level 3
asked in Data Ingestion & Infrastructure
"SUM IF" in PQL language

Hi all, I'm currently enrolling Celonis Summer School and I have no experience on PQL neither SQL languages, so I please ask your help. I am trying to write something like a "SUM IF" expression. Basically, when column "_APX_WDCRP_CASES_csv"."ORDER_DATE_MET" = 0, I want to sum "_APX_WDCRP_CASES_csv"."ORDERED_QUANTITY" values.  I already tried to mix CASE WHEN function with SUM but I was not succeeded. I also searched for other functions related with aggregation but could not find one that applied. Many thanks!Guilherme Luz

05
.
Level 4
3 years ago
.
Level 4
.146001171Level 4
asked in General Product Q&A
What kind of algorithms does Process Analytics use for discovery and conformance?

As we know, Process Mining has the tremendous advantage of providing an objective and realistic view on the processes, as opposed to the traditional BPM analysis, which is very dependent on human judgement and prone to bias.However, building a process model from an event log is not a straightforward task. It requires an algorithm, and algorithms are based on assumptions have to somehow deal with things like noise. Conformance checking can also be done in different ways. Therefore, to better understand my results, I would be very interested in learning the algorithms used by Celonis. Thanks!

24
.
Level 4
3 years ago
L
Level 3
luis.magalLevel 3
asked in Data Ingestion & Infrastructure
How to apply Conditions to Filters?

Example: CASE WHEN YEAR("X"."y") >= 2019 THEN FILTER ROUND_DAY("X"."y") != ROUND_DAY("A"."b") OR ROUND_DAY("X"."y") != ROUND_DAY("M"."n")OR ROUND_DAY("A"."b") != ROUND_DAY("M"."n") ELSE FILTER ROUND_DAY("A"."b") != 2019-01-01 OR ROUND_DAY("M"."n") != 2019-01-01 END Neither CASE WHEN nor IF worked for me. I'm trying in a Component Filter, though a solution on a Sheet level could also solve my problem.

23
joos.buijs
Level 6
3 years ago
.
Level 2
.146001165Level 2
asked in General Product Q&A
Search for spezific Activity

Hello all,I'm looking for a way to search for certain activities without having to show all the variations and then read over them with my eye. An example from P2P process:I search "Delete Purchase Order Item". But I don't know from which variant it becomes visible in the explorer. How can I search/find something like that? 

01
.
Level 4
3 years ago
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Product Q&A
How can I convert values received from PU_COUNT to percentages?

Based on the example table below:I am getting the values in 'Column_2' by using PU_COUNTHow would I go by converting each value in 'Column_2' to a percentage amount?

13
.
Level 4
3 years ago
U
Level 3
ugurcan.aydem13Level 3
asked in General Product Q&A
Scheduling Studio Skills

Hello everyone, I wonder that when I create a skill with Manual Sensor, can i schedule trigger of this skill ? For example I want to trigger this skill once in a month automatically . If I can't is there any differenw way to do that Thank you 

22
U
Level 3
3 years ago

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