General Product Q&A

We have a use case where we want to read the content of attachment and find some pattern. If the pattern is there then we want to extract this data in to some table using action flow. Is there any action flow module which can read the content of pdf/word.We want to use the Salesforce action flow module to download an attachment. Next action is to read this data find pattern and then put the data in to some table in celonis ems.

We are installing a Celonis extrator on a internal network and firewall rules must be configured in order to reach the EMS. Address "p-s-business-process-management-ciussse-chus-c4c.us-1.celonis.cloud" on port 443 has been opened as mentionned in the Celonis doc but it looks like authentication also tries to access https://id.celonis.cloud.Can you please provide the precise rules that need to be opened (from Extractor to EMS)? Thank you,Frédérick

Hi All, is there anyone having documentation for MS Dynamics on-premise? thanks

trying to see how to improve this query and what are the high run time and what to change to improve the run time. QUERY PLAN Access Path:+-JOIN HASH [RightOuter] [Cost: 52M, Rows: 6M] (PATH ID: 1) Outer (RESEGMENT)| Join Cond: (vbap.VBELN = VBRP.AUBEL) AND (vbap.POSNR = VBRP.AUPOS)| Join Filter: (VBRP.AUBEL <> '') AND (VBRP.AUPOS <> '000000') AND (VBRK.VBTYP = 'M')| Execute on: All Nodes| +-- Outer -> STORAGE ACCESS for vbap [Cost: 708K, Rows: 380M] (PATH ID: 2)| | Projection: 8e9add16-f209-4968-8e45-d1442c21cccb_cb2d42c8-e4fe-422e-8ac2-cf82c740f17c.VBAP_super| | Materialize: vbap.VBELN, vbap.POSNR, vbap.YYBOFLAG| | Execute on: All Nodes| +-- Inner -> JOIN HASH [LeftOuter] [Cost: 34M, Rows: 6M] (PATH ID: 3) Outer (RESEGMENT)(LOCAL ROUND ROBIN) Inner (RESEGMENT)| | Join Cond: (vbak.VBELN = VBRP.AUBEL)| | Join Filter: (VBRP.AUBEL &l

Hi guys! Is there any way to reload only updated data inside the process data model? I mean I need only the updated data supplied but the process data model always makes a full reload, deletes the old data, and leaves only the new one.

Hi, all.  I need to know how works the pql.PQLColumn() function of Python for Celonis. Does anybody knows where is the technical documentation?  I've tried https://celonis.github.io/pycelonis/1.7.6/ , and docs.celonis.com but is not enough. In this case I need to know how to use the format argument. Thanks!   PD.I've found only this short info when hovering over the function in the VS Code editor (class) PQLColumn(query: str = None, name: str = "Unnamed column", format: str = None, sorting_index: str | int = None, sorting_direction: str = None, not_included: bool = False) A PQL Column dictionary that can be added to a PQL query statement. Behaves like dict. Corresponds to Dimension and KPI in Celonis.Args:    query: Th

--Business Miner-- Does anyone know where can I find the Process Workspace needed for setup this new feature of Celonis? Thank you!

I was having Analyst access but yesterday it was changed to member is there any way to find out who has changed my access permissions, I know someone from the admin only must have change but want to figure it out in the system, is there any user log ?

Hi all, I currently have the following challenge. My source table unfortunately does not have a timestamp, but has a column with the date and a column with the time. Now I would like to retrieve in my Delta Filter Statement the data that has been added or that has changed in the last 15 minutes. How can I write this in the delta filter statement?  Thank you and best regardsSarina

Hi Recently I started learning about Celonis tool .Already i gone through the training tracks but still i didn't get an idea and clarification how and where to we will use this tool. Can anyone help me to find the solution.

Hi,I am using KPI Bowler to view distribution of a KPI over months. I am interested in viewing the aggregated data for all the available months.I could see that there is limit for number of rows to be displayed using "limit". But, i would like to check if there is any option to change the no. of columns(or months in this aspect). Please help me in understanding how the values are shown for first three months in my data model.Thank you.FYI: @reenu.josep12​ 

Cannot create a new data model. Loading circuit does not end, although the Internet works very well.

I get the following error while trying to "Export Data (XLSX)" from an OLAP Table: "Failed! (Syntax error near < after reading () at line 2" The Analysis settings allow excel and csv export of analysis components "Export Cases (XLSX)" works fine

Is there a way to extract the data from OLAP table which includes color formatting into Excel?

can we create dependency between action flow and Data model/Data Job successful run. This is to make sure that if the data model did not load or the related data job ran in to some error then the action flow also does not run on that schedule.

Hello everyone. I am trying to create an action flow that send a message one on one, creating a chat.   However, when I run the action flow it gives me the following error:  [400] Exception has been thrown by the target of an invocation. Does anyone Know how to solve it or what is causing it ?

Hi everyone, We are having some problems with the load of data chunks, sometimes its gets too longer to load a single chunk, in the process many times it stops at any point of the execution, its freeze for one hour or more and after continue. Please if someone had face this problem could you tell us what we can do to inprove this stops of execution. Many thanks. Best regards.

Hi I am looking into a product portfolio analysis based on SAP OTC data and would like some input and inspiration related to Celonis use cases. Is the SAP table, VBAP.ARKTX, the correct one to focus on for product information?

I am struggling with the implementation of a Multi-Event Log with O2C and P2P processes. After building the data models and succefully loading it, I am not getting the _CEL_MERGED_ACTIVITIES table generated. How could I do to fix the issue?

Does anyone have a full list of Analysis (Process Analytics) Edit mode keyboard shortcuts? Can you share please? Cannot find it anywhere in the documentation E - enable edit mode Shift - toggle edit mode 1 - jump to sheet 1 etc.

What the max size of number of character that can be extracted in table.column of type Text in celonis.

Hello,  There were no announcements about new Pycelonis version, however recently, by accident I&#39;ve seen that 2.0.0 appeared out of nowhere. I&#39;ve took a peak, and I&#39;m dumbfounded. It&#39;s completely unreadable, missing a lot of important information (like examples or methods/attributes that can be used). It&#39;s also important that even if you find some example, it&#39;ll be single line of code (or two) that won&#39;t work even with modification... It should be marked as BETA Version, and users feedback should be taken into consideration. Also very important migration guide is very easy to miss:https://celonis.github.io/pycelonis/2.0.0/tutorials/executed/04_migration/01_migration_guide/ Some

I did some courses in Celonis, how do I get badges for the same? I don't have anything in my Credly account too. I need to do some other courses too but holding them off till I understand the certification process

How I will get certificate from you after complete my course.