Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4419 Topics
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
ABC: X% of suppliers do 80% of order value

Hi there, I have the supplier names (LFA1.NAME1) and the order value (EKPO.NETWR). I want to create the statistic, how many suppliers are relevant for 80% of the total order value. How is that possible. I tried to do that with ABC, but failed. TOP X suppliers do 80% of total order value TOP x% of the suppliers do 80% of total order value Would be really great to find a solution. Thx and br Daniel

60
D
Level 2
V
Level 1
vaishali.pawar11Level 1
asked in General Product Q&A
Can we calculate throughput time without rework/change activities

Hi,We are trying to create a deep dive analysis for calculating throughput time. Is there a possibility to calculate TPT without Rework/Change activities? We tried to do it with the help of component filter where we attempted to use the NOT_IN operator in order to ignore rework activities. Is this the right way or does Celonis support any special PQL query for this. Suggestions, ideas would be highly appreciated

30
D
Level 1
.
Level 3
.146003860Level 3
asked in General Product Q&A
How to calculate the difference between two dates in a table?

Hi, Currently I am using this formula: AVG(CALC_THROUGHPUT(CASE_START TO LAST_OCCURRENCE['<%= Activity %>'], REMAP_TIMESTAMPS("DATA_(7)_csv"."COMPLETION_DATE", DAYS))) This formula works well, however I would prefer if I could actually calculate the dates between two columns, rather than just from one column. Something like this: Start Date - Completion Date Example : Thanks,Terence

110
D
Level 1
K
Level 1
kavitha.linga12Level 1
asked in General Product Q&A
Is it possible to get the load script filter which gives the same result as this selection? ie. process flows through 'Deputation letter generated'

Hi everyone, I need to use load script filter for some pages in which the process has to be flow to this step 'Deputation letter generated'. I had tried,  FILTER PROCESS EQUALS '<%=activity_name%>'FILTER ISNULL(PU_LAST("Table_name",ROUND_DAY("Activity_Table"."EVENT_TIME"),"Activity_Table"."ACTIVITY"='Deputation Letter Generated')) = 0; But it is not working. Kindly help me to solve this please

40
P
Level 1
S
Level 3
sanchit.khann15Level 3
asked in General Product Q&A
While doing On-Prem to EMS migration, we are facing a blocker on DATS_IS_VALID() function in On-Prem. Can anyone suggest an alternate for it in Vertica?

We are doing a project for migrating data transformations from On-Prem to EMS.SAP HANA is used for On-Prem transformations. We have a blocker where a function -> DATS_IS_VALID() is used in the transformations in On-Prem.The purpose of this function is to check if a particular date value (in the format YYYYMMDD) is valid or invalid.For example: 20211130 is valid (Nov 30 2021) whereas 20211131 is invalid (coz November doesn’t have 31 days) Now there is no direct syntax in Vertica to perform this operation as per our research.Since we have many transformations using this check, we would need your help in finding out a better way to solve this problem. Our conditions are mostly like, if the date is valid then take that specific date field and if the date is invalid then treat it as NULL.Invalid dates are present in Production data as well as there are some manual invoicing being done hence we cannot remove or ignore this check.

20
S
Level 2
J
Level 2
johann.bangLevel 2
asked in General Product Q&A
Does Celonis have any documentation of the algorithms they use in the process discovery and conformance checking? I need to have references for the master thesis

Does Celonis have any documentation of the algorithms they use in the process discovery and conformance checking? I need to have references for the master thesis

40
D
Level 1
S
Level 2
sharana.basava.patilLevel 2
asked in General Product Q&A
what is the difference between the operators '*','ANY','.' in match_process_regex function

​

10
M
Level 1
enrico.pugli12
Level 3
enrico.pugli12Level 3
asked in General Product Q&A
Case count against an attribute

