Product Q&A

Hi All, We have a requirement to load a few data models in parallel. Currently our celonis system allowing the data model loading in sequence. Is it possible to load 2 or more data models in parallel? Thank you.

Hello,I look everywhere and seem that theres no way to perform a negative like in a statement.Im trying to create a save formula by doing something like the following example:CASEWHEN VBAK.VKORG = E100AND VBAK.VTWEG = 11AND (ISNULL(VBAP.ABGRU) = 1 OR VBAP.ABGRU IN (, 50, 99, Y8))AND VBAK.AUART IN (YOPA, YOPB, YOPD, YVPE)AND VBAP.BS_UNIT_TEXT NOT LIKE %CS%THEN ProductWHEN VBAP.BUKRS_LAND1 = USAND VBAP.ABGRU = AND VBAP.DIVISION = SSIAND VBAK.VKBUR IN (BIL4,BNJ4)AND VBAP.PSTYV NOT IN (YFP4,YOP4)AND VBAP.BS_UNIT_TEXT NOT LIKE %CS%THEN ProductWHEN VBAP.BUKRS_LAND1 = USAND VBAP.BS_UNIT_TEXT LIKE %CS%THEN ServiceELSE UnclassifiedENDIs there any workaround that let me use this type of approach?Thanks in advance.BR,Joo Bu

Dear Celonis Community, We would like to implement Use case: O2C - On Time Delivery Prediction on our on-premise AS which is version 4.5 We checked the sample coding but it seems its prepared for cloud, Unfortunately we couldnt adapt sample use case for our data. Many thanks in advance, Best Regards, Vahide.

Hello to Everyone,I have a question related to PQL,In one of the analysis, I am using the Input variable where user can enter a number which written to assigned variable.However, I want to do a check here,When the user doesnt provides any input or deletes the already assigned value, the variable value becomes NULLHow can I write a PQL query to check if the variables value is NULL, because when it will be NULL, I want to assign a hard-coded value to it.Like:CASE WHEN ISNULL(<%= test_variable %>) = 1 THEN 100 ELSE <%= test_variable %> ENDThis is the logic I want to use however, I do not know how to construct this query,Any help or ideas will highly be appreciated. Thank YouBest Regards,Khushboo

I am trying to get the total count of ticket between submitted and Completed and also workdays W-6 to W-14I am using the below code but am getting error , could you please help me how to get between W-6 AND W-14WHEN ("_CEL_REMEDY_ACTIVITIES".WD_NEG=WD-6) BETWEEN ("_CEL_REMEDY_ACTIVITIES".WD_NEG=WD-14)(CASE(CALC_THROUGHPUT(FIRST_OCCURRENCE[Submitted] TO LAST_OCCURRENCE[Completed],REMAP_TIMESTAMPS("_CEL_REMEDY_ACTIVITIES".Task_end, Days))) > 5THEN1ELSE0END)

Hello, i have uploaded the input data through File uploads option within my data pool and i havent connected to any Database / connectors. Now when i created a data job and tried to do extraction task, it requires a data connection to do extraction. My question is how to do extraction task with just file uploads and not a data connection setup? is it even possible ? or do i need import the data to a database and do the extraction? please help

How to analyze your Cash Preservation Process for SAP in Snap The Cash Preservation Quickstart is the first step of your process mining journey with Celonis! With just a few clicks you can learn how to preserve cash within your processes. Simply export the relevant data from your SAP system to start your analysis. In order to use this Quickstart you need to request the Cash Preservation SAP extractor first to export your data from you SAP. This is applicable only for: SAP ECC 6.0 or higherS/4 Hana on-prem How does it work? First, navigate to SNAPThen click the New Analysis button 1.11919970 174 KB Click the title for Cash Preservation 2.11919970 128 KB Extract data from your SAP system In order to visualise your process, you first need to extract the relevant tables from your SAP system: Enter the company codes you want to analyse and request your Cash Preservation SAP extractor (ABAP report)You will receive an email with the Cash Preservation SAP extractor and a documentation on how

How to analyze your Accounts Payable Process for SAP in Snap The Accounts Payable Quickstart is the first step of your process mining journey with Celonis! With just a few clicks you can discover your Accounts Payable processes. Simply export the relevant data from your SAP system to start your analysis. In order to use this Quickstart you need to request the Accounts Payable SAP extractor first to export your data from you SAP. This is applicable only for: SAP ECC 6.0 or higherS/4 Hana on-prem How does it work? First, navigate to SNAPClick the New Analysis button 1.11919970 174 KB Choose Accounts Payable 2.11919970 128 KB Extract data from your SAP system In order to visualize your process, you first need to extract the relevant tables from your SAP system: Enter the company codes you want to analyze and request your Accounts Payable SAP extractor (ABAP report)You will receive an email with the Accounts Payable SAP extractor and a documentation on how to use it. Note: ABAP reports ar

