Data Ingestion & Infrastructure

Hi all,Im struggling with the following problem.The table structure is as follows:Instance|Task|Instructionimage1165333 21 KBI want to calculate the sum of Nein and Ja over all Pay_Periods. However, I want to exclude the entries where I have double inputs for a month (CREATED_D differs slightly). So, I want to take the latest entry of a pay period (whether Nein or Ja) to be considered.First, I tried to useSUM ( CASE WHEN Instruction.PROCESSOR_INPUT = Ja THEN 1 ELSE 0 END)but I have no clue how to exclude the double entries / just consider the latest ones.Also, I tried something with the following formula, however it didnt work outPU_MAX (Task,Instruction.Manual_INPUT,Instruction.CREATED_D =PU_MAX(Task,Instruction.CREATED_D,Instruction.Manual_INPUT IS NOT NULL))Hope the problem is well explained.Thanks for you support!Simon

Hello all,is there a formula where you can round to any decimal places? I would like to round the formula part in the square box to three decimal places, for example 0.123.image1138107 12 KBBut the total result should be calculated to any number of decimal places.Best regards

We would like to embed our Celonis (CPM4.6) analysis/dashboard in the operational tools.Concretely, we would like to be able to build an URL passing certain parameters (for instance time period, team, etc.).Im envisioning something like:https://myCPM4:9000/#/frontend/documents/123/view/sheets?team=45&startDate='1-1-2020'Would this be possible in CPM4.6?And in the cloud?

Hi all,I want to create a Column Chart which takes sum of amounts of two different tables having period numbers. Attached is the sample data -Expected Output in Column Chart -I tried to create the Column Chart but my values are not coming correct.Is there any solution so that my column chart will take data from two different table and populate the values correctly.Help appreciated!!Thanks,Pooja

Hello Team, I am trying to connect celonis 4.5 with Python referring the below link: https://celonis.github.io/pycelonis/notebooks/00_Connecting_to_Celonis.html Can you please help me understand what value do we have to pass in api_id in the login method. Regards, Poonam

Im trying to create a number KPI that gives the % of cases contained in the top n variants. This would be the number shown in the variant explorer as the % of cases contained in the variants selected (for example, when dragging down to the top five variants in variant explorer, the bubble at the bottom says 72%. I want to use that 72% in a calculation.). I want to be able to use this number in other calculations. Id like for this to be static (not subject to filtering), which I know how to do. Are there internal variables that contain this and other information that is used to create the graphics?I found this reference but its not of much help. I cannot get to the page in any case. Percentage of cases covered by the 5 most common variants - #3 by gvanenisHow would I use the INDEX_ORDER syntax to calculate the KPI Im looking for? Thanks in advance for your help.

Hello and a happy new year,we do have the problem of memory allocation while using several Pull-Up Aggregations. Is there a way to release the memory frequently?Our set up is Hybrid (IBC + Leave your data in place).We have 90mio Activities@8.5mio Cases in one Model and 260mio Activities@24mio Cases in a second Model. The memory consumption is in idle state at 24 GB and moves up to 64 GB when using PU-Functions. This will quite often let the engine crash and models could not be re-loaded even from cache until the memory garbage is cleared.Thanks for any suggestion.RegardsHolger

Dear all, is it somehow possible to access IBC data model Data Permissions from pycelonis? Eg. query the current permissions configuration or set new permissions? image781538 32.4 KB Best, Benedikt

Hi, Im trying to add translations for our PTP data model as requested by the client, however, upon downloading the PTP Name mapping template it says " failed to download PTP Name mapping.

Hi there, I am unable to find how to use a xlsx or csv as a filter criterion during extractions. I want to set an extraction parameter but the list of values is fairly long and I dont want to type every value in there manually, but reference an uploaded xlsx. Is that possible and if so how do I do it? Thanks and best regards, Carl

Hi, I am wondering how I could create a bubble chart with multiple bubbles on a single line, as it is shown in the photo attached.I have been trying to use PU_COUNT, but the parent and child tables do not have the same columns, which made me difficult to distinguish the sums depending on the number shown in the graph.Best,chart846524 21.7 KB

Hi all, I would like to install the Python library 'pyodbc' in order to extract data from a database using a custom database driver. However, I get errors when I try it to install via PIP. I found out that this could be caused when the ODBC header files are not installed (link). To do this, a sudo command is neccessary which requires admin login credentials for the jovyan environment. Since these are not shared, can somebody help me to solve this? Thanks in advance! Cheers,Jan-peter

