Product Q&A

Hi,​I am unable to access my training environment can you please hlp me with that

PU functions don't take load script-, sheet-, component- or manual filters into account. Instead they have the filter option in their syntax. That is also described in the documentation (https://docs.celonis.com/en/pull-up-aggregation.html).I have some colleagues who think they are getting a different behaviour of the PU-functions compared to the time when their analysis were built (~3-4 yrs ago).Does anybody remember if the PU-functions once took sheet- or component filters into account?

As a part of training, I want to use email module in the action flow but unable to use email and some other modules as I don't have access to data connection of various modules. How can I use those modules like email, Google sheets etc in the action flow?

Hi all, Is there a way to get saved Formulas from analysis into Knowledge model without recreating them manually?

Hi there,is there any statement to count the occurances of a process pattern within a single case?e.g. set price block - change price - remove price block occurs 3 times for case #123Potential Use Case:How often is a price block removed without a price change.So far I can only count the cases for which this pattern occurs at least once (PROCESS EQUALS/MATCH_PROCESS) but not how often.Very thankful for some advice!Best regardsManoah Rudisile

Hey everyone, i want to know of all Sales order items how much of them are affected by change price, i dont know how to put it into a variable. In general i dont know how to have the inner join of a count_table and an activity, thanks in advance

I have a system set up where an email is sent when you click a button from a view. The button triggers a skill which then triggers the action flow that sends an excel file with all the relevant info. Now I want that info to change based on the filters applied on the view before pressing the button. Is that possible?

I'm creating a proposal and the RFP questions related to end-user systems are archaic. But it does lead to an interesting question. Is there any caching at all on end-user devices?

This is the code I'm trying to execute: celonis = get_celonis() data_pool_name = "dataPool"data_pool = celonis.data_integration.get_data_pools().find(data_pool_name) column_config = [  ColumnTransport(column_type = ColumnType.STRING, field_length = 10000)] data_pool_table = data_pool.create_table(df = dfResult, table_name = "tableName", drop_if_exists = True, column_config = column_config) This is the error code: Response: Server error '500 Internal Server Error' The table "tableName" already exists with a defined column named "_COL" inside the DataPool, which has a specific DataModel with just that table. The pandas DataFrame dfResult is a 1x1 table with a string inside. Does that error code mean only the Celonis server is to blame?

Hi, we use the current process connector foraccounts payable. Debit amounts should be display with an "-". We change the transformations (e. g. CASE WHEN BSEG.SHKZG = 'S' THEN -1 ELSE 1 END) * BSEG.WRBTR...), but it doesn't works. What should we do?

I created an action flow which gets data from the data model and creates a pdf file every day. In the second step it sends the pdf to my email adress. Once in a while the data load doesn't succeed. So the pdf send by the action flow is not up-to-date (data is from the day before). I tried to put a router in between and have two email options. One for the pdf and one with an error message. As a filter I used "now earlier than addHours( timestamp ; 24 )". How could I get the time of the last data load as "timestamp" in this filter?Thank you so much!

I am having issues transferring data to an SFTP server from a Celonis Action Flow and am wondering if anyone has advice/best practice on how to mediate: Twice a week, we are attempting to send data to an SFTP by aggregating the data to JSON & sending it as a .json file to an internal SFTP server via the SFTP module in action flows (string below).Unfortunately, we get the below error with the SFTP module with respect to our internal SFTP server when the .json file size gets to around >10KB. Everything I've seen below that size seems to process as planned.See below for a successful execution (usually for file sizes < 10KB): Our current error handling is to send the file to myself and I handle the transfer manually, but would appreciate insight if any others have experienced this issue/would be willing to share a solution that doesn't error out on larger files. Thanks in advance! cc:@Tyler Barnett​ @Kevin Cargill​  @MK Greenberg​ 

I have deleted celonis account by mistake and I can't recreate my account with my working email because the sign up email kept telling me that I have an account at celonis but I can't log in because the account is already deleted

End users usually have a problem identifying which environment they are currently using. One option is by clicking switch team which shows the name of the current environment, but it is a straightforward way.

Specifically, I am looking for hosting (data residency) options in UK region. Attached file (found from Celonis official website) says that Celonis EMS is available on Azure only in UK, but if it is available on AWS marketplace, will we be able to host it on AWS cloud within UK?

Hello, I would like to know if there is any way in which when adding data to my excel sheet, the information is also updated within my visualizations in celonis.

In the below image I want to freeze the buttons of years so that when I scroll down or up the buttons of years would remain constant on the same place. Please advise. 

I am making a pie chart, but the pie itself is too big and keeps on growing when I resize the chart. As a result, I can't see the labels. How do you resize the pie of a chart?Thanks

Does Celonis have connectors for ADABAS-NATURAL? If not, are you aware of any projects whereby extractors were built to extract data from ADABAS-NATURAL? Thank you.

Hi Celopeers team, I have a requirement where the user needs see the data as a matrix (like a image) Basically the user needs to see the trend of various KPIs for specific dimension over time. the request is in a View someone knows, how can I do it? Thanks 😉

I have 2 columns with timestamps and I need difference between those timestamps as 3rd column and I need a single KPI as avg(3rd Column). Can anyone suggest the pql formula for that..?

I have 1 case table and 3 activity tables in the data model. Its a Multi-event log model. All are connected with SalesOrder#. Case tale is 1:N with all the 3 Activity tables. The problem is, if I enable the ' EventLog AutoMerge' and then if I run the Data Load, I am getting the error as "AUTOMERGE: Stopped traversing join graph at activity table ["ActivityTbl_1"]. Is this activity table associated with the wrong case table?". AUTOMERGE: Stopped traversing join graph at activity table ["ActivityTbl_2"]. Is this activity table associated with the wrong case table? Performing eventlog automerge, but no eventlog can be merged with the target eventlog."  If disable the ' EventLog AutoMerge', then the data load does not throw any error.  Can you please help me 1) To resolve the above issue 2) Is it necessary to enable 'AutoMerge' and if yes, why? Thanks in Advance!

For example, work packages 1 and 2 have not been completed, only work package 3, and I can only find out that the process could not be completed and that work package 3 was before the end of the process. Unfortunately, I do not see that work packages 1 and 2 were not completed at all and are the reason for the cancellation of the process. Is there a way to find out in Celonis exactly which work package is responsible for the process not being completed? So that the example shows me that work packages 1 and 2 are responsible. Thank you very much!

Activity frequency show that tha activity change material occurred once 

Hi,Let's say, i have a Employee table, with 3 fields, Name, EmpID Location. It has 1000 records.Now, the requirement is, i should keep a OLAP table or something that sort of in View and in should have all the values of these 3 fields.Now, after i created the report and send it to Management, they should have the provilage to change any value in the VIew itself and that should go and update in the Celonis Table itself. Is that possible? Eg: Name, EmpID, LocationJohn , 1000, USAPeter , 1001, UKHenry , 1002, UAE. Now, from the View itself, if the client wants to update the Location of USA to 'America' in the front end itself and press okay, then the values should be updated in the view and underlying Table in the EMS. Is this achievable ?