How to delete your data in Celonis Snap? You can delete your data in Celonis Snap in Event Collection. First, navigate to SNAPClick the Event Collection button Screenshot 2021-04-08 at 18.08.4916771018 163 KB Choose the data pool you want to deleteIn the data pool, click Click Delete Screenshot 2021-04-08 at 18.10.441660445 45 KB Confirm by clicking Delete Your data will be deleted Screenshot 2021-04-08 at 18.13.291666704 52.2 KB

Hello ,I have a question regarding the REMAP_TIMESTAMPS function.How can I avoid, that the result of the REMAP_TIMESTAMPS Code below is rounded:REMAP_TIMESTAMPS ( HOUR_NOW ( ) , HOURS , THURSDAY TUESDAY MONDAY FRIDAY WEDNESDAY )Many thanks in advance for the support.Best regards,Jonas

ServiceNow Celonis Snap gives you 100% transparency into your ServiceNow Incident Management Process for free, and with no installation required. You can choose to export your ServiceNow Incident data manually (see Manual CSV data export) or allow Snap to extract the data for you. This feature allows Snap users with few clicks to connect to their system or upload their data and start analyzing their data. How to use the Quickstart for ServiceNow? First, navigate to SNAPThen click the New Analysis button 1.11919970 174 KB Choose Incident Management (servicenow) 2.11919968 126 KB To set up Automated data export, you need to enter: Your ServiceNow usernameYour ServiceNow passwordYour tenant or URL (the URL you use to log in to your ServiceNow account) 3.331919969 160 KB The picture shows an example on where to find your ServiceNow credentials and tenant url. Wait until 100% and this analysis will be created automatically for youClick on it to open it and start analyzing your data 419209

Hi , I am trying to create new connection to my on-prem MS SQL Server Database with database type as Microsoft SQL Server(native) database type but getting an error Connection test failed, please check the Data Connections configuration and ensure that the system is running: Unexpected error when getting connection with timeout . Please see screen shot below . My organization already has Celonis set-up. Port : 1433 image1259847 32.8 KB

Hello,Im looking for an solution for this challenge:We have 3 SAP ERP TablesVTTK (Shipments)VTTP (Shipment Items)LIKP (Deliveries)LIPS (Delivery Items)VTTK is linked 1:N with VTTPVTTP is linked 1:1 with LIKPLIKP is linked 1:N with LIPSI want to count the distinct material numbers per shipment.Count per delivery works fine: PU_COUNT_DISTINCT(LIKP, "LIPS"."MATNR")But I need it per shipment for further calculating KPIs, like this:PU_COUNT_DISTINCT(VTTK, "LIPS"."MATNR")Here I get the following error:No common parent between tables could be found - Please check your schema. The tables VTTK und LIPS do not have a common parent in the schemaWithin the help I found the BIND function. I tought, this can be the solution:PU_COUNT_DISTINCT(VTTK, BIND(LIKP, "LIPS"."MATNR"))But here I get an error in the formula.How can I solve this with a formula und without changing the data schema.Thanks for you helpThomas

Hello community, I want to visualize the development of a Running total calculated as the difference between an input number and an output number (to show the stock). As dimension I use a combination of the calendar week and the year. Since this means that I have a lot of values I would like to show the latest ones only and therefore pin the scrollbar of the line chart to the right. However, this ends up in a wrong calculation of the Running total, since it starts calculating with the values on the right side. That ends up in wrong (negative) values of the stock. Is there any possibility to overcome this issue and somehow pin the scrollbar to the right and still let the Running total calculate correctly? An alternative solution would be to limit the values shown to the latest 20 or so. However, this also ends up in wrong results since the Running total only takes the shown values into account then. Thanks for your help! Example: Screenshot1267319 20.7 KB

Hi Celonis Team, I was wondering if Celonis is planning to prodive the Uplink connectors (JDBC, SAP, etc.) as Docker Containers in the future. To be honest, the current architectur (1 Service for each instance and type) of those connectors is complex (especially, if youre running multiple instances) and the the need for virtual/physical hardware is just a lot of overhead for a middleware. The benefits would be Limited development overhead for building the containersEasier maintainability and scalability on the customer side for multiple connectorsNo side effects and version conflicts with different Java VersionsAlmost no installation overhead for existing docker landscapesEasier upgrades, just replace the image and keep configuration Thank you for your Feedback and best regards Max

