Product Q&A

Hello, I would like to automate the entire user access process like adding / removing/editing users and then adding users to the user group assigned. Any thoughts or leads if any of you worked on it? Thanks in advance

Hello All,We want to setup a action flow to refresh 1 table from a data model. Is there any way to do it using action flow? Thanks in advance.

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

Good morning! I want to do a filter like the picture (this are the filters used in Conformance Checking sheet in Celonis Free Plan, in this sheet I can't see the format of the filter or change nothing), I try replicate but I can't do it. Could somebody he

Hi all, I have a drop down list in my analysis with multiple values, but I want one value to always be selected and you must not be able to deselect that specific value. How do I do this?

Hello all, I would like to compare how certain attributes of selected cases compare to the overall share of cases with that attribute. For example:All cases have a certain color. I would like to know what is the share of each color for my selected cases compared to the share of that color for all cases. The result should look like (simplified):Color | Selected Cases | All Cases | Differencered | 15% | 30% | -15%green| 85% | 70% | 15% Therefore I created a OLAP table with the dimension "color" and the following KPIs: The KPI for my selected cases is:(COUNT ( DISTINCT "table"."case_id" ) / GLOBAL(COUNT ( DISTINCT "table"."case_id" )))-> works fine For all cases the KPI is:PU_COUNT_DISTINCT (DOMAIN_TABLE ("table"."color"), "table"."case_id") /PU_COUNT_DISTINCT ( CONSTANT(), "table"."case_id")-> which also w

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.