General Product Q&A

Hi all Celopeer, I would like to ask if there is a level of job seniority required to take expert badges.For example, if the company where I work in would like to become a Celonis partner could I be one of the Value Assesment Expert even though I started working two years ago and I am a Business Analyst figure?Thanks

how can we push the OLAP from one instance to another instance without having to replicate the logic written on the back of the olap in action flow.

Hi everyone,  I am building a View, where I want to list some KPIs from my Knowledge Model on top of a table. For that purpose, I first chose an Attribute List, as I see in the documentation that it can take KPIs as Input. Then I tried a KPI List instead, with the same KPIs from the Knowledge Model, and I noticed that the numbers displayed in each KPI are considerably different, when I use one component or the other. (I checked it and the numbers on the KPI List are right, and differ greatly from those in the Attribute List). Does anybody know what the cause of this discrepancy might be?  How do Attribute Lists function overall? When should I use them? I was not able to find further information about that in the docs. Thank you very much! Javier

 I have created a Activity table. in that I required to change Existing activities name .I change in transformations but it was not reflected to process explorer. for views and analysis . how to change it ?

Both views are using the same PQL formula which is getting the average value of a data and no filters were applied in the views.

Hi, I'm trying to extract some additional data from CDPOS table using extraction that is separate from our main one. However, it doesn't seem to start to extract. Log shows that job was released to SAP but it won't start actually extracting anything.Does any one have any ideas what might cause it? Could maybe adding something to FIlters help?  Thanks,Karol

Hi all, I have a question about Celonis table data. I have deleted around 20GB useless data via drop table SQL because our Celonis server reached to data volume limit 10 hour ago, but Celonis data volume bar in license setting doesn't move... Does anybody know how or when the data consumption will be updated? Regards,

For example, let's say I'm analysing the conformance of my Incident management flow, but I need to distinguish per Service since I have different steps to be performed based on the type of the request. Can I set a specific process model per Service?Thank you in advance! Giulia

How to add data in action flow for, creating HTML Table and send it via Mail?

As the title says I want to create a plot that cannot bed created in Celonis (as far as I have researched and tried). The workaround was to create a script on Machine Learning Workbench that uses the information from the KPI's but I don't know how to include the plot created with matplotlib into the sheet  And then to appear somewhere in my dashboard   Thanks!

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