Hello everyone,I am asking for support here for an application that I would like to do.I have a CASE TABLE in which calls to a call center are recorded. Each line represents a received call.The goal is to count the Recallers, i.e. those numbers that call several times in the period considered, and their frequency.In other words, I would like to see how many people call twice, thrice, four times, etc.I made a drawing to make better understood in which I recorded 9 calls made from 4 different numbers: I want to put them in a table or graph that shows me that there are 2 numbers that called 2 times, one number that called 4 times and a number only once. (I don't care about the phone number, I put up numbers just to show what I have available and what I want). Could anyone help me set up a component with PQL? Thanks  

00
enrico.pugli12
Level 3
.
Level 2
.1460062914Level 2
asked in General Product Q&A
How to measure time between events and get specific cases

Hi there,i'm farely new to Celonis and struggeling with some basics.I'm trying so get the time between events (not only directly followed).For example: i have events A, B, C, D, Etime between B and C should be less 1hgoal: get all cases to which this appliesI really tried to figure it out, even with OLAP tables, but i think for something this basic there has to be another way. Thanks in advance, looking forward to your answers.Steph

00
.
Level 2
J
Level 1
julio.luna11Level 1
asked in General Product Q&A
What is needed to perform an Analysis based on legacy systems that are developed in java and using sql. what is needed in Celonis".. what is the best approach?

Currently the IT landscape is based on Legacys no ERP or Market solution.  This company decided years ago to develop all their technology and now are facing obsolescence and process issues and difficult to improve as there is no documentation, etc. The discovery process for an improvement project takes a lot of time and we want to improve the discovery process.  

30
D
Level 1
D
Level 1
dmytro.meshcLevel 1
asked in General Product Q&A
Good afternoon,I would like to test process simulation capabilities. Could you please let me know how to start with it with a partner account?Best,Dmytro

Good afternoon, I would like to test process simulation capabilities. Could you please let me know how to start with it with a partner account? Best, Dmytro

00
B
Celonaut
D
Level 1
deleted.delet27Level 1
asked in General Product Q&A
Replace inserting selfjoin sequence numbers to get all activities performed within a 10 sec span.

Hello,  I'm trying to optimize very long-running queries (few hours):We want to change user type for all activities done in span of 10 seconds (so for specific activity if there's any other activity done in 5 seconds before or 5 seconds after by same user and with same activity name the user type should be adjusted). I've marked red a rows that won't be updated due to failing match (Different user_name, activity_name or exceeded time span).  Do you have any ideas? Right now I've got 2 queries:A) Alter table - add integer columnB) First assign row numbers by just updatingC) Make selfjoin based on row numbering with just update I know it could be easly done with LAG/LEAD analytical Vertica 10.0.x functions, however these are not supported. Only other idea is to not assign row numbers but to use identity and try also to use MERGE.  help would be highly appreciated Best Regards,Mateusz Dudek

00
L
Level 1
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Copying variables from one Analysis to another

Is there a possibility to copy Variables defined in one analysis into another. Celonis 4.5 Version. Regards Naveen Gupta

00
C
Level 2
.
Level 3
.146003860Level 3
asked in General Product Q&A
How to filter based on a selection?

Hi, I am currently trying to calculate the averages days from process start to the end of a specific activity using the following code:AVG(CALC_THROUGHPUT(CASE_START TO LAST_OCCURRENCE['Confirm Order'], REMAP_TIMESTAMPS("DATA_csv"."START_DATE", DAYS))) However, I now want to be able to configure the above code so that the KPI filters based on any activity I select but NOT take into account process end. The problem I'm having right now is that it instead calculates the time difference between start and end of process whenever I pick any activity. Thanks,Terence

100
jasper.feije
Level 3
C
Level 3
carina.carin11Level 3
asked in Data Ingestion & Infrastructure
Explanation of Activity: Invoice Due Date Passed

Hi,can anybody help me understanding how the activity Invoice Due Date Passed is defined?I have a few cases, where this occures more than one time in the process and I wonder how this is possible.image1036535 32.9 KBThank you for your help!Best,Carina

50
J
Level 2
R
Level 2
ralf.ehrma12Level 2
posted in General Product Q&A
Hi, I am currently preparing an order management demo and wondered how to include a client logo in the demo.

Hi, I am currently preparing an order management demo and wondered how to include a client logo in the demo. Could anyone help out? Thanks. 

