Product Q&A

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?

With REMAP_VALUES I was successfully able to remove an unwanted activity from my process flow. Now I am trying to use it with the load script to use it for the whole screen, but it doesn't work. Tried several syntax, but no success. Is there a way using it?

In more detail, ERROR400: Comparison operator > (greater than) does not support comparing column {"case.table"."hired.full"] of type [DATE] with constant of type [CONST_INT] The issue is that the "CONST_INT" is a DATETIME in the Datajobs so we don't understand this error. We are trying to compare two dates, and this error keeps falling in. Any idea how to solve this problem?

Hi everyone,  I have a problem executing an HTTP request through the Action Flow. In fact, when I try to make a request, I get the status code 403 because, as the log says, the source IP is not in allow list. Furthermore, the client IP shown in the log's details is different every time.  Then, what outbound IP range should I have to communicate to the customer to solve this issue? In the Celonis' documentation I found these addresses (the second column is the one for the source IPs):  Could they be correct? Thanks in advance,Emanuele

The relevant colums are 'status', which shows the ticket status, e.g. accepted, solved, closed, etc, and the column 'emailaddress', which shows the emailaddress of the employee who changed the status. A ticket should be solved and closed by different employees. Thus, when an employee closes a ticket, this should not be a ticket which that employee solved. I would like to see a ratio of the number of tickets that were solved and closed by the same employee and the number of tickets that were solved and closed by a different employee. Thank you in advance!

Hi Experts , Lets say i have to compare activity time lets say "Goods Receipt" time which is present in activity table with Expected delivery date which is present in case table. Should i be directly substracting activity time on Olap table and fiter table by activity == "Goods receipt" OR Is there a good way using PQL ?  Thanks - Shaif

Hi, I would like to open SAP GUI on clicking from Views(OLAP Table) where it gets redirected on clicking a VBELN from the OLAP Table goes to the corresponding transaction in SAP. Similar to below screenshot from Analysis:Currently it is possible using Action Engine- Action feature like below screenshot:Kindly let me know if there's a possibility in Views.Thanks!@shravya.b11​ 

Dear Experts , Can you suggest right way to find list of violation users who not only created Purchase order but also approved purchase orders. ? 

How to select two column from two different table using the CALC_THROUGHPUT?

Hello, I created a basic global search in View by following the codes below. However, the label is not showing up, what am I missing here?  id: global-search-XXXXX-XXXXXtype: global-searchsettings:  floatingPlaceholder: true  label: Employee_ID  search:    - attribute: _CEL_EMP.EMP_ID

I have created variables in my Knowledge Model (see YAML below) that I am trying to have input boxes to modify. On my View, when I create an Input Box and try name a variable I get an error that no variables exist. What am I doing wrong?  Bonus Question: In Views can I use those variables to create an Improvement Opportunity calculation similar to that of Analysis? Knowledge Model Variable Definition: variables:  - id: input_me    displayName: Input    value: |      5*note I did not think I had to define a value, but I am required to in the visual editor YAML for the Input Box: id: input-box-6041fe8f-bff0-495d-844d-d1b0c8d7c721type: input-boxsettings:  name: Input Box  type: number  onChange:    update:      variables:        - name: <Input> [note the error at the bottom of the screen says that no variables are available] 

Dear Celomates, Is it possible to export a visualisation of thje process explorer to bpm file with an Acadamic license? Thanks!