Product Q&A

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!

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.

Can we send the screenshot of the dashboard sheet in email through the action flow?

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.

Hi, The logic for OTD is given as below in Process cockpit WHEN PU_COUNT ( "EKPO" , "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" , "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Record Goods Receipt' ) > 0 AND DAYS_BETWEEN ( PU_MAX ( "EKPO" , "EKET"."EINDT" ) , PU_MAX ( "EKPO" , "EKBE"."CPUDT" , "EKBE"."VGABE" = '1' AND "EKBE"."SHKZG" = 'S' ) ) <= 10 AND DAYS_BETWEEN ( PU_MAX ( "EKPO" , "EKET"."EINDT" ) , PU_MAX ( "EKPO" , "EKBE"."CPUDT" , "EKBE"."VGABE" = '1' AND "EKBE"."SHKZG" = 'S' ) ) >= ( -1.0 * 10 )  two questions I have 1. why do we need days_between and PU_MAX when we can use DATEDIFF(DD, <DATE>, <DATE> ) field? -- Is it because only then it will calculate for all the cases?I don't und

Hello, In the analysis view, I would like to multiply a set of values with a random operator similar to RAND() in excel however I cannot find anything like this in the documentation. Does anyone know if there is such an operator ?Thank you

Data Integration service cannot be reached error coming on UI while service is up and running on UAT. Please suggest any way how to fix this.

How to calculate automation rate in PQL?