Product Q&A

Hello, Is anyone able to share insight into what a ServiceNow Change Management Data Model might look like, i.e. which standard tables are involved and perhaps an example of the associated activity table? What is your experience with using the ServiceNow Change Management Connector and Apps? Appreciate any information or tips, Regards, James

Hi Has anyone created a data model with Ariba Invoice Pro? Ariba Invoice Pro has a separate child realm to Ariba itself If you can help I have two questions Are there any prebuilt connections / apps for Ariba Invoice Pro? Assume this would require 2 data extractions - one for Ariba and one for Ariba Invoice Pro Many thanks Michael

Hello, Is it possible to automate with python Apply Permission Table option in data model data permissions.

Dear All, Could you help me with the following issue? We extracted P2P data from SAP ECC and S4H using ABAP scripts. So I have two sets of exactly same tables related to P2P process. The reason for doing this was, we have different company codes processed in ECC and S4H. Now we we want to upload them using SAP ABAP Output Uploader into one data pool, and finally combine into one data model. Seems like it does not work, because the S4H overwite the previously uploaded ECC data due to the same table name uploaded. thank you in advance Michal

Hi, we are trying to guess how much space which Datamodell is consuming on our server. We are running celonis 4.5 on prem on SLES 12. Any recommendations? The primary goal is to determine how much Space we need round about if we want to switch to the IBC. Thanks in advance Benedikt

Is there a way to search for a particular text over all data jobs, without entering every single one of them? I want to check if and where a particular database column is used in any of the existing data jobs. Thanks a lot!

We need to validate whether the activity table captures all the necessary events and data flows for the PO line items and for that we need to know the ECC application tables used to build the activity table for P2P. I tried checking the CDHDR and CDPOS but I didnt find the one-to-one link between these tables and activity tables. Which all tables are used for building the activity tables for P2P?

Hey there, are there sample event logs available concerning health care processes? For instance patient logistics or patient treatment? best regards, Tobias

Hi! My company is going to do data archiving SAP best practice: store files for no more than 6 months It seems to me that this is not enough for elonis data analysis Can you give me some advice.? How much data can be logged by what type of logs? for FI documents especially

I am new to Celonis. Have udergone the Analyst and Data Engineer trainings. But, i have got a use for Case Management in Salesforce. I have got the list of table names. Need to crete Extraction Settings and Data models. Need help with this.

Ive figured out that Dynamic Parameters, defined within a Transformation Job, only work if the table youre using is in the Global Schema. Does anyone know how to make them work with tables in a specific schema? Thank you. Joaquim

Hello, Can someone tell me about what is the limitation on no. of records that can be processed in Celonis IBC via JDBC connection to a database ? Interested to know the maximum no. of records that can be handled by CASE table, and event log separately. @l.vogel Thanks !

(topic withdrawn by author, will be automatically deleted in 24 hours unless flagged)

Hi, I participated in the Process Mining Expert Program last fall and have a fundamental, technical question about transforming data to create the activity table of a process: In the process of Data Engineering, according to the training, the Activity Tables are filled with the process activities using the jobs insert. Thereby the eventtimes have to be considered because in case of equal eventtimes of two process activities the sorting number must be used to achieve the correct activity order. So it is important to know beforehand how the processes look like and which activity follows when, right? Or is it possible to create a data model without filling Activity Tables, in which case the eventtime data conflicts have to be accepted but the process still becomes visible to a certain degree? An answer would be greatly appreciated. Thanks! Florian

Hello all,i have the issue that I want to join two different tables based on a time filter. Table 1 describes different materials going to different Targets with an exact event-time.Unique-ID | Eventtime | Target 1|Unique-ID | Eventtime | Target 2|Unique-ID | Eventtime | Target 1| Table 2 is a status-table which is updated in irregular intervals (Date_1, Date_2, Date_3..) and contains for each Target a string with either Mode_A oder Mode_B.Target 1 | Date_1 | Mode_ATarget 2 | Date_1 | Mode_ATarget 1 | Date_2 | Mode_ATarget 2 | Date_2 | Mode_BTarget 1 | Date_3 | Mode_BTarget 2 | Date_3 | Mode_A I now want to join table 2 into table 1 and match the Mode-A to each unique-ID based on the condition, that the Eventtime is between the respective Date-Intervalls.  Any Idea how to solve this?

How can we create process models, using BPMN2.0, with Celonis?

Hi team Can any one explain me about the difference between aris process mining tools and celonis tool what features we have in celonis better than aris..

Hi everyone, Is there a way to find out the value that appears most often in the dataset? I could not find it in PQL references. Example Values in a Dataset2221035 In this example, the value 2 appears most often.  Looking forward to your replies. Many thanks and best regards,Thorsten 

Hi, I am trying to utilize Ratio of cases with certain process flow KPI, however I am permanently getting values which do not make sense to me. In attached pictures you can see, there's 221 cases out of 13943 which goes from V stage to V stage (about 1,6 %). However, when I try to get the ratio of such cases using KPI I get result 2,1 %, which is from my perspective incorrect. Any idea what is happening there? Tomas

I have created an OLAP table with a dropdown button where I can select dimension and I have linked the outcome of the conformance check by using:  READABLE (<%= conformance %>). I put a filter on it so that it doesn't include "Conforms". However, it now lists all deviations and I am only interested in the top 3. How do I limit it to only show the top 3 deviations per result?

Hi, in our celonis_integration PostgreSQL DB, we can see 4 different status (cpm_status) of data jobs: "ERROR", "NEW", "RUNNING", "DONE". I would like to understand what does status "NEW" mean? Can anyone help? Thanks!

I have a query regarding sending reports for critical KPIs using transformation center. I tried to navigate through transformation center but couldn’t find any such option where I can scheduled reports.  even tried to check help support section of Celonis Below screenshot is perhaps of the older version of transformation center which is there on the help page.   It seems older version of transformation center was having different interface and there were these option of sending weekly, monthly or daily reports.  Note : There is a possibility to use the Action Engine to create reports but would prefer to use the report function of the transformation center.  Any help will be appreciated.

Hi,Is there a way that my filters from one dashboard can also be applied to another dashboard? For example, in my first dashboard, I filtered 2-3 dimensions and now I wanted to analyze in another dashboard those dimensions again. It could be placing a button to navigate to the link in the 2nd dashboard, but the selections filters are left behind in the 1st dashboard.

I have a column chart component which displays for each status(activity) the number of cases for which this activity is the last per week. So in dimensions I have this kind of expression ROUND_WEEK("ACTIVITIES"."EVENTTIME") but I want to display for each week for each status(activity) the number of cases for which this activity is the last and from a week to another I want to sum the cases which have not moved to another activity. Is there a way to do that, so in dimensions I want to have a kind of calendar of all weeks and then according to the date of the activities I want to display what I explained above. Thanks in advance for your help !  

Hi there, intuitively I would have thought that this checkbox selects values that are NULL but this was not the case when I tested it. So what does it do? Kind regards,Sasa