Product Q&A

Good morning community, I'm trying to perform an extraction on a sizeable SAP table (AUSP) by linking it to another table (MCH1). These tables are linked through a field that is not quite the same on both tables. In AUSP, this field will be a value like '000000000000003641', whereas on MCH1 this value will be '3641' Since I don't know if I can use any formulas to add X amount of '0' characters (this would be using something like repeat character '0' 18-Length(3641) times), I want to convert '000000000000003641' to Integer. I have tried a number of variations of the following join: But I always get this error: Can

Hi folks! I know I can use a module to get data from a data model in an action flow, but can I get data from a component in analysis for example an OLAP table in an action flow?

The goal is to retrieve the 'Status' information to highlight the "Invited" users (fetching data using SCIM doesn't give this information). 

Hello, I am building a use case and I need to calculate several variables and show aggregared data in a form of 'SUM' vaue. I do have a lot of data for the dimension I am using and I would like to limit those according to the 'SUM" value. Is there any way that I could place aggegated filter?E.g. SUM(A+B)>5  I am not able able to use the Pull-Up function here. I would not prefer to Limit the rows or use First K Rows.Ideally I am looking for an Option which would work in similar way as "Having" works in SQL.  Will be grateful for any answers/ hints.Best regards, Krzysztof  

How can we arrange filter value in order in Button Dropdown using load entries? Options under button dropdown should be of order. - Committed Case- Violated Case- Others But the 'Others' option is listed 2nd as per alphabetical order. Code:CASE WHENPU_COUNT ("A", "B"."caseid" ) > 0THEN 'Committed Case'WHEN  PU_COUNT ("A", "C"."_CASE_KEY", "C"."CHANGED_TO" IN ('In Progress') AND "C"."CHANGED_FROM" NOT IN ('New')) > 0THEN 'Violated Case'ELSE'Others'END Other than rephrasing the options and numbering the options, is there any defaul

I registered using guest but need to change it to partner

Dear Celopeers, I would like to save the third largest Count of Order Items per country as a variable.E.g.:DE - 7000EN - 12000IT - 9500...Variable: 7000I only have access to these functions: https://help.celonis.de/display/PQL47/PQL+Function+Library+-+CPM+4.7 Thank you in advance!

Why is the export of data pool available in JSON format only?

Hi everyone, we are currently running into the limitations of action flows. Namely runtime. Use-Case: We want to create 2000 PDF Reports from Analysis sheets and send them to different people. Creating one PDF Report takes aprox. 40 seconds. Therefore after only 80 reports, we already reached the runtime limit. Did someone already encounter this issue? Possible Solutions that I already had in mind:Skill to trigger parallel executions of that action flow (I don't think this works because I can't even execute an action flow while it is already running)Duplicate the action flow like 40 times (I don't think this can even be considered a solution) Thankfull for any help that someone might provide!Thanks in advance. Best regardsPatrick

Is data stored in AWS or Azure? (There's one post that says its hosted in AWS and another that says its hosted in Azure)

I would like to understand how I can leverage Celonis for my Service Delivery Org and need some personalized statistics to demonstrate the same to my Business. Which path should I follow?

I have created dropdown but unable to build or cant find any option where I build select all checkbox.

Hi Team,"Celonis Governance Model "We have multiple tools in our organization for dashboarding.There is often a discussion to decide whether Celonis is the right fit for the requirement or not.Overlap is mainly with the POWER BI which is used for dashboarding. We also have Automation studio using RPA's etc.We are working on a decision matrix to decide which is a process mining use case and which one is not.Anyone has done that already or any inputs with this regard will be helpful.

Hello everyone,Were trying to connect SAP ECC to CIBC. We have installed RFC and extractor but when we test, it says:Connection test failed, please check the Data Connections configuration and ensure that the system is running: Error during connection validation: OPEN DATASET - No OS Permission to open file /tmp/CELONIS/CEL_EX_If anyone can help usThanks!

Hi,I am trying to send API Request using the api_request() function but i am getting this RetryError. Can anyone please explain how to tackle this error. 

when constructing an activty in data transformations, we use insert into, select, where, from. but how we will know we will put some joins in "where"? to sum up, how we can construct an activity?

Hi, Does Celonis have best practices on how to automate the deletion of old day (say data older than 1 year)? I understand that I can write my custom scripts with delete statements and execute them. However, given the underlying data model (that also has relationships) and timestamp definitions in each table, is there a way to leverage that and easily automate deletion of old data (ex : older than a year)? Thanks,Bhasker

Hello,  I'm attempting to create a data connection via .xlsx file on my computer. I created a space and then made the data pool connection alias. However, once i select "Connect to Data Source" and successfully connect my data, it does not proceed to make the connection.  Can you please help and or instruct me on the correct method to complete the next steps? (See images below)  Once I selected Esc, the remains equivalent to image one, any help is greatly appreciated.  Thanks!!

How to change the activity order?

Hello, I have a excel database where there is a date column. I try to change the format of this column using this function :CAST( column_name AS timestamp) But it shows me a lot of empty value and its not supposed to... For some raws its working but not all of themDo you have an idea ?

How to change my account as partner account?

Hello all, I have tried to manipulate the timestamp in SQL, which worked on our Oracle server, but seems to have no effect on the back end in EMS. I suspect there is some kind of time zone problem? I have attached a few screenshots. The timestamp should have the following format:Original: YYYY-MM-DD 00:00:00 --> manipulated YYYY-MM-DD 23:45:00 Thanks for your answers in advance. With kind regardsChristoph EMS not working Local Database the SQL query works   

I'm trying to create anew skill using the documentation, but it looks like smart sensors are no longer available.What's now the alternative? Where can we find documentation on this topic? Thank you

Hi,I am trying to connect to pycelonis from my local system to IBC .It was possible with all the required values when it was 1.7.4But after the upgrade to 2.0 , we are getting a getaddrinfo errorIs anyone else facing such an issue?If so, What needs to be done.Let me knowThanks

Hi everyone, I want to add a PQL filter/ statement to my dashboard. I have an OLAP table with the results of multiple IBAN checks that runs every day (so the results are double, but with different dates). I want to add a filter to show the results only once with the newest date.