Hi all,I would like to combine the MERGE_EVENTLOG() and PULL_UP functions, but am not sure how to do this. See the full problem description below.We are looking at a use case where we want to visualize the customer interactions during an order. We are here combining two case tables and two activity tables, using the Multi Event-Log (MEL) functionality:Celonis Data Models-MEL Simplified (2)841231 6.7 KBThe first Case and Activity table represent Events logged on a customer_id level (red)The second Case and Activity table represent events logged on an order_id level (orange)We succeeded to create an OLAP table where we count the number of inbound interactions during a order, i.e. interaction timestamp falls between order_start and order_end. We therefore used this code:SUM( CASE WHEN DATE_BETWEEN ( <%= MergedTimestamps %>, PU_FIRST("order_case_table", "order_activity_table"."order_timestamp"), PU_LAST("orde

Hello Team, I wanted to monitor few data pools and I have already enabled "Custom Monitoring". I wanted to build some KPIs and analysis on daily APC usage. Can I get to know more details on how I can build the KPIs and analyses? I kindly request some more detailed information on this topic "Custom Data Pipeline Monitoring". I have already went through the help page on Celonis. However still need some more information. Best Regards,Aditya

Hi all I have been getting this decompression failed data load error on my on prem 4.6 environment. Has anyone seen this before/ know the steps on how to fix it? Any help is appreciated as we are not able to access our analysis.

Hi all, I try to add a data service link to a OneDrive folder automatically searching for the PO number. SO I've did the following:Created normal variable "PO": "EKPO"."EBELN"Added data service link to an OLAP table with: OneDrive Link...414D1&view=7&q=<=%PO%> (so added the variable add the end to search for that problem: Opens OneDrice and searches for "EKPO"."EBELN" as text but not the Purchase Order number When I use a static variable then it is searching for a Purchase Order number, but not the right one, it is a static one. How is it possible to search for the Purchase Order number for that line in the OLAP table? Thx and brDaniel 

Hi to all,if you create a transformation job like this:INSERT INTO _CEL_P2P_ACTIVITIES () SELECT * FROM Sorting = 10;INSERT INTO _CEL_P2P_ACTIVITIES () SELECT * FROM Sorting = 20;INSERT INTO _CEL_P2P_ACTIVITIES () SELECT * FROM Sorting = 30;INSERT INTO _CEL_P2P_ACTIVITIES () SELECT * FROM Sorting = 100;The table _ CEL_P2P _ACTIVITIES will only be inserted completely AFTER FINISHING the whole transforming job.There is no way to measure the progress during the running transforming job, e.g. byselect _SORTING,count(*) from _CEL_P2P_ACTIVITIES group by _SORTING;If you are not going to seperate the transforming job into several single transforming steps, is this behaviour correct?Is there no way to commit every single step ?Thank you in advance

After accumulating 2 years of data in our data O2C and P2P data models, Id like to setup a regular cleanup job to remove all data older than 2 years from the data model. Are there any best practices to do this you could share with me?

hello, i need your help with a formula.The following formula does not yet work 100%.COUNT (DISTINCT CASEWHEN /RWEE/PMCP_TAUFK.SLATX LIKE S -% - S% THEN T_CEL_AT_HP5. AUFNR1WHEN MATCH_ACTIVITIES (T_CEL_AT_HP5. TXT30, NODE [Outlook: finished message sent]) = 1 THEN T_CEL_AT_HP5. AUFNR1ELSE NULL END)In my opinion it does not matter in this formula which of the two conditions applies.I would like to have the formula changed so that both conditions must be met.What needs to be changed in the formula?thx

Dear Colleagues,I need to create a date picker component, which would filter the PO items that had any of selected change activities within selected time period (for example monthly).I have created a variable that stores the list of change activties that user select.image382547 12.4 KBI cannot use PU_FIRST(EKPO,Activity_eventtime, Activity_name IN (Variable)) as this returns only the first eventtime of change. I need to select all PO items that had any of selected changes within given period. Can you please help me how to do that?Thank you.

Hi,Could you help me to find the average of timestamp like avg(timestamp)?I have job execution end time like below and interested to find the average execution end time:Sun Sep 6 2020 18:30:25Sun Sep 6 2020 8:30:28Sun Sep 6 2020 20:36:25Sun Sep 6 2020 08:00:26Sun Sep 6 2020 05:45:11Sun Sep 6 2020 22:14:01Thanks in advance!Best Wishes,Deepak

Dear Community,I am creating an OLAP table and a throughput time chart in my dashboard. When i compare the 2 results against each other I receive different results. Does anyone understand why this is happening?My OLAP dimension is company code. And KPI is: AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Scan] TO LAST_OCCURRENCE[Posting invoice document], REMAP_TIMESTAMPS(ACTIVITIES.EventTime, HOURS)))This gives me a result of 405 hoursMy throughput time chart is:I am using first occurrence of scan and last occurrence of posting invoice document in both scenarios and have selected 1 company code.Does anyone understand what is causing this output difference?Thanks,Anna

HI All, I would like to know if there is any option to have a an automated email sent to the admin on data load status. We would like to have a daily load to start with and would like to get notification weather the load finished successfully or not. Thanks Naveen Gupta

Hi Celonis Community! While configuring SAML for SSO you can specify the required AD group that contains users that can SSO into Celonis. According to the documentation, on the config-custom.properties file there is a statement to indicate the AD group that SAML will use: saml.users.requiredgroup=MyADGroup Question is could MyADgroup have nested groups?

We are implementing Celonis and we want to use single sign on via SAML. We set up an Active Directory group for auto provisioning and when we add users to the group, it does not sync with Celonis and create an invitation that is sent to them. Any insight would be great! I am not sure if Celonis or my companys computer security folks need to resolve this. Thanks!