General Product Q&A

The table in question is on the 1 side of a 1-to-many relationship, so PU_COUNTs will not work.

Hi everyone, Is it possible to select the next event matching the target process in a view for a case? Thanks and best regards,Sarina

Hello everyone, I am currently calculating the time interval between 2 activities for my department, see formula... TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['toPAS: QT5.2 - Check successful'] TO FIRST_OCCURRENCE['XI release'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5) Now it can and may also be the case that the activities are swapped, how can I then incorporate this option into the formula? TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['toPAS: QT5.2 - Check successful'] TO FIRST_OCCURRENCE['XI release'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5)ORTRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE['XI release'] TO FIRST_OCCURRENCE['toPAS: QT5.2 - check successful'], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME&qu

how to change the profile name

Hi together,we have two environments (different URLs): sandbox and production. What is currently the best way to deploy e.g., Knowledge Models and Views. from one environment to another? I know that copying is possible, but that doesn't seem very elegant and robust to me.One way, I can imagine, is to extend the assets. Is this possible? If yes, what would be thy syntax?BR Michael

I want to run a Python script based on inputs from some Celonis data fields. And the output from Python script should again be included in the OLAP table built in Celonis. I have tried to see the Celonis academy resources and celonis documents already, however not able to understand how it should be integrated. (excuse the functional language to explain my query) 

So I basically need the maximum of: PU_COUNT ( DOMAIN_TABLE ( "CEL_ACTIVITIES_SF"."CASE_ID","CEL_ACTIVITIES_SF"."USER_ID"), FILTER_TO_NULL ( "CEL_ACTIVITIES_SF"."USER_ID" )) per case 

Do you know any solution to this problem?  Thank you in advance!

When one create a flag but wants to use variables in the flag PQL, is it possible to use variables? I get errors when using variables and have to convert the variables to KPI's before it works. Is that the correct approach?

My clients have recently requested i download the list of Violations arising from conformance analysis into a spreadsheet so they could provide input as to the priority of each item. Is there a way to do this

Hi all, I am working on a process that is not on SAP. But would still like to exclude public holidays. Is it possible to create my own TFACS table and pull it into Celonis? and if it is how should the formatting look?

I’m a bit confused of when to use the ACTIVITY_TABLE() and other SAP tables when calculating the KPIs. So for example, when I want to calculate # of changes per PO item, is it correct when I use the ACTIVITY_TABLE() to count the change activities occurred or use the EKPO table and calculate the changes with indicator fields from the table. Same for other KPIs, this is just an example.  Becausesometimes I get different results (in calculating automation users/activitiesfor example) and I am not sure which is correct.

I have an aging bar chart in view which I want to see what aging is exceeding my position line limit.

I got the link to set up my Personal Training Environment but when I tried the first step: 'build analysing asset' with the guide and the software was running and cut off without doing anything.  Then I've tried to delete the account on the training environment and retried to create an environment. Then I got the notification I got already one with the link. I clicked it and got the following screen: Thank you in advance!

Hi Everyone, Want to check how do we extract the Log file for the loads we have extracted in data jobs. I have run a full load and I wanted to compare the number of rows extracted by table and time taken for each table between last load and latest load.

When I create a data exploration, it tells me that zero rows are found in my data model. However, my data model has over ten thousand rows. Has anyone else experienced this problem and knows how to fix it?

https://www.celonis.com/paf/">

I simply want a license for PAFnow Process mining visual - I added the app in Power BI desktop file but can't figure out how to licence it

Hola alguien de habla hispana en latinoamerica para hablar acerca de la herramienta en nuestro entorno?

Access the Order Management demo to answer this question. What statements are true for the second most common variant? A. Activity frequency shows that 404,562 cases are associated with this variant. B. Activity frequency shows that the activity Change

When I upload files to my data connections, my data pool still says that I don't have any data connections yet. How can I fix this?

Can anyone please explain what is Set Identifier? which is new option inside a data model

Here is my YAML codeid: input-box-1d9cff2d-89eb-4104-9954-e79ad9fb5b9atype: input-boxsettings:  type: number  onChange:    update:      variables:        - name: FTE_cost 

Hi everyone, I need an help: I want to indentify and calculate time between an activity 'A' and others that start with 'REC' (like image below) I'm able to identify the cases with PROCESS EQUALS: PROCESS EQUALS 'A' TO ANY TO LIKE 'REC%'but I can use the function LIKE in CALC_THROUGHPUT CALC_THROUGHPUT ( FIRST_OCCURRENCE ['A'] TO FIRST_OCCURRENCE [ 'REC%' ] , REMAP_TIMESTAMPS("Activity"."timestamp", DAYS))It gives me the warning "Target Activity "REC%" could not be found in the activity column and it doen't calculate the time.Another use I would like to make of it, is to use it inside match_process_regex, likeMATCH_PROCESS_REGEX("Activity"."activity", 'A'>> 'REC%&#

I'm trying to add labels based on the 'EventDescription' column for task mining:However, this column doesn't appear in the dropdown menu of the 'Create Label' interface, which seems to limit the available columns for labeling: Does anyone know how to include this column or any similar unlisted columns in the labeling rules? Looking for any advice or workarounds. Thanks!