General Product Q&A

Will i be again required to participate to complete 3 certification or I will be considered as certified ?

Hi Folks! I would like to know if there is any way to avoid inserting duplicate records when we execute delta jobs. I cannot use Replication Cockpit, since we're using a non-standard system.

Delivery date change use case - Dear experts , In delivery date change use case , Celonis assigns delivery date on behalf of user for high probable delay case, Can you tell me how Celonis determines the new date ? is there ML function within PQL library

If the data refresh schedule is picked up from a table which is not connected to the case table in the data model then how to query the data refresh schedule and display it in the action flow.

Business Process Specialist (m/w/d) Supply ChainBizerba Location: Balingen (Germany)Description: Wir bei Bizerba verbinden die traditionellen Werte eines Familienunternehmens mit den internationalen Karrieremöglichkeiten eines global agierenden Konzerns. Wir nennen das die "Bizerba Open World" und freuen uns darauf, diese gemeinsam weiterzuentwickeln (Check out the full description following the link) Apply here

We have recently changed the database connection from uplink to direct wherein required to move all tables (nearby 50) to direct connection, to avoid any re extraction. Any suggestion would be helpful.

This is related to this question: https://www.celopeers.com/s/question/0D50700001vMXJgCAO/distribution-lists-in-action-flows?language=en_US I have been able to figure out how to send to a distribution list, but it is instead using an HTTP Request. This allows our action flow to reference a "no reply" account where we can send within the company. The issue I'm now having is how to attach a PDF while using JSON. This is how my module is currently set up  I have my PDF being converted to a JSON string as can be seen by '9. JSON string'.  Is there a parameter I'm missing in the JSON request? The email can be sent and works correctly, but without the necessary PDF attached 

Can you please tell me how case id of two different process gets linked like p2p and o2c , will it be material id ? because thats the only thing that looks like case id ?

Can general ledger process and closing be modelled into celonis ? has anyone observed any process mining use case around this ? My thinking is it might not be possible but still needs your opinion.

Dear experts have you came across any instances in your projects , where you implemented automation to auto update master data like price ?

Is it possible to add hyperlink to the Free Comment? (I know we can add link in free comment component but would like to know if hyper is possible as well)

How can I make a custom dimension based on a process flow? I want to make an OLAP with a case count for both 'push' (goods are produced before order) and 'pull' (starts with act receive order) cases? so based on those flows i want to create a dimension

📢 🎄 Dear current and future Starter Kit users,📢 🎄  As an early Christmas present, the Starter Kit brings amazing updates. Check them out in the market place! 1. Updates on inefficiency deep dives!Go to the next level of understanding detailed insights into the hidden inefficiencies by surfacing root causes automatically. You’ll now find deep dives and recommended solutions for all the available inefficiencies - have a look at Manual Sales Order Creation, Delivery Blocks, Active Billing Blocks or any of the 20 inefficiency deep dives. 2.“Start here” view In order to help you utilize the Starter Kit more efficiently a “Start here” view is now available in-app to guide you through the different steps to take. Update your Starter Kits today! Not using the Starter Kit yet?The Order Management Starter Kit is your kickstart to gain insights into the most impactful order management use cases.It is a collection of assets that help identify and frame the most valu

Hi,  I had a permission error when installing a Python library on Machine Learning Workbench, and when I tried to run the command with sudo, I was asked for the password for Admin permission (Jovyan), is there any default password for the super user? 

Could you please help me to define PQL formula for the below use case? Average time( When count(WI of a DOCID)>2 then 0 When count(WI of a DOCID)=2 then END_DATE - START-DATE of highest WI ELSE END_DATE - START-DATE )

Action Flows: How to aggregate cases pertaining to 3 different conditions into a single send email module and send out a single email for all cases under those 3 different conditions?

Hello everyone, I would like to create a benchmark sheet in a View, but do not understand how to use the created variables in the right way. Someone has experience with this? Thanks a lot!

Hi All,  I'm using the World Map data visualization functionality and created a location: coordinate dimension. However, I'm wanting to relabel that to the state name when the tool tips come up. I see there is an editor option to do that, but I'm unsure of the syntax as I couldn't find any documentation/ examples. Take for example the screen shot attached, the coordinates are '47.751076, -120.740135'. I need to relabel that to "Washington". How would I do that?  Thanks in advance!

HI Community, We have a 3 different Activity Tables; One Main Table and 2 Department specific tables.(without an Event Log Merge on DataModel). We could use the MERGE_EVENTLOG function on the Process Explorer but When it comes to Case Explorer, it shows onyl the activities from Default table. Is there a workaround to show all the activities with out eventlog merge?  Best Regards,Sooraj

Does anyone has any solution for the error :- "ROLLBACK: Table "Case" does not exist".  Whenever I am trying to extract the Case table in Celonis, it throws an error with the message "ROLLBACK: Table "Case" does not exist." The most irritating fact was that it was throwing error while inserting the records in EMS, that means it use to extract all the chunks from SF, take hours to do that and at the end it was throwing the error. 

Hi Team, I am building an Action Flow to notify user and in my query data , i am getting 2 email ids coming from 2 differnet tables so how can i send an email to both of them.

Is it possible to change row's color in the Table component in the View?

Hi, Is there the possibility to display a kpi in two lines? Like for example in an olap table. I've tried putting /n or CHAR(10) but it doesn't work.I'm now displaying values concatenated on the same line, like 3 days - 10 objects. Expected output:3 days10 objects Thanks!