Product Q&A

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?(I am assuming that Gmail side parses the HTML and may alter the tags.) I

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? 

I want to add a component filter to my chart in studio analysis that Filters it to only show values between 08:00 and 16:30. How do I do this?

I have a process with mulitple QUEUED per caseI want to find the last QUEUED, and find the first 'INPROG' directly after the last QUEUED.There could be many INPROG, so I don't need the LAST_OCCURENCE() - which does workIs there a NEXT() row kind of option? I tried this, but is not allowed AVG ( CALC_THROUGHPUT (  LAST_OCCURRENCE [ 'QUEUED'] # event X  TO  LAST_OCCURRENCE ['INPROG'], # I want the first event after X, not the last in prog, but the first INPROG after LAST QUEUED  REMAP_TIMESTAMPS ( "eventlog"."timestamp" , MINUTES ) )) Tried also with ACTIVITY_LEAD but that is also not possible AVG ( CALC_THROUGHPUT (  LAST_OCCURRENCE [ 'QUEUED']  TO  ACTIVITY_LEAD ( "eventlog"."timestamp",1),  REMAP_TIMESTAMPS ( "eventlog"."timestamp" , MINUTES ) )) Is there a option to calculate this formula and show it in a KPI Olap table? 

Could you please suggest learnings for PQL beginners? I need to learn more about it.

Hi All! I'm wondering if this is possible in Celonis to build custom attribute (not based on any table) through which I can iterate and calculate pu functions? I want to create record which can be used for reporting purposes (extracted using PowerBI connector).In this record I want to see KPIs per month. For KPI calculations I'm taking into consideration multiple factors including dates (entry date, clearing date, etc.), so I can't build this column only base on one date field. I was thinking about creating attribute, which will contains specific range of dates (not based on any SAP table) and then, base on it, iterate by all those dates in range and set up pu functions using those dates as variable. I was trying using RANGE, but I was getting error that there is no common tables between range and for example BSEG (from which I'm taking date to compare to result of RANGE function): Time dimension in record: var_date One of the filters in PU function: "BSEG".&q

Is it possible to dynamically make an OLAP table component column visible / invisible based on a variable? Also, is it possible to make a KPI component visible/invisible based on the same variable?The objective is to use one Analysis but limit certain data from being displayed for different end-customers? I know I can filter component by the customer name but I haven't found any mention in the ONLINE HELP on dynamic visibility of components.

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.

Can we Add Color in Process Explorer(Views) for Particular Activities as needed?

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.?

Can we Change the FONT Size or Style of KPI Names and Table or CHART Title Names in Views?

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!

We have a problem where we are using a case when statement to derive columns with aggregated buckets. When we try and group the buckets into case numbers, it groups the entire count of case numbers into a single bucket. Rather than splitting the data into multiple different buckets. CODE USED------------------CASE WHENSUM (  CASE  WHEN "TABLE"."ABC"='A' AND ACTIVITY_LEAD (CASE  WHEN ("TABLE"."ABC" IN ('B')) THEN "TABLE"."ABC" ELSE NULL END) IS NULL THEN 1 ELSE 0  END ) between 1 and 5 then '1 TO 5' ELSE '6+' END