Product Q&A

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?

 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 Team,  I am the administrator of Birlasoft Sandbox, facing issue around creating Action Flows. As an administrator I have all the privileges'. But when I opened the package to add action flow, I can't see the option. Can you help me here?  Screen-shot attached for more details.

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.

I have found two ways to get the activities via python. But I need the connections betweens them. I can check for all activities wether they have a connection to each other but with the complexity of O(n²) thats very inefficient and costs a lot of time for complex processes with many activities. Is there a more efficient way to get the connections?

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 are trying to connect Celonis4.7.2 (onprem) to the GCP using the BigQuery Simba JDBC Driver supplied by Google. The .jar files have been unzipped into <installDir>\\lib but trying to connect from the frontend, we encounter the following errormessage: Has anyone successfully connected Celonis4.7 (or any other onprem version) to the GCP?  Thank you for your help! Cheers, Felix