General Product Q&A

Hello team,I want to create an action flow for my data from uploaded file in celonis.Like which module I need to choose to access the file data.Thank you in advance.

How can I export data that is not limited to 200k lines

I am having a data connection from ORACLE EBS. Is it possible to enable replication cockpit for this connection? if possible how to do it? Do we need to enable Realtime extraction from Oracle end?

After a connection with SAP ECC is made and the optimal execution order is calculated, the extraction is "queued" for several hours before it start extracting the first table. Has anyone had encountered the same issue before and knows how to handle this?

action flow is not loading

It's been like this all morning (7/28 UTC-5 ) 

Good morning, I'm trying to use the Write Data to Table Skill from an Action Flow, but I keep getting this error: As you can see in the INPUT section, the action flow is providing the required Data to the Skill, so I do not understand what is going on..? The skill itself is quite simple, with a Manual Sensor asking for User Input for Table Name, Column Name and Column Value  And the Write Data to Table action is configured as follows, ensuring correct Data Types: When I query my database, the column is indeed a Float Data Type:  So I am lost as to what is going on, can you please provide some support ASAP? Thank you very much!

I’m able to see how we can use Create PDF action, Email by Celonis and 1 or 2 others. Can anyone share the link where I can get more details in specific to each action in a Skill

I would like to convert a string to a datetime format with the following formula:TO_DATE('2018-01-03 00:00:00.', FORMAT('%Y-%m-%d %H:%M:%S')) However, this is limited to accepting seconds as the finest gradient of formating according to the documentation. Is anyone aware of a %... Identifier for milliseconds? A workaround that works for me is:ADD_MILLIS ( TO_DATE('2018-01-03 00:00:00.', FORMAT('%Y-%m-%d %H:%M:%S')), 100)Though being a lot less elegant and I would have to split a column into its milliseconds and subsequently join them again. A native solution would be the preferred option. Kind Regards,Maurits

FILTER MATCH_ACTIVITIES ( ""."" , NODE [ 'Clear Invoice' ] ) = 0; For the above filter, i would like to use the AND function and include both of the activities for filtering the data.

My plan is to have one "generalized abstract" KPI which in turn is being called in a parameterized way by a number of different other KPIs. So that I only have to define the PQL once but can use the KPI directly in Frontend I however would like to hide said "abstract" KPI when Knowledge Model is being used, as it should only be used. Is there some kind of parameter that can be set in YAML definition of an KPI that makes it "private" ?

In dynamic tables with a dropdown list, the column's title doesn't update to the changed dimension unless you type in the dimension's name too. However, it returns the PQL statement defined for the variable instead of 'readable' text?

As the C4C+ model is about to expire, we are gonna use 1 of our credits to keep our project running. However I can't find any documentation about that.In other words, I need to activate 1 credit for a project that is running right now.Can you help me?

How to integrate Ticket Management System (BMC) in Celonis?  Once it detects abnormalities/anomalies in the defined process

Hello, I use Query Data module in my Action Flow. Inside this Action Flow there is a filtering. The filtered records are further processed in my action flow. What I would like to achieve is some information about iterations where, as a result of filtering, not a single record could be filtered out. So for example, I have 50 records that I want to process in my Action Flow. For 42 of them, the filtering in the Query Data module is successful, I can for example send 42 emails to clients basing on this data (because this is the next step in my flow). For 8 of them, the filtering in the Query Data module is unsuccessful (no single record was found), so those record are not proceed after Query Data module in the flow. I would like to, for example, send 8 emails to myself basing on this fact (or, let's say, collect those 8 records to one .csv file and send one email to myself and my colleagues with subject 'Records that were not found'). I hope that I presented my goal clearly. I

HI, I've tried: avatarColor: CrimsonavatarColor: "#DC143C"avatarColor: DC143C But nothing changes. What is the correct sintax? Example:     customAttributes:      - comparator: EQUAL        value: 3        style:          avatar: true          iconPosition: ONLY_ICON          avatarColor: "#DC143C" Best,João

Hi, I'm Lutech Admin in your partner portal but in the Training Analytics Dashboard I can't see our company learners: all the tab are zero.I have only the available team of "Celonis Academy - Learner Progress Cockpit" but all the results are zero and it's not true.Thanks and kind regards.Elena

how to use pie chart in view?

I am using the DFKKKO and DFKKOP table to get the invoices. Can someone help me get the SQL query for Cancel invoice?

Can I add colors to the columns of table component.?

Can we extract TBTCO table into Celonis? Because right now when I am trying to extract it, it's showing failed and the message in job log is "Extracting from a Change Log or Live Connection, will ignore any metadata changes".

Let's look at the code JOIN MERGEJOIN (inputs presorted) [Cost: 750, Rows: 1200] (PATH ID:1). What does the number 750 represent? A. The total cost of sales items in this joined dataset The exact known cost of the query runtime C. The estimation cost

The PU AVG functiis on is used when you want to display the overal average order size for the entire firm through the different months of the year.

Hi, I am trying to calculate the throughput time of each rework loop using Source- Target and failed due to no-common table errrors. My code is like below:Minute_Betwen( Source("_CEL_O2C_ACTIVITIES"."EVENTTIME", remap_values("_CEL_O2C_ACTIVITIES"."CHANGED_TO", ['ZA','ZA'], Null)), Target("_CEL_O2C_ACTIVITIES"."EVENTTIME",remap_values ( "_CEL_O2C_ACTIVITIES"."CHANGED_FROM" , ['ZA','ZA'], Null))) I got the errors that no common table found since both Activity table and temporary table for Souce/Target are N side.Do you have any ideas how to work around this?

Hello everyone, I would like to ask what figures and roles should be involved in an EMS project implementation? Is there a training track where I can find more details? For example, beyond the PM, the Value Architect, the Data Connection Expert and the Technical Expert, is suggested to involve and train someone else? Thanks