Product Q&A

📢 🎄 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

I have a huge table in an analysis that I want to rebuild with a query data module in Action Flows. Obviously, this would require a lot of copy&paste as there is no feature yet to automatically create a query data module from an OLAP table, similar to the feature that exists for creating an Action Engine skill based on an OLAP table. Now, I want to leverage the MLWB for it. With analysis.drafts.components("table").pql_columns I was already able to get all the column names and their respective pql-queries. How can I transfer them to the action flows?

Hey Peeps, is there a possibility to transfer the selections of an view, in an action flow / "create PDF"?And if so, how?  It will be used to get a pdf just for a specific supplier selected in the view. Thank you.

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 )

Hi,  I want to create a Notication Action Flow for new found duplicates for our Accounts Payable use case. Right now I can only get all available duplicates not only the ones which came with the latest delta loadThank you!

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 make a graph where Dimension is a range.Mock Up: I have got a table with an Object ID, a Gross Value and a numeric Attribute A1.I would like to sum up the Gross Value if A1 is bigger than the Dimension and have a range with step of 5 as my graph dimension. The result would look something like the upper right quadrant of 1/x. I tried creating a variable as range, but PQL gives me the error, that the temporary table is not connected.Thanks in advance!

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, does anyone still have the problem that not all members, in the MS Teams module in Action Flow, are displayed? When I call the groups, all groups are displayed and I have the option to search. 

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!

Currently, my client have a list of user IDs that we update weekly and upload manually. I would like to automate this process. We are currently considering these two methods.1. PycelonisCreating a script using the Pycelonis method maybe is a good idea and I found this answer.upload parquet file and refresh data modell automatically (celopeers.com)2. Action FlowI have not looked into this in detail, but I am wondering if it is possible to use a module such as HTTP request to upload a file, for example. I would appreciate any advice you can give me on the above, especially the second one.

Hi, how do I extend my project in the new C4C project Hub?

Hi all,I'd like to know how to omit specific throughput time activity. In my process flow is A->B->C->D, for example, and the throughtput time between C to D is too long than other throughput time and it might be misleading so I'd like to omit that value. does anybody know how to do it?

Hi, I build an action flow which sends a KPIs as csv. The numbers have a format like 12.367 and '.' is the decimal point not thousend seperator. I need the number with 2 decimal places, means 12,36. Formatnumber, parsenumber cuts the number to 12.

the access. Do you know how can I remove this lock?

I have a situation were depending on the result of the Query Data (17) I need to filter on either the Inbound Branch or Outbound or either for a particular branch, for the next data query. I keep getting a Syntax error, the documentation was not helpful.Can this be done ?  

Good morning, We've set up an Action Flow that sends out an Alert under certain conditions. We're currently trying to set up a Historical log of the Alerts sent, but our JSON Bubble is set to REPLACE:  Is there any way we can change it so that it APPENDS new data to the table, instead of recreating it? Thank you in advance Best Regards,