General Product Q&A

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?

 How to use Celonis predefined template apart from workforce productivity like Task documentation ? How to access it ? As I am not able to locate it in MarketplaceI enabled screenshots while recording but I am not able to locate them in analysis. can anyone pls help navigating ?How do you create Task maps / PDDs here. can anyone pls help with steps ? Thanks in advance

Hi community, I would like to create OLAP table which is shown in the attached pic. The table includes kinds of fruits, amount, and ratio. [QUestions]How can I calculate the ratio after applying a specific filter? [tried]Using SUM(filter to null(amount)) Thank you for your support!

We have an OLAP table on one of our Studio Views. Our analysts were not able to see the headers of a table(Column Names) while us admins can see those. All permissions to use this View have been provided.  Is there any feature/function or permission settings which blocks the user fom seeing the header of a table?  Best Regards, Sooraj Edayattu

Hi, I'm unable to access the link provided above. Can you please provide a step by step guide with screenshots? I want to extract the list of users in Celonis based on their access level (Viewer/Analyst) and the data models they have access to

Hi experts, I try to define delta filters for a SAP table that has columns with create/change dates as timestamp (for example, 20220615023536):when I use "date" type for the dynamic parameter - I get error during extraction: Value 2.0220804014626E13 could not be read as Date, expected formats: yyyy/MM/dd, yyyy-MM-dd, yyyyMMdd, dd/MM/yyyy, dd-MM-yyyy, ddMMyyyywhen I use "text" type for the dynamic parameter - I get error during extraction: Value 2.0220804014626E13 could not be read as Textwhen I use "integer" type for the dynamic parameter - I don't get error, but the value is calculated as 2147483647 instead of the original value - 20220804014626 Could you advise if there is a proper way to work with timestamps like columns? As the table holds different SAP objects at the same time, I can't use max ID or something like that. I could divide the extraction job into several separate jobs (for each involved SAP object) and create delta filters based o

Hello all. I tried to filter the column "Year-Month" but the problem is that there is a warning. I also checked if there is an error in my PQL coding, so I copied the code to the process engine and checked all the columns below separately. No errors.  Anyone has an idea how to solve this? The code for year-month is:  YEAR(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE)) || '-' || MONTH(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE)) Another problem is that if I use "year-month" as a treshold my signals don't show. If i take the filter off, I see all signals. Thank you all.

Hi, I'm new to Celonis. I would like to know technical requirements for a Celonis Engine Server (on-Premise) used with IDEA PMX Client and minimum hardware requirements for a Client.

In order to ensure the security of our data, we were thinking about deactivating the Public Link option on the workspace. Is it possible to deactivate the option on User Role levels ? So that we can control the access to the dashboard outside our company's network. Regards, Sooraj

We have a corporate client, and they do not want the user to follow the download link... they want to force / manually install the task mining agent and make it active on the desktop. And that task mining agent needs to be linked to the correct corporate analysis platform.

How to calculate median for this ask. Requirement: Casetable count for a specific activity per document type?

Hello everybody.Two weeks ago I signed up for Training-Celonis-Cloud to successfully perform the exercises. Since yesterday I have not been able to access to the system (the log error is "Email or password are incorrect.". Although the credentials are correct).I tried to re-enter the new password with the "Forgot password" function but the error persists. Do you know the reason? Thanks. 

Hi. There is a webhook error when I duplicated an existing Action Flow. I duplicated Action Flow A to B, then I added a new webhook to B and tried to save it, but the following exception occurred.Am I doing something wrong? 

Good afternoon, We've set up an Action Flow that we want to run at different times, depending on the day of the month, ie:If we're on the 5 First Days or 5 Last Days of the month, we want the Action flow to run 4x a day, at specific times;If we're Not in the above mentioned interval (M+6 to M-6), we want the Action flow to run 1x a Day, at a specific time Thank you in advance Best Regards, Vasco Carona

Hello, i would like to have a global KPI where its value is not modified by the filters that we select in different dashboards. I am using the function GLOBAL but it doesnt work

Hello, I am currently running an Action Flow which is delivering and modificating a Gsheet and i would like to sort the sheet in ascending order on 1 column. Can i do it on the query who's generating the gsheet ? Thanks for your help :)

How can I display costs of activities in the variant explorer or process explorer?