Product Q&A

I have a table were I only want to extract last 20 days of data based on "Update" datetime column. As the parameter option has a fixed start time (default value), I am looking for an option to add a SQL in Filter Statement where it substract 20 days from current date. This is giving error "Error parsing filter:"SQL used in Filter Statement: ColumnName >= TIMESTAMPADD ('day', -20, CURRENT_TIMESTAMP AT TIME ZONE 'US/Eastern')As this is Full load extraction, I am not using "Enable Change Date Filter". I also tried the option of creating parameters and changing value in transformation but that too didn't work.Any help would be appreciated.

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%')it gives me the same error of calc_throughput and it doesn't identify the right path. How can I solve? How can insert the LIKE function in other functions? Thanks

Hi All,Earlier I had asked a question regarding how we can save/extract a table in our EMS as a csv file in our machine learning work bench, seeing the reactions or the lack of replies I got for the topic I think it would be helpful if I explain the code that I used/found to save the file as csv in my ML workbench. from pycelonis import get_celonisimport pycelonis.pql as pqlfrom pycelonis.config import Config celonis = get_celonis()data_pool = celonis.data_integration.get_data_pools().find("Datapool name")data_model = data_pool.get_data_models().find("Datamodel name")Config.DEFAULT_DATA_MODEL = data_modeltables = data_model.get_tables()table_name = data_model.get_tables().find("Table to find out")table_columns = table_name.get_columns()df = pql.DataFrame(  {    "column1": table_columns.find("column name in the table which has to be extracted "),    "column2": table_columns.find(" column name for column 2 "),    &quot

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!

Hi Guys, I need some help, please! I need that KPI to not change with filter in my Dash APPs, for example:  KPI Global Cycle Time : 10 DAYS With filter of manager. KPI Global Cycle Time : 5 DAYS  I need that this KPI stay still. How can I make it happen?

I have so many KPIs created in my KM but not sure which KPI is used in which view. So is there any way to list dependencies for each KPI ???? and helpful if we can list all KPIs not used anywhere.

Hello everyone, I'm trying to count the number of materials per purchasing group that have been active in e.g. the year of 2023: PU_COUNT_DISTINCT("T024", BIND ("_CEL_P2P_ACTIVITIES", "MARC"."MATNR"),"_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"='Create Purchase Order Item' ANDYEAR("_CEL_P2P_ACTIVITIES"."EVENTTIME")=2023)) I want the aggregation to be made per purchasing group (T024). MARC provides the information which purchasing group is responsible for each material number. I need _CEL_P2P_ACTIVITIES table to filter the eventtime within my view. This aggregation works, however, when wanting to build an average (per purchasing group) like this, it does not work - error: "The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs": PU_COUNT_DISTINCT("T024", BIND (&q

Can anyone explain how to see details of those objects in that explorer,,,?

YAML for the dropdown that does not have 'Select all' option: id: dropdown-list-7b5fb6f2-ff12-464a-bdfb-84ff28262328type: dropdown-listsettings:  data:    columns:      - id: f89c920d-8b0b-4c7d-9399-ca6a9df35b7d        order: 100        onClick:          update:            selection: multiple            variables:              - name: benchmark_1              - name: Benchmark1_selection                attribute: ct_case_table.${dimension_benchmark}        displayName: ${Benchmark1_selection}  styles:    overflow: scroll    position:      vertical: center      horizontal: fullknowledgeModelKey: test-km-ah 

Hi Celopeers, I wonder if someone had already use case where Action Flow can generate Salesforce Tickets?

Hello, I am trying to connect to salesforce commerce cloud b2c using extractor builder, when I tried the api with postman, I am getting data when we send body in post request, but in celonis I don't see option to add body and send post request, I am getting MethodNotAllowedException for get request. Is there any other way we can connect to system?/ how to send the post request to the end point?  Thanks in advance

Please provide me some documentation on Record To Report (R2R) Process.

I have Python version of 3.8.6 by default I want to upgrade my version of python . I tried using this command in the terminal. It is asking password for it. Is there any other way to implement this?. Please let me know. Thanks, Ajith Naidu.

Hi!  Is there any list or documentation on the use cases when Skills are better than Action Flow or visceversa? Thank you! 😀

I would like to add a filter in the 'load script' section in a sheet. that filters the content by the current month. How do I do that?

Suppose I have data for 3 months and using some connection I have imported the data in the Celonis for that 3 months and created Data Model. Again I got additional data for next 3 months, now I want to create another data model only for the new 3 months data. How can we use Incremental loading for these type of scenarios...?

I have a big data model already in use and have to make a change in several tables used in there. Previously, it was possible to change the source table using a dropdown in Name, but the dropdown it's not showing anymore. This option was disabled?  It was a very useful function and the turn off of this cause a more hours of manual work that can be avoided.