Product Q&A

i want to push data using the continuous-batch-processing/api using this function   def push_new_chunk(self, dataPoolId, tablename, file_path, primaryKeys, table_schema, fallbackVarcharLength = None):    api = self.get_jobs_api(dataPoolId) + "/items"    payload = {'targetName': tablename, 'primaryKeys': primaryKeys           ,'connectionId': self.connection_id, 'fallbackVarcharLength': fallbackVarcharLength         ,'upsertStrategy':'UPSERT_WITH_NULLIFICATION', 'tableSchema':table_schema}    headers = self.get_auth()     file = {'file': open(file_path, 'rb')}    return requests.post(url=api, params = payload, files=file, headers=headers) tableSchema is defined as per the celonis documentation here: e.g. thats how my tableSchema looks like in python before pushing: table_schema = {  "columns": [    {"columnName": "CreatedAt", "columnType": "DATETIME", &quot

Hi Everyone We are looking into the use of Celonis for SAP SuccessFactors, is this possible and do we have any connectors available for the use case? Would also like to know what the typical event log would log like for the following modules if that is possible:EC (Employee Central)On/Off boardingSuccession planningRecruitment Thanks in advance! 

I need some help. I might be over complicating this, but I would like to see the following KPIs in one bar graph: Each KPI has one less "OR" as we move up in numbers, but this is the KPI for the last number: In other words this is the KPI and corresponding PQL code:  KPI 1:KPI 1 - corresponding PQL code: KPI 13 (last KPI on the list):   KPI 1 - corresponding PQL code: 

which SQL is used to build transformation scripts? is it possible to adjust template coding for predefined process? is it possible to join transparent and cluster tables (BKPF/BSEG, CDHDR, CDPOS)? how flexibly filter conditions for tables be applied?

Background info: I have a data transformation script called "Preprocessing'. In that Script, some SQL operations are done. Afterwards, i retrieve the resulting tables in the ml workbench to execute statistical python operations. Then, the result is uploaded back to Celonis where another data trasnformation script called 'postprocessing' enriches the data for visualization. Currently, the python part takes 4 hours to execute as i execute levenhstein ratio for a very large dataset. So my idea is to use delta loads in order to reduce the amount of operations. Thanks for your help!

I see where I can have the module look for a file in my OneDrive, or a Teams/Sharepoint location. How do I route the module to a network drive?

Hi all, I have an issue with the Case explorer in the new views. It is currently showing how long ago the activities happened for a selected case. I would like to configure it to show the time between activities. Is this possible?

Is there a technical way to export backups of processes/data model in Celonis so that we can restore them when necessary?

How to create an embedded view in the new views

Is there any way to somehow connect one filter with one specific process explorer instead of filtering both simultaneously?Was trying with the YAML editor, but with no success.

System: SAP S4/HANAApp Name: Accounts receivable Starter Kit Section : Value Discovery App  undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES cannot be found.

one of the main inconvenience for me in the new studio is that it does not allow me to use color with dimension in the chart. For example, earlier it is very easy to plot e.g. KPI xxx in the time series chart and use e.g. country dimension to color the KPI . Now i do not see this option to use dimension in coloring. any advise?

I want to use certain ML libraries that require python 3.9 or higher to work properly, but my MLWB is on 3.8.6, is there a way to update it? If so, how?

Is it possible to do User credential configuration on the dashboard levels

Hello peers, I want to translate the names of individual activities in my model from German to English.  Using the name mapping functionality I am able to change the names of the tables or columns as desired. When using the translate feature in the EMS, I am able to change the display names of the various objects like KPIs, records etc.  Both these methods do not facilitate the translation of activity names. Is it possible to enable this translation and how? Thanks in advance! 

Hi,  Do you have any proven method for getting ALL task related to record? I know there's action flow allowing to get details of a task for specific record it, but first I would like to get all of them. Best would be to upload that data into table.  I know about legacy view task list, but it's no viable and we cannot wait for implementation of that component into new views. Best Regards,Mateusz Dudek  

Hello. I work as a data analyst in a logistics warehouse, and I am totally new to Celonis and not very experienced in SQL servers either, but I was given the seat, since former analyst has retired.My task is to create a Item-weight master that daily updates unit weight , with average of unit weight calculated from 10 most recent weighted record. Since there are no RANK or TOP functions in Celonis, I am confused how can this be done.Can anyone tell me how is it possible to be done on celonis?  Thank you.

Hello everyone, I'm facing issues while creating a view. I have a grouped column chart. Now I want to limit the number of displayed bars to 6, but scrolling to the other bars in the time line should be possible. When I use the data setting "Allow scrolling," scrolling works. However, when I set a limit in the data setting, I can't scroll anymore, and the displayed time period is fixed.I hope you understand what I mean. Does anyone have an idea how this could work?

Hi team,I am searching for a component which on clicking will take me to another tab in same view.It was possible in analysis using button component (open tab feature).Can you please guide me how can i achieve this in view.Thanks beforehand for the help.

Hey, I cant really find a lot of information about how to use the D3 Format for columns.How do I align a single column to the center here?It says to use "^" but I cant implement it. Thanks!

Eg: I want to assign a value 'Category' to my runtime variable (runt_variable). previously, if the runt_variable has some other value assigned to it, I want to change it and assign it as 'Category' once this is done, the remaining action flow module has to be executed.

Hi All, I would like to know if anyone has any idea on how we can extract data of Action Flows into machine learning workbench using python.(NB: I am using pycelonis version 1.7.2)

That way I could put the link in the button in an Analysis, and the users could click there, fill in some fields, and done - and that would execute the Action Flow with the values of the formular.

How to limit the filter for the one table only in new view?

Good day community, We are having issues with the "Carry Filters" option on Analyses. This feature works very randomly: sometimes the option does not appear at all, other times it appears but it doesn't actually carry any filters, and sometimes it works as expected. I am not able to find any documentation on this specific feature, or any option that could allow me to review what is happening. Has anyone experienced something similar? Does anyone have an idea of what could be happening here? Is there a way to configure/review the "carry filters" option to see if modifying it would help it behave as it's supposed to?Any input is appreciated. Thanks in advance!