General Product Q&A

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 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 :)

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, 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​ 

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!

Trying to find a transformation tasks where a particular table is used, right now going through each and every task its very time consuming effort.

Hi everyone,I am pretty new to Action Flows and currently I am trying to trigger an Action Flow by clicking a button in one of my analyses. Is this technically even possible? I couldn't find any fitting trigger modules in my Action FLow instance. Thanks in advanceFynn

Data-> Data integration ->New Data Pool -> Create from Scratch ->Name and Save -> Connect to Data-> Upload Files -> Select files (my csv) -> Run Succed. I can see the files but still dont have any Data connections.. what i miss???

I try to calculate overall Business impact for all KPIs and Show it in one sheet. KPIs are validated with different SAP time areas. KPI 1 is validated with AUFK.ERDAT; KPI 2 is validated with AFRU.BUDAT and my goal is to calculate 2022 impact.

I looking for above connector but didn't find. Could someone tell me how can i build that.

I'm wondering if this is a glitch or if I'm missing something very obvious. I've edited the record attribute in my Data Model to be in the date format %y-%m-%d, but for some reason it is displaying with hours, minutes and seconds. Please seen the screenshot. What am I missing? I have refreshed my browser, and exited edit mode several times.

Hi, DPO is the average number of days a company takes to pay its suppliers.Here is the logic I found in the process cockpit. Why do we need to multiply the "BSEG"."WRBTR field here as we need only the days of difference ? SUM(   CASE       WHEN ISNULL("BSEG"."AUGDT")=1           THEN 0.0       ELSE DATEDIFF(dd, ROUND_DAY("BKPF"."BUDAT"), ROUND_DAY("BSEG"."AUGDT")) * "BSEG"."WRBTR"   END)/SUM(   CASE       WHEN ISNULL("BSEG"."AUGDT")=1           THEN 0.0       ELSE "BSEG"."WRBTR"   END)

hello, I'm trying to analyze the changes on the delivery headers (LIKP) but I wanna filter a specific plant. When I try to creat an OLAP table with the changes and the plant (LIKP.VSTEL) I get the following error message:"No common table could be found. The tables ["_CEL_O2C_ACTIVITIES"] and ["LIKP"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [_CEL_O2C_ACTIVITIES]N <-- 1![VBAP]!1 --> N[VBFA]N <-- 1[LIPS]N <-- 1[LIKP]. For more information on the join path, search for "Join functionality" in PQL documentation.", Does anyone know how to join these two tables ?Thank you!

I have the problem when deleting a data pool that only the content is deleted. I.e. all connections, extractions, data jobs, etc. are deleted. However, the "shell" of the data pool cannot be deleted.