Product Q&A

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.

The SQL returns error that the relation not exist. See attachment. The long number refers to the connection parameter.

Null values are coming as - in visualization and olap tables.so how to hide them.I have used isnull and coalsce () ,but it seems not working.So any way to hide or change - for null values.

I need a filter that will show only a part of the events that happened in the selected time interval. When I set a period limit, a complete chain of events is displayed for all cases that took place during this period. for example, in the chain (id -date ) 1 - 01.2021, 2 - 04.2021, 3 - 06.2021, if I set the filter to 04.2021, the entire chain will be displayed 1 - 2 - 3, and it is necessary that only 2 be shown

Unable to login to ibc training portal

Just installed CPM 4.7.1 ( new install) not upgrade from 4.6.x in our Dev/QA box. We imported a transport of one of the analysis from PROD and brought it into the QA. Everything is working fine- OLAPs, Charts etc..., except Process Explorer and Variant Explorer seems to be taking forever...pink dots.  Do we need to configure some settings.  Mohit

HI team what we need to check while collecting flat files from client

In the stage of transformation, I run the Vertica SQL script and the output only shows the first 100 rows. But I want to see all rows. Is it possible to do some configuration to see all output rows? Can I export the output? Thanks.

Dear celopeers, what is the best practice for showing an execution output message in case an error handler was active? More specifically, we first use salesforce and added a flow control module "ignore" to handle errors that occur within salesforce. However, we would like to show a user notification in this case. The problem seems to be that we cannot add another module after the ignore module (for including, for example, a webhook to a skill which could then produce the execution output).Appreciate any insights.Thank you very much

I'm using a CASE WHEN statement to filter out dimensions based on dynamic criteria. For example, take the following case when statement: CASE WHEN"Activities"."ACTIVITY_EN" in ('Closed','Open')THEN'Closed'END I would expect that there will only be rows for 'Closed' and 'Open', however, I am also seeing a row with the dimension of '-' . There is no way to filter this out and leads to misleading dimensions.

I have crated a basic analysis for my team with only 1 sheet as case explorer. In the case explorer i want to hide few columns and publish the analysis. I don't want to show few columns to the team. Is there any functionality to hide columns in case explorer and publish? Regards,Ashok

Hello all, in the event-collection I create a new table, wherein I join two tables based on the following rule:JOINWHERE "Alarm"."Starttime" > "Transport"."Starttime" AND "Alarm"."Starttime" < "Transport"."Endtime" This works. Now I would like to extend this timeframe by 5 Minutes. And neither the function:add_minutes("Transport"."Endtime", 5) is supported nor the function REMAP_TIMESTAMPS("Alarm"."Starttime") < (REMAP_TIMESTAMPS("Transport"."Endtime") + 5) How can I change/remap a timestamp in the event collection?

Hi, I want to add a column to an OLAP table that shows whether all orders from a given supplier exceed the value of 100 or not. So the final table should show a supplier name, the number of orders, the net worth of orders and either: The net worth value sum if its above 100, else 0An 'x' when the sum of orders exceeds 100 Also, it would be great to see how many single orders exceeded the value of 100. I was trying around for a while with PULL functions and CASE WHEN but I can't seem to make it work with the restriction of '> 100'. For example the query below gives me an error message stating that CASE is not compatible with FLOAT and INT. SUM(CASE WHEN "EKPO"."NETWR_CONVERTED" > 100THEN "EKPO"."NETWR_CONVERTED"ELSE 0END) Thank you very much in advance. Best regardsAram

Dear Celopeers, on September 30th 2021, we are hosting our next Webinar on how to automate your communication with Action Flows!This is the second part of our new series of Webinars. The session will coverWhat you can communicate automatically with Celonis Action Flows (presentation)How to set up Action Flows for automated communication (live training)Where to find further material & trainings (link to resources)Q&A (live)FAQ (live, gathered from previous session) You can directly register here!

Hi, When i show the same formula (standard throughput time calculation) in an OLAP table vs a number they fail to show the same outcome. Whereas they should. In the olap table I have applied the formula in combination with a priority dimension. WIth the number I have applied a specific priority as filter. Hence, both the throughput time should be equal. However, they are not.  Any idea what could go wrong?

I was wondering when to use a skill or action flow? It seem there is an overlap in functionality or is it just me?

I need to change it from %b-%Y to Q%q on the basis of time scale selected by user

 Is there any way to set euro currency format in olap tables ?  i like to see the amount of 3.000.000,15 € in euro format, now in celonis it is posible to see with commas like 3,000,000.15 but this is a Dollar format. ¿ Is it posible to set the currency configuration for euro ? Is there any way to set the locale configuration for currencies decimal in ',' and thousands in ',' ? Thanks in advance. 

Hi All, I have more number of SQLs as part of one transformation in celonis. I would like to include a info to be printed on the transformation log after it completes a particular statement for debugging/tracking purpose(same like SQL's print command).  Could you please help me with option for the same? Thanks in Advance. :)

I need to import data and create data model from the demo data that was extracted from the eventlog file as shown in one of Celoinis training video. Where i can get that eventlog file? I'm unable to connect any live system to get data feed so trying to use demo data instead but unable to find any event log data to import to create data model. The one training guide uses 'p2p_Demo_Eventlog.xlsx' file to upload data. I'm unable to locate this file. Can someone have this file or any other event log file that i can use to import data in my environment.  

I am stuck at the Data Extraction bit in the 'Data Engineer' course. Not able to extract data even though I have tested the connection and it works fine.