Product Q&A

Are there any Best practices for Naming conventions for: For Data Integration: Tables / Views / Extractions / Transformations, etc.

Hi there,I have an analysis, that can be dynamically adapted with the help of variables, and I would like to create an Action flow (or skill) that sends a pdf Report of the analysis in different configurations. While the "Create PDF Report" module has an option to set filters, I was unable to find a way to set variables for the analysis.As a workaround i currently create copies of the analysis/sheets, save them in the desired state and use them to create the pdf. However, I would appreciate if someone knows a cleaner solution. Best regards,Joshua

Is there a demo execution app for procurement? The demo instances on TryCelonis on Procurement seem to be largely the traditional analyses.

Hello Peers, with the Celonis academic license I can't create on-premise extractors, while I can do it with the training licnese. Is this normal? What license would I need instead of the academic?

I created a custom "Process Explorer" KPI to show % ie Activity Count over Total Activity Count. This works fine when there are no selections made on initial launch of but when there is a selection made on a OLAP table the KPI goes blank. Please advice.

Hi all,  my Question is: is it possible to use a CASE WHEN Statement where the condition is a comparison between a variable and a string?Like:CASE WHEN <%=variable%> = 'value' THEN ... I work in Celonis Studio with PQL and created a variable in the Variables Section. What I want to do is filter a chart component depending on what timespan (hour, day...) I selected in a button drop down. Here is a code snippet:CASE WHEN <%=timespan_picker%> = 'HOUR' THENROUND_<%=timespan_picker%>(PU_FIRST (DOMAIN_TABLE... When I try it like this I get an Error which says: Table not found Thanks for your helpN.

SLA Breach notification - Can Celonis send the trigger notification to pre-defined emails based on the risk or likelihood of missing an SLA target? Ex. SLA for tickets in XYZ queue is 2 hours. 50 of those tickets have not been assigned and are 1.5 hours old. Avg time to resolve a ticket is 45 min. Can an action flow solve for a proactive notification to operations asking them to act on these tickets before the SLA breach?  

Hello, I have build an Action Flow where the result of a query is going in an Gsheet File. I am using the Gsheet action 'Add a row' but after each row i must delay 1 second for each now row. Do you an alternative solution ?

Based on understanding of Vertica SQL/Postgre SQL, following piece of script I am implementing to enable primary key. But even after successful, error free execution of these statements, I can see Celonis allows INSERT with same values. Can you help me in understanding if I am falling short on something to enable primary key? CREATE TABLE _CEL_ACTIVITY_PRIMARY_TEST(    _case   varchar(25),    activity_name varchar(100) not null,    eventime DATETIME not null,    PRIMARY KEY(_case)); SELECT * FROM _CEL_ACTIVITY_PRIMARY_TEST; INSERT INTO _CEL_ACTIVITY_PRIMARY_TEST VALUES ('1234','act1','2022-08-22T09:46:46');

Hello everyone, the uploaded picture shows my current problem. I need to transform an inputtable to get to the correct avg values as my output. 

I get the following error message when I attempt to upload a flat file (csv/excel): "There was an error during file upload. Please check your file type and content". Any suggestion how to fix this?

I am new to Celonis. I am trying to update the SAP extractor in a unix and to begin with i don't have clarity on what commands to use to stop and start the extractor in unix/linux. i see some batch file but they are more for windows and online not much detail are provided. Please help

I'm getting the below error while using connectors for Oracle EBS Connection test failed, please check the Data Connection configuration and ensure that the system is running: Telnet connection to the host ebsval.com:1521 failed. Telnet failure

Are there plans to include the histogram component into Studio / Views environment? Could I recreate the histogram component (incl. explicit boundaries feature) in the chart component somehow?

A skill is being used to extract information from an Analysis via a Jupyter notebook. When executing said notebook, I get the error seen in the picture below:I've been checking the components filters and sheet/analysis load scripts and can't seem to find anything. What really bothers me is the "FILTER" seen alone in the first line. Any help would be appreciated, thanks peers!

I followed the guided tour steps properly and created the correct variables. PS: I need a solution in order to continue the guided tour

Essentially what the question title says, we have a "Button Dropdown" Component that allows the user to switch between which combination of Dimension and KPI he wants to see. The KPIs are quite different (# of Days, Invoice Amount in Euros, % of Rework) and therefore require different Formatting and Units.Formatting example: This is supposed to provide a Decimal Number of Days, but here is what we're getting: I have attempted to simply input the formats in a Variable and call that Variable in the KPI Setup, but the resulting Formatting is not making sense! The units work okay, but it's ignoring the space character ("X Days" VS "X Days") Could you please provide some pointers? Thank you in advance! Best Regards, Vasco Carona

Is there a way to replace the null values with the cell values from above in Data Jobs (e.g. first null with 01/01/2016)? I was thinking about the Window Lag function. However, this function seems not to be supported in Data Jobs (SQL Vertica). 

I'm currently counting the amount of times a given Sales Order goes through a specific Activity in my process flow. I've managed to do this in two ways, the first one is by doing a standard PU_SUM, where the source is my activity table and the target table is the common table; the second one is by using the function CALC_REWORK on my activity table and a filter. In a secondary step, I need to add (in a different OLAP Table) the total amount of times SO's from a given branch have gone through said Activity. What this means in simple terms is that I need to sum the column from the first OLAP table where I counted the amount of times an SO went through this Activity.One big problem is that my data model does not have a Table at branch level, the highest level my model has is SO Header, making the grouping by branch part difficult to say the least. Does anyone have any suggestions? Thanks! 

We are trying to figure out a way to calculate process time (user inputs) for a particular case where any activity has featured more than once i.e. Rework. Normally, we would calculate throughput time but in this case, we are gathering the relative information like process time for individual activity and then checking if there are any rework activities for a particular case.  Currently the query that is created is calculating the process time for all activities, however we want it to calculate only the activities which has happened more than once. Any kind of help is appreciated. Query: SUM(CASE WHEN PROCESS NOT EQUALS 'Cancel Invoice' THEN       CASE WHEN PU_COUNT ( "BSEG", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" ) <>          PU_COUNT_DISTINCT ( "BSEG", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN") THEN              CASE WHEN PU_COUNT ( DOMAIN_TABLE ( "_CEL_AR_ACTIVITIES"."_CASE_KEY"), "_CEL_AR_ACTI

Hi Sara, Good Day!!Regarding celopeers partner access as I am not able to access celopeer partner portal getting below error raised a ticket also 00162801. Please check the error screenshot and help accordingly.     

Hello, I having trouble with Data jb for a long time. it is working 3 days well then gets error 2 days in a row. It is getting error at night then works fine in the morning. Is it normal ? are you also having this kind of problems ?

Hi Team, I was able to export the analysis (Process Analytics) in (Json format) but how/where can I upload it back to Celonis for reusability ?

Is it USD to EURO? Other way around?