The result of the MONTH() function is a number (1-12). However, we would like to show this a jan, feb, etc. Is there a function/way to do this easily (were on-premise 4.5) that Im overlooking, or should I build a custom formula to do this translation?

I need help with a formula.COUNT (DISTINCT CASE WHEN EBAN. LOEKZ = X THEN EBAN. BANFN ELSE NULL END)ORCOUNT (DISTINCT CASE WHEN EBAN. BSMNG! = 0 THEN EBAN. BANFN ELSE NULL END)ORCOUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [Banf ist erledigt]) = 1 THEN EBAN. BANFN ELSE NULL END)Here I would like to make a case distinction.The formula doesnt work that way. There is an error.I want to count my requisitionif eitherLOEKZ = XORif 2. BSMNG is not equal to 0ORif the activity Banf ist erledigt is in the activity table.It is only important that the BANF is counted only once.That means that the BANF should have all 3 characteristics, so only 1 should be counted and not 3.I hope I can get this through DISTINCT.Thanks

Hello, I would like to create a create a backlog KPI. (per week, calculate the amount of cases closed this week minus the amount of cases created this week) Creation date & close date are stored in 2 different fields of 2 different tables. (cases creation & closure are not actually part of the process in itself). At the moment, I can create 2 column charts: 1 chart with dimension = creation week and KPI = Count of cases1 chart with dimension = closure week and KPI = Count of cases I fail to merge this into 1 single chart, with dimension = fixed weeks and KPI = (Count of cases where closure date matches with the fixed week - Count of cases where creation date matches with the fixed week) Is there a way to do this, in the Analysis EDIT mode or through data-model configuration in HANA? I hope this was clear enough for you to be able to support me Thank you for your help, Best Regards Robin

Hi,Im searching for a solution (coding statement example) to identify O2C cases where the same activity was executed multiple times but in different posting periods, e.g. in a third party sales the posting of the statistical goods receipts.The cases where the activity Im interested in was executed multiple times can easily identified viay the process flow selection: activity Post PGR is anytime followed by Post PGR, but how to achieve a single row which identfies the orders where this activity happened for different posting periods. As the timestamp (e.g the month) of the activity doesnt necessarily equals the posting period Ive already added the posting period to the activity table. Does anyone can help me with this, ideally I want to show in the analysis the first or last posting period together with the case key ?CheersChris

Hello, How to calculate the sum of 2 single KPI components which are using the same function to provide the result but with different filters, and the filters are also using different tables to get the filters.

Were trying to create a chart with a line per year (e.g. KPI x in 2019, 2018, etc.).In Celonis this means adding one KPI per year. (if not, please advise how!)How can we easily filter the data within a KPI definition, for instance like such (which didnt work obviously):FILTER YEAR(table.column) = 2019; KPI_X()Our current approach is to extend KPI_X with a parameter (Year), which is used as a filter in a CASE WHEN statement within the KPI_X definition. However, it feels like a complex solution to a simple problem. Hence this sanity check question, whether were overlooking an easy route.BTW: were on premise, version 4.5

Hi Team, I have a case management process which i have divided into case creation, case resolution, case closure etc. I need to run separate conformance models for all of these by applying a crop selection filter across each stage. In my reference model I have an activity(B) that can happen either before or after Activity(A), both the sequences are valid, However my crop selection for setting the scope of the phase is starting from Activity (A) which is ignoring the cases where Activity (B) has happened before(A). Is there any way to include those cases as well by making changes to my reference model rather than whitelisting them. Thanks in Advance.

When you upload your XES file using the Snap quickstart and you see something similar to the following screenshot image1272716 52.7 KB then most probably your XES file is missing the global attribute. For instance this is a file that does not have the global attribute and we will have the same problem. image744469 41.5 KB What we need to do here is to add the following global attribute <global scope="event"> <string key="id" value="string"/> <string key="org:resource" value="string"/> <string key="concept:name" value="string"/> <date key="time:timestamp" value="2017-01-09T09:49:50.000+01:00"/> <string key="org:role" value="string"/> </global> including the columns that we can find from the event attribute to our XES file. We can open the XES files with text and after adding the global attribute its gonna look like the screenshot

Hi, How would I write a filter on a table to show all activities preceding a specific activity, along with the frequency? Basically, what the process explorer fullscreen analysis shows.

Hi all. Is there an option to format the 1st column in a Pivot Table (dimensions) ? When it comes to drill down to more dimensions or the text in one dimension is > 25 characters is not readable (e.g. using small size 13px)