General Product Q&A

Can you explain the main differences between using the FILTER_TO_NULL and not using it in a PU function. I see that the results differ for the following 2 functions:  PU_COUNT_DISTINCT (    Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME")   , FILTER_TO_NULL("CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID")   , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>' )  And PU_COUNT_DISTINCT (    Domain_Table("CEL_ACTIVITIES_CMS_COMBINED"."USER_NAME")   , "CEL_ACTIVITIES_CMS_COMBINED"."CASE_ID"   , "Grouping_All"."QUERY GROUPING" = '<%= QueryGroup %>'  )     

Hello Everyone,  I am currently facing the problem that after uploading the ABAP reports for the P2P Connector in Celonis i cannot run the transformation.   basically in the training about the ABAP extractor, they advise to run the transformation after uploading the reports. However as soon as i execute the data job for the SAP P2P full transformations I get the following error message.   I have the feling that the JOB does not find the ABAP reports that i uploaded. or i am missing a step here :(  I appreciate a lot your help to solve this matter. Thank you in advance. Omar

What I'm trying to do is apply a filter in a Query Data bubble based on a dynamic variable. The variable is defined in a view, then the Action Flow is called and the idea is to check for a greater value than the variable in the queried data.  I've tried Action Flow Inputs, but those don't seem to be the answer since the variable can only be updated manually once the AF starts. Also, the idea is to execute the AF from the view, which apparently removes the write-in option for the input leaving it always blank. Can this be done?

Hello everyone, this is probably very easy but I'm lacking the syntax that converts the number format. Can somebody please support me on this?Thank you!Best regardsJulia Bauer

We are extracting data in the Action Flow, formatting the text content of the email using the Excute Process Automation Skill, and then using the Send Email Skill to send the email using the Celonis email server. I have a question here.In the "Excute Process Automation Skill" settings, I have entered the text information I want to convey in "mail_text" and the extracted information assembled in an HTML table. In this text information, I have written a hyperlink (HTML) to link to the Celonis analysis.We sent it to our own email address (Gmail) for test transmission, but the result is that only the link tag has been removed. Only the text enclosed by the link tag is displayed.In other words, only text without a link is displayed. In the log of the sending skill, it is sent as described in the tag.Is it possible to delete the link tag on the Gmail side when the test is received on the Gmail side?

Celonis recommends using on-prem client instead of SAP extractor, so can the architecture used for SAP extractor also be used for on-prem client? If it is not usable, what should we change?

Hello There,Any advise to build pivot table in new view. In analysis we do have pivot table component table itself. But in view please advise.

I would like to create a component button within view that clears all filters that are currently applied. I see within the button component you can set a variable based on existing filters but what would I write in the set value to reset the filter? 

On the MS side, these versions of VC++ are quite old and their support has ended or will end very soon.

On prem client was used for automation. When establishing a new connection with SAP, should I choose SAP extractor or on prem client? If I use on prem client, can I develop all the assets on the studio side? (for example: analysis, view etc.)

Hi Everyone :), i have a list of all Customernumber in an Excel File, how can i import them into Celonis, so that i can use them for a Selection in an Analysis Sheet

I require setup for two schedules:For the monthly load, it should execute once a month on the first Sunday.For the weekly load, it should execute every week, but not on the first Sunday of the month.Currently, I'm utilizing this CRON job for the monthly load: 0 0 7 ? * 1#1I need assistance in configuring the CRON job for the weekly load without causing conflicts with the monthly schedule.

Celonis recommends on prem clients instead of sap extractor.

I want to know how to get the login history data using API. I have created the APP Key and also given the permission to the key but still when i am running it in ML Workbench i am getting pycelonis permission error. Can you please suggest to tackle this error.

P.S. : I have already raised a support ticket which is pending for more than a month now without any reply from the team.

i am trying to enroll for the course: Object-Centric Process Mining: Foundations https://academy.celonis.com/courses/object-centric-process-mining-foundations-1 But there is no enroll button. Any one that can help?

In Views, while creating 2*2 or 2*3 components I can't find any border option between components or even for the entire view border. And also the background is grey in color, is there any option to change the background color in view.?

I have created a KPI to rank all plants based on their Invoice value. I also added two filters to this KPI - one for the top 20% of plants and the other for the remaining plants. Although these filters work as intended at the global level, they do not generate accurate numbers when applied to a specific country or region. How can I resolve this issue

What needs to be done to be able to register opportunities on behalf of my organization?

Hello! We are having trouble selecting a specific dropdown option as the default button, which needs to be visible when viewing a report. The issue is that even after removing other dropdown options that are causing the error, we are still seeing that field as a dropdown option. If anyone has any knowledge or experience regarding this problem, please share your thoughts. Thank you!

Good afternoon, We've got an Action View set up that has an emailing Action Flow attached to it, which will, for each Record Case ID, email a Customer with relevant information. This is not automatic yet, since we need Operations to validate it is working properly. Towards this end, we have been looking for a way to display an Email Preview, through a click for example, so that Operations could visualize the specific email that is going to be sent. How could we achieve this? Thank you very much in advance Best Regards, Vasco

Date         Value  Expected Column2023-01-01   25      252023-02-01  30      252023-03-01  32      252023-04-01  22      22 

I am from Harman India and have a licensed celonis users. We have two instances of Celonis cloud Prod & QA. I have been trying to copy a package from Prod to QA however I am getting the error "Root node with the same key already exists."