Product Q&A

Hi Team, Can you please help me with the code to extract Knowledge Mode Record information using Py Celonis.I checked the PyCelonis documentation but was not able to get the same. Thank You in advance. Regards,JB

Hi, I have created an application, authorised it and created a custom extractor which uses the Login History API to load the login history into a data pool. Unfortunately, this data is very limited and I don't know how to specify the parameters to load a larger period and analyse it afterwards. Is it possible to include a date filter in the endpoint or in the extraction, so that all data since a certain date is loaded? 

Hi all,​I have a problem about how to write PQL, please check following conditions and please let me know how to write it.​My process flow like thisProcess start(some activities here)work startwork start of A taskwork start of B taskwork start of C task(some activities here)Process end​and what I concern is #3 workstart, that has some branch and it might be in no particular order and combination is exist, so it might move 3-1 to 3-3 or 3-2 to 3-1, and I would like to get firstest work start time of work start. So I think it might be work if I can filter in specific activity name, then sort the date ascending and select distinct of its value but I don't know how to do it in PQL. Can anybody let me know how to do it?

Hi all, I'm looking for way to copy data pool with its data, I found copy function of data pool but if I push that it only contains data connection, data job, and data model, not its uploaded data. Is it able to include original data to copy environment?

Can someone suggest best way to add colour to the KPI in views based on another KPI value

Dear all, I am trying to embed process explorer inside views to create my analysis. But The scroll bar to increase activities and links is not appearing . Could you suggest any work around . Attaching my snapshot for you for reference

is it possible to use crop selection to filter the activities within range in Views? the similar function is available in the Analysis module out of box.

Hi can anyone help me in how touse EMS platform of celonis since i am very new to this platform and i want to upload a dataset and try this platform

Hello,i don't manage to log in the Infor M3 connector with OAuth2 authentification (ionapi file).How can i connect this?The M3 Cloud is a multitenant version.thanks in advance

Dear Experts, I recently created an app and realized that i need to add one more table into data model. Is it possible to go ahead uploading my table and loading data model without disturbing everything i created ( like views , PQL formulas etc )

How should the number of cases that do not go through a particular activity be coded in the PQL?

Hi,I would like to calculate SUM of two KPIs and display it in the views( using text box or kpi card etc.) Currently, i am trying to update the variable with KPI value using Onclick update variable option. But it seems to only store id, name and metadata of variable. I cannot access the value of KPI using Metadata object. I can only add KPI reference in any component using ".id" property of metadata object. SUM is not possible with ID references.Kindly suggest on how to achieve this.Thank you :) Best Regards,Shravya B

Dear experts, Lets say there is activity Y that i want to know average time spent on , Also in this there are n number of activities preceding it and n number of activities following it. which i dont care. Will it be possible to identify avg time spent on this activity using PQL ?  Thanks in advance ,

Hi Expert,  Does anybody know how to export data model technical document as same as dashboard? I just would like to share how to connecting SAP add-on table to business side but there I don't found any connection export way other than json. (business side don't know tech except SAP so I need something natural language one is better.)  Do we have something way to export data model?

I'm trying to build a profile view to display details on execution gaps, but when I go to setting to assign the profile view to the KO Id related to the anomaly this option is not possible, It only allow Records to be assigned. Any ideas on what i'm currently doing wrong?

(The info is available for 3 years back)  It is currently only showing 1 year (Jan22-Dec22)Thank you!

Hi all - looking to complete an extraction and I am running into a behavior that I'm not sure if it is intended. As you can see, one SS shows successful extraction of tables labeled 800 and up. However, when an earlier tabled primed for extraction fails to run (labeled 100-800), the previously shown passing tables fail. Any ideas on what is going on here?

Hello everyone, I am interested in creating a heat map in Celonis to track a KPI with respect to it's coordinates. As below:    Now, obviously, the only way this is useful is if you can track multiple coordinates. So, I use the visual editor, as below, to add a second coordinate:  Upon refreshing, I see an error of "Extraneous input".  My question is simple: What data format does Celonis expect for multiple coordinates? And could you provide an example that would work? I know this is possible because of the figure in the following post : https://www.celopeers.com/s/question/0D50700001xS5HOCA0/how-do-i-create-a-custom-label-for-a-tooltip-dimension?language=en_US by Christian Ocampo. Thank you for any help you can provide.

Hello, I have an ML script-filter: from pycelonis.pql import pql...query += PQLFilter(query=FILTER TABLE.COLUMN='Test') and need to set it up to that 'test', 'TEST', 'Test' will return the result, but cannot find a way in the documentation to setup/disable case sensitivity. How can I do this???

Good afternoon people. I'm studying the sequence of data Jobs to perform DELTA extraction Schedule from SAP P2P and in the studio screen to configure the Schedule, it doesn't have the options "Frequency-base schedule (Active)" and "Trigger-based schedule", like the video from Celonis Academy. https://academy.celonis.com/learn/video/set-up-a-schedule?client=partner Is there a new procedure to carry out the Set up a Schedule for delta extraction from SAP P2P with the "Trigger-based schedule" option?

Hi everyone, I have a question please: I would like to display in a view or in a KPI Card a year to date value and a Last year to date value, which are not sensitive to time filters but still sensitive to all other component filters. Can someone help me please? Best regards,Dany

Hi community, Now I'm working with Celonis SAP O2C dashboard from market place but it seems something different from my last experience so I'd like to find releaes note to know what is changed in code and KPI level. (which transformation or PQL has changed or something like that.) Does anybody know where can i find it? Thanks :)

I have 3 tables in excel format Table 1 contains P2P activity data Table 2 contains inventory movement activity data Table 3 contains activity data for production order.  Unfortunately they dont have common key , but each table dont have foreign key to link each other, can still event logs be merged using automerged functionality and represent on process explorer ?

is there anywhere more detailed information about log files of Action FLows

Dear Celopeer Hi. I would like to build a Concur Connection and extract data via the Concur API, but I couldn't find a Concur Connector (I think there used to be one, as described in this document SAP Concur Connection [Extractor Builder] (celonis.com)).Does anyone know how to connect to Concur via API?