Product Q&A

I want to sum only distinct values. And here´s my problem. I created a variable with the order and the position of the order (CONCAT VKBEL & POS). And now I want to SUM the amount of the order quantity of all variables. But the variable occurs more than once. Is there a function that only sum distinct values? Thanks in advance for any ideas.

We're working with make to stock so the direct date difference between receiving (101) and sending (261) movements will not work.

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 everyone. I'm working on a project that we have the following scenario: Extractor Server is running on a Virtual Machine, that has access to an SAP system, and we have an uplink connection between Celonis Cloud and Extractor Server. This is working fine during working hours, let's say 9-to-5. However, due to resources saving, the Virtual Machine is running just 08 hours a day. And some tables take up to 13 hours to extract (full load). Suppose that we start extracting data at 8 am: RFC Call => Job Running on SAP => Generating files from 0...N => Extracting to Celonis => Repeat. Then at 5 pm the Virtual Machine shuts down. What will happen to the files generated after 5 pm on SAP? When the Virtual Machine is up again, Celonis will recover the work from where it stopped or we need to start it over again? It happened on our project during a big extraction, we had to cleanup the files manually (Report /CELONIS/CLEANUP) and start extraction again, since Celonis didn&#

Hello everyone,  I have a problem with events that I have excluded via analysis settings. In the script I have mapped activities with NULL as follows:  FILTER "CEL_LBU_ACTIVITIES". "ACTIVITY_DE"=REMAP_VALUES("CEL_LBU_ACTIVITIES". "ACTIVITY_DE",['Order Confirmation', NULL],['Order Receipt', NULL],['Message Accepted', NULL], ['Change of Processing Location', NULL]); It has been noticed that this line is not sufficient to completely remove the activities. The Process Explorer, Case Explorer as well as SOURCE()/TARGET() functions still contain these activities. I did not want to change the data in the database and hope that there is a simpler solution to the problem. Maybe someone can tell me how to remove the activities from this analysis. Many thanks Laura

I'm curious as we only have limited consumption in the instance and we're using live data connection. I can think of two approaches:  One is to schedule a job which executes full load at a given time but that would be setting it up with certain parameters before scheduling so there is still manual work every now and then. It also involves the source system so I wanted to know if - two, it can be done just within Celonis, is there a script which can be scheduled for execution and checks whether tables have exceeded the set scope (e.g. one year). I understand this might have to be customized for different process blocks but this kind of optimization would be really helpful and I'd like to know if there's already a process/ template being used.

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.

Webinar: Driving Sustainability With Procurement With environmental concerns taking center stage globally, Procurement departments are in a unique position to help organizations move from initiative to action.  Join our experts to learn about the relationship between Procurement and sustainability — where we’ve been, where we are, and where we’re headed — as well as ways to power your team’s future sustainability practices through data-driven decision making.  Register!

I need to see whether Celonis 4.0 is still a deployment mode option 

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, If I have a process that includes macro-activities, which include various activities within them, is it possible to have a view of the macro-process and the sub-process? To better explain , I am attaching an example image, in which you can see that both the Macro-Activities and the Activities are listed in the activity table, and the ideal view that I would like to obtain is on the right. Thanks for your attention and for those who will be able to answer me.

How can I add further collueagues to a certain project in the project hub? Thx for advice in advance, best, Bernhard

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!

Dear All, Im new to the community, so sorry in advance if the question is obvious or not relevant. looking for a tool/feature embedded or not to ease configuration transport from sandbox to productive environment, in order to avoid to break the last operational config in production. regards Maxime

Fellow Celonauts, Im curious if the Celonis IBC has the same authorization object capabilities as on-prem version 4.5. Ive been scouring the documentation and team settings in Celonis snap, but I dont see any mention of authorization objects or a place to configure the authorization key queries. We have recently undertaken a substantial project to align our on-prem instance of Celonis with our global reporting and analytics security standards using table-based authorization. Were looking to upgrade to the IBC in the next year, but if we cannot migrate the current table-based authorization setup to the IBC this could be a major problem for us. Thanks for any insight! -Tyler

Hi Team, Is there any way we can extract the data model load status logs from Celonis. Could see some configurations to extract ACCESS_LOGGING and LOGIN_LOGGING from Celonis logs. Looking for similar configuration set up steps to pull the data model load status logs from Celonis Application. Any help on this is highly appreciated. Thanks, Aashik

Hello Cummunity , Using Python , how i can replace the existing usernames with the new username ? Refering to [1.0.0 / User Management & Permissions] on help celonis de , i extracted Old User Details , and i I already have pandas data frame with Old_User ID , New_User ID , Old_Username ,Old_First Name ,Old_Last Name ,Old_Email , Old User Group , how I can use this dataframe and simply replace old user id with new user id keeping everything else same using Python. How can i do that ?