General Product Q&A

Hello Everyone, Hope you all are doing great! I have a use case where I am trying to use an action defined in knowledge model, to send email to the user. For that After defining the action in Knowledge Model, I assigned the skill to it. Now to send emails we have to trigger an action flow (due to specific requirement) after assigning the skill the respective action flow, I have create an action flow starting with custom webhook. The scheduling mode is immediately and the action flow is set to active. Now when I trigger the skill from a button that I created in my View after enabling row selection in the table settings, the skill runs successfully but the action flow doesn't trigger, I tried many times and once in a while when I deactivate and activate the Action Flow again, it ask for processing the data in queue. But when I again try to trigger it from view, skill runs but action flow doesn't.Has anyone faced this issue, am I missing something here. Please help me out here. Re

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?

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 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.

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 ?



Can any one advise if I could show the label of annotation line on legend unlike other labels of dimension and KPI's?Please see attached image.

I have attached Screenshot. can you please check it once.