25
D
Level 1
S
Level 2
subash.varadLevel 2
asked in General Product Q&A
how to use CURRENCY_CONVERT_SAP ?

is CURRENCY_CONVERT_SAP function need TCURF , TCURX table in datamodel ? or without any reference (currency) table can we use this function? .

230
F
Level 3
.
Level 3
.1460040856Level 3
asked in General Product Q&A
i have a data set that is in the string format , i want to extract my month part from the date that is in the string format what formula i can use to create my view part by considering month on the x axis in the view.

and i want only month part should be extracted from the column that i have and there are various year in the same column, but i want to make their chart according to their months

40
.
Level 3
N
Level 3
nicholas.clarkLevel 3
posted in Data Ingestion & Infrastructure
Error in the Default Pipeline Script for assembling & pushing tables to front-end.

Error in the Default Pipeline Script for assembling & pushing tables to front-end. Has anyone run into an error when running the default pipeline ML script where you get: "Could not execute foreign key join: There are duplicates on both sides of the specified key relationship. Table: Tm_Activities; Key("CaseID")"?  Not sure why this arose out of nowhere.

00
N
Level 3
P
Level 1
pritam.roy16Level 1
asked in General Product Q&A
The Public Link has been getting open for all without any credential which is avoiding the security policies

The initial idea was to view some Celonis Pages (Process analysis or analysis form Studio) from another tool which is hosted in AWS. Embedding of the Celonis page on that tool. But when we are sharing the link (not the public link) getting the below error message.<<IBC Cloud >> refused to connect. The issue with the public link is when enabling the celonis public link anyone can open the analysis with high confidential data to everyone, although in non editable mode but cases with confidential data will be visible

30
R
Celonaut
S
Level 2
shashi.boinaLevel 2
asked in General Product Q&A
Oracle Fusion O2C Table Joins:We need to know the table name which stores the information of "Confirm Pick Slips"Can any one please help?Thanks,Shashi.

Oracle Fusion O2C Cycle:We are not able to find the Pick Confirm Table.  Order to Cash Flow:1.Create Sales Order Header2. Create Pick Wave3. Print Pick Slip Report4. Confirm Pick Slips --->( Not able to find the Table for the Confirm Pick Slips)5. Ship Confimed  Please Help on which table we can find this link.

440
jasper.feije
Level 3
S
Level 2
somashekar.vishwLevel 2
asked in Data Ingestion & Infrastructure
Transformations for tables and columns in oracle ebs for P2P process

I was able to find a p2p best practices for SAP in the partner asset library. We are interested in building the activity table for P2P on oracle cloud. I wanted to get a sense of what tables and columns are need for various activities such as Create Req, Modify PO etc along the P2P process. Any help is greatly appreciated.

60
jasper.feije
Level 3
.
Level 1
.14600105130Level 1
asked in General Product Q&A
Is there only Cloud solution is available or is there any software as well ? And if it can be installed , can we install it on virtual desktop for process mining ?

Is there only Cloud solution is available or is there any software as well ? And if it can be installed , can we install it on virtual desktop for process mining ?

20
D
Level 1
.
Level 1
.1460068242Level 1
asked in General Product Q&A
How to get activation code for Training team access?

How to get activation code for Training team access?

20
D
Level 2
satoshi.omach12
Level 3
satoshi.omach12Level 3
asked in Data Ingestion & Infrastructure
Hi Guys, how to do O2C process and AR process in one analysis.

First, we have created O2C process and added tables that are required for AR process. The extraction part is done, but we have stuck in the data model. The connection between vbap and vbfa may be failing. 

10
satoshi.omach12
Level 3

Badge Winners

  • Value Assessment Expert
    gabriela.cruzhas earned the badge Value Assessment Expert
  • Qualified to Identify and Drive Opportunities
    gabriela.cruzhas earned the badge Qualified to Identify and Drive Opportunities
  • First Post
    joaocarlos.maciehas earned the badge First Post
  • First Post
    asdfghas earned the badge First Post
  • Celonis Technical Expert
    Clarahas earned the badge Celonis Technical Expert
VIEW ALL
Community Code of Conduct