Product Q&A

What is the best way to create copy of a datapool including all the datajobs

I tried it with != '' or NULL but the result was not as expected. The Result of the example attached should be: Component > Number: 2 CasesComponent > OLAP Table: 1004 / A50 and 1010 / A50  Hope you can help me, many thanks Stefan

The response of the POST call is a ticket that must be added to the header of the other calls as a session id. It seems that the extractor builder doesn't support POST calls. Is there a workout for this as authentication seems only possible by a POST?

Hi Celopeers!I am wondering what is the most convenient way to get the average throughput time between two activities based on their occurrence in a case. lets say C and D are always related to one another but can occur any time in one case: e.g. for the following 3 cases:A-B-B-C-C-C-D-DA-B-C-B-B-D-C-DA-B-C-D What is the best way to get the average TPT between each C and D based on the index in the case?so always...A-B-B-C1-C2-C3-D1-D2A-B-C1-B-B-D1-C2-D2A-B-C1-D1 C1-D1C2-D2C3-D3... I have thought of: LEAD/LAG; ACTIVITY_LEAD/LAG, SOURCE/TARGET, CALC_THROUGHPUT, ... in combination with INDEX_ACTIVITY_TYPE but I have not come up with the perfect solution yet. Thanks a lot! 

Hi Team, I have uploaded a data using parquet file in Celonis . I have extracted the data but coming to data model i want make the case table but in the below i could not see any option with case table 

Hi All, as a beginner in Celonis, I am often confused with the use of Skills and Action Flow, is there any significant difference in functionality, use case or scenario? Thanks in advance!

I've extracted all the variants that contains list of activities. In my case their are 648 variants. I need to identify which are the starting and ending activities of process. Can i assume that first activity in each variant is starting activity and last activity in variant is the last process activity that lead to 'Process End'? I've also comp up with query to create statistics between each link of activities as shown below. But i'm not sure how would i identify and calculate stats for 'Process Start' and 'Process End'. 

Hi, I am learning the celonis from the training track, while working on the creating the Account payable use case, i created the activity table but when inserting the second activity i am getting the above error so please help me where did i go wrong?  Thanks.

Hello, I had the PQL Code for Pull-Up-function in progress for many months now. This Function contains two dimensions/columns in the order by statement: PU_LAST(DOMAIN_TABLE("TAB1"."ID"), "TAB1"."STATUS", order by "TAB1"."SORTING","TAB1"."TIMESTAMP") ='Anlage'THEN 'create' A few weeks ago after adding more records to the dataset I got the following error message: Sorry! Something went wrongWe couldn't find any data for this chartPull-Up-function could not be executed PU_LAST:Only one ORDER BY column allowed, but [2] columns were specified After I removed the second Order by statement ("TAB1"."TIMESTAMP") the code works. However, ordering across both columns is still required.Was there an adjustment (function) or could it have something to do with the new data import? br Stefan 

Hello all,I was going through various packages in the celonis and i found out that there is a package called "Celonis_ml" with no other documentation. Where can we access the documentation / source files for the Celonis_ml package.Thank you

Hey Celonis world. I am trying to follow the Assistant Guided tour, but sometime it jumps and restart. is there some docs where we can do the exercises without following the assistant? Thks in advance

Hi, Would like to know if an action is resolved manually and post that if the new signals come depending upon the logics set? Eg: My Signal ID is A and it is was resolved on the 29th Sep post which there is a new trigger for the same signal ID A so would that come in the Signal Overview list? As I'm unable to see the new triggers for the same signal once resolved manually

Am new to Celonis, What should i do as an Admin. What are my roles, and how do i do it?

Hi,Does Celonis 4.5/4.6 have a dedicated data extractor for GEP MyBuy data? - Thanks.

Hello everybody, I have a problem with our data types in Celonis. In our Oracle database, we have columns such as the sorting implemented with an integer value. However, Celonis shows us a float value for all of these columns, which is why the following error message appears for some functions:  Does anyone know what the reason for this might be and how the data type in Celonis can be changed? Thanks a lotLaura

Hello,i have a problem to create a bar chart, where one dimension is the date, and the KPi should be a count of values, which have specific attributes (ends with special characters). I need 2 bars here, one for values which ends on "PV1" and one which end on "PA1".The problem is, that i don't want to count the values which ends to PV1, i want to have the count of value B, if value contains PV1Every two bars per dimension, eg month.thx in advance

So is their any way i can change all my tables names not manually one by one in analysis in visualization.

I need a pql of first occurrence of ACTIVITY 1 to last occurrence of ACTIVITY 2. same as crop selection part. Thanks.

Hi, We are performing some tests with Celonis and our on-premise SAP system (both Sandbox). Since we couldn't install the most recent ECC 6.0 RFC package, due to our enhancement package level (lower than Celonis requests), we decided to install the ECC 5.0 version instead. However, we are not able to activate and execute all RFCs, because some objects are missing in the installation package. For example: table /CELONIS/CLMAN. Are there any complete packages with all objects for ECC 5.0? Or can we just force the import of ECC 6.0 requests into our system? Error:Request:Thank you

Dears, I want to know the impact of S4HANA implementation on the real time connector which is based on the logic of table logging mechanism.  Once we migrate o S4HANA the ECC tables will become views and then how will this table logging mechanism work as I understood there is no change on tables in S4HANA for P2P process for example ?  Thanks for your insights.  Regards,Priyanka

Hello everyone,  we are currently in the process of implementing a HR process that extends the standard process Hire to Retire. Here we face the challenge that we do not have the changes data in the tables CDPOS and CDHDR, but saved in a cluster table PCL4. What would be the best practice working with a cluster table.  Additional requirement is, that we would like to only export the timestamp and the change table/field to Celonis. The changed values should not be included in the export. This was done for the other tables, by creating views, that only contain the relevant columns. But with the cluster table we face the challenge that all data is stored in one column. We would be happy about any experience or best practice with this kind of issue.  Best regards,Philipp

My predecessor uses FILTER DOMAIN under load script to filter the whole analysis. I couldn't find any documentation for this function. Does anyone know were I can more information ton this topic? Thank you

Hello, We installed the 2021-08-04_3.5.0_SAP_Extractor_Package.zip package, but unfortunately the extractor server returns the following issue : "unable to find valid certification path to requested target". Do you have any idea on what could cause the issue ? Firewall port to unlock ? Wrong proxy configuration ? Certificate missing ? What could I check from the extractor server itself to assess the connectivity ? 2021-10-11 18:53:54.035 INFO [,,,] 4156 --- [uplink-thread-0] c.celonis.uplink.manager.UplinkManager  : Uplink could not connect: 'I/O error on POST request for "https://**********.eu-3.celonis.cloud/uplink/api/public/uplink": PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target; nested exception is javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path

Also, Is it possible to understand the impact on real time extractor , as it works on log tables, after the migration to S4HANA the current tables will become views, is it wise to implement real time extractor before the migration or after migration.