General Product Q&A

Hello Dear Community, I'm trying to write PQL query that will return Material Numbers which are ordered on both active Scheduling Agreements and open Purchasing Orders in SAP.  Do you have any suggestions which PQL functions will be suitable for that? I've attached example with the input/expected output. Thank you! 

Hello All! Hope you all are doing great!We are working on a use case for which we are using Sap Concur connector available in Celonis market place. Wanted to check if anyone has used this connector.What is the method of extraction is uses? For now what I have seen in the connector settings, it seems it is using API. Could anyone confirm it. Regards,Tapan

Hi. I'm a new user, while I created the account / login incorrectly created as 'Guest' it is supposed to be 'Partner'. In the same I have completed welcome kit and Foundation. I planning to undergo certification. I need help to change access to Part

I've tried to follow the directions from Celo Docs, but the 'User Provisioning' area shown in the directions doesn't exist for me. I've looked in the other services areas, and my API key doesn't show.

Hi Celopeers Is it possible with PQL to create a KPI that will give you the name of the activity with the lowest / highest automation rate?

I'm want to create a dashboard and I'm trying to add the needed components, but the available height is not enough!  Is the option of adding components and allowing scrolling not available anymore?

What is the difference between the median throughput time of the first and second most common variants in days rounded to the nearest integer? select one: A. 17 B. 12 C. 5

Hello everyone,I have the following button dropdown set up in an analysis: In each dropdown selection the following coding is saved:I have already prepared the KM for the view like this - custom attribute:I now added the custom attribute to the dropdown list but the data is not filtered accordingly. To solve this, I think I need to add some variables to the KM which I already did like this:Yet, the variables are not avaible for me to select in this view:  Can someone help me with this? Is this the right procedure to migrate the button dropdown from an analysis to a view? Thank you for your support! Best regardsJulia Bauer

Hi,I have a table of 5 columns. Eg: Ticket_No, Description, Priority, Closed_Date, Owner.The 'owner' column has different email addresses. The requirement is to send the first 4 columns 'Ticket_No, Description, Priority, Closed_Date' in a CSV file to whatever email address available in the 'Owner' field. Can it be done via Action FLow - If yes, please let me know what are the steps/modules? If it is possible via ML code ? If yes, what are the steps. Your help would be appreciated. Thanks!

I have tried the below code:CREATE TABLE TABLE_COUNT_TC AS(SELECT t.table_name AS table_name,SUM(ps.row_count) AS row_count,  CURRENT_DATE AS Record_Date  FROM tables t  JOIN projections p ON t.table_id = p.anchor_table_id  JOIN projection_storage ps on p.projection_name = ps.projection_name  GROUP BY t.table_name,ps.row_count  ); This code is giving multiple lines for one table and they are not the raw tables. They are the tables that are created in transformations. Can anyone have idea on the above query? Thanks,Supriya.   

I failed rising star technical assessment 4 times only one module i complete 75% please give me a solution i need to complete the assessment

Hey is it possible that hte Process Automation Bootcamp basically became the Rising Star Programm? Thanks in advance

Hi, the filter dimension reacts with the filter button, but after the button is pressed, the dimension is cut. When the section next to the dimension has a width less than 1, it doesn't work at all and when the width is more than 1, it's cut even more...  Does someone know how to show the full dimension?

What can be used to compare selected cases in celonis with the source system entries

Process Cockpit (starter kit) --> Invoices (FI) tab --> Posting User column, populates some users as both Automatic as well as Manual. How can I validate if the users filter is configured correctly or not?

We are having an issue connecting to a new Snowflake environment and need more detailed information (like a log file) on what is causing the issue. The error message is not helpful (... Extractor responded with an internal error.)

i dont get mail

I am able to create benchmarking using legacy views but when i try using the same method in updated views i am getting errors.  

Hey guys,We are trying to export tables from SAP Ariba via API Supplier but we are receiving the return below message in Celonis extract Has anyone experienced this problem in this extraction?. Has anyone had this problem and could help me? Reached Supplier Data API limit waiting for 1 seconds. Current rate limits are;---X-RateLimit-Limit-day: "25000"X-RateLimit-Remaining-day: "24935"X-RateLimit-Limit-hour: "4500"X-RateLimit-Remaining-hour: "4435"X-RateLimit-Limit-minute: "150"X-RateLimit-Remaining-minute: "86"X-RateLimit-Limit-second: "3"X-RateLimit-Remaining-second: "0" 

How to add logo in the new studio. Is there any component which I can use? Also, can we use multiple metrics in stacked bar ?

Hello everyone, I'm currently building a worklist with two tabs (Open and Done). I have created an augmented attribute named STATUS which is either NEW (default value) or DONE (will appear in the DONE tab also). Accordingly, I now want to set a filter in the table of the Open Tab to filter out already processed data rows:  FILTER "MARC_AUGMENTED_status"."VALUE"='NEW'; This is only a simple filter, however after publishing the filter, the table shows no existing data rows anymore.  How is this possible?  Does anyone have an idea?  Thanks so much! BRJulia Bauer

How many cases are covered by the five most common variants

AVG(CASE WHEN "el__activitytable"."ExecutionType" != 'B' AND  PROCESS    EQUALS    START 'e_custom_InitiatePayment' TO ANY TO 'e_custom_AuthorisePayment' TO ANY TO     'e_custom_ReportPayment' then (CALC_THROUGHPUT(CASE_START TO CASE_END,  REMAP_TIMESTAMPS ("el__activitytable"."TIMESTAMP", hours))) ELSE 0 END)    

I don't get any email

We are already using icons in custom attributes, but like to introduce them in another place. From the first implementations we know, that there has been a list of available icons. The documentation (https://docs.celonis.com/en/knowledge-model---custom-objects-and-custom-attributes.html) references a specific Icon list :"Icon: Adds an icon next to the object’s content. This icon must be one of those contained in a specific icon list." However, that list is nowhere available. It consisted of a couple of screenshots (and not all icons worked...). There's nothing... Please help.