Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4385 Topics
raman.silot11
Level 3
raman.silot11Level 3
asked in Process Analysis
Multiple attribute selection in new views

Hi Guys, what’s up ? I wanted to ask if there is any way we can selection multiple attributes in new views and update variable based on it. Currently, the ‘multiple’ option is disabled for attribute selection. I tried with free text but it just adds additional single quotes in beginning and end of the string, so those single quotes should be removed to consider it as table and fields. for ex. “table”.”field” is considered as ‘“table”.”field”’.  

261
raman.silot11
Level 3
JOSE ANTONIO
Level 2
JOSE ANTONIOLevel 2
asked in Process Analysis
Análisis de información o datos para obtener INTELIGENCIA MILITAR

Buenos días necesito saber si es posible utilizar CELONIS para realizar análisis de dato o información para obtener INTELIGENCIA en el ámbito militar, lo que me permitirá mejorar el proceso de toma de decisiones 

100
JOSE ANTONIO
Level 2
leonardo.spina
Level 3
leonardo.spinaLevel 3
asked in Process Analysis
Configure Case Explorer - Case-centric

Hi all, In the case explorer, in YAML or Views, how can I change the Throughput Time and use my own formula in PQL?Thanks for helping.Br,Leonardo

212
leonardo.spina
Level 3
denise.kruge12
Level 4
denise.kruge12Level 4
asked in Process Analysis
Comparing timestamps of 2 cases

Good morning all, I need assistance with PQL to compare the timestamp of a certain activity of case A with the timestamp of another activity of case B, has anyone done this before?

322
denise.kruge12
Level 4
Damian
Level 2
DamianLevel 2
asked in Process Analysis
Filtering Cases by specific activity

Hello,My goal is to create a filter which, after clicking, will only show cases which contain specific activity in them. In my case I want to include all cases which do contain activity with string ‘reject’ in the name of activity.I’m trying to create a filter with this expression:  FILTER MATCH_PROCESS_REGEX ( "_CEL_MERGED_ACTIVITIES"."ACTIVITY", 'X' >> LIKE '%reject%' ) = 1;             Although it does not seem to be working.How can I create and apply a filter to show only all cases which do have such activity?

384
Damian
Level 2
Sony Shrestha
Level 3
Sony ShresthaLevel 3
asked in Process Analysis
PQL query (KPI)to get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice

I have event log as leading_object_id activity_name resource1 Create Invoice A1 Approve Invoice Z2 Create Invoice A2 Create Invoice B2 Approve Invoice BI want to write PQL query (KPI) such that I get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice. How can I achieve this?

181
Rami Agha Kassab
Level 3
Ushmita Patil
Level 2
Ushmita PatilLevel 2
asked in Process Analysis
Not Getting Data in Charts or Case Explorer – Shows "You don't have data yet"

I'm facing an issue where my charts and tables show the message "You don't have data yet" even though I have connected them to the data model.When I create a Case Explorer, it only shows 1 row with these columns: Case ID Number of Activities Duration In the table section of the Case Explorer, it only displays CDHDR.CASES.Can someone please help me understand why I’m not getting any data in the charts or other tables I create?Thanks in advance!

151
Rami Agha Kassab
Level 3
E
Level 3
ewa.aniśkLevel 3
asked in General Product Q&A
How can we apply colours to charts/process explorer/tables in Views?

How can we apply colours to charts/process explorer/tables in Views?

245
leonardo.spina
Level 3
M
Level 2
mel.schic11Level 2
asked in Data Ingestion & Infrastructure
I would like to connect two fields that have an indirect N:N relation. Is this something which I can do via a PU_Function?

Within an OLAP table, I would like to use both the Delivery Line Item Date ("VBEP"."EDATU") and the shipment gross weight ("LIPS"."BRGEW") Does anyone know how I can apply a PQL function to combine these tables? Please find the error below. I looked into the PQL documentation but I can't find the solution. Error in formulaNo common table could be found. The tables ["VBEP"] and ["LIPS"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [VBEP]N <-- 1![VBAP]!1 --> N[VBFA]N <-- 1[LIPS]. For more information on the join path, search for "Join functionality" in PQL documentation.

262
kandi.naidu
Level 4
L
Level 1
loretta.nelso12Level 1
asked in General Product Q&A
Where can I find JDE reference customers?

We are working with a prospect who uses JDE and he requested us this information.

112
P
Celonaut
britta
Level 2
brittaLevel 2
asked in Process Intelligence Graph (PI Graph)
Accessing Global Scope from object based on a data connection

I am struggling to access tables from the Global Scope in an object that is based on a data connection. While I see a parameter selection that allows me to access tables from different data connections, I cannot find the right parameter to access a table that is house in the Global Scope. Is there a way to reference the global scope correctly? 

160
britta
Level 2
janpeter.van.d
Level 8
janpeter.van.dLevel 8
asked in Data Ingestion & Infrastructure
What does the Eventlog Automerge option in Data Model overview do?

Hi all, Since a short while we see the option eventlog automerge in the data model overview (see attached screenshot). However, this is not mentioned in the Release Notes or online documentation. Does somebody knows what this option is for? Thanks in advance! Bests, Jan-peter! Celonis_Automerge|690x150

103
Ushmita Patil
Level 2
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Filter

Hello everyone,I have a list of Material Numbers, and some of them belong to the P18 Business Unit, some to the P20 Business Unit, and some belong to both P18 and P20 at the same time.I created a Quick Filter to show only the materials that belong to P18, and it works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')I did the same for materials that belong to P20, which also works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')However, when I try to filter for materials that belong to both P18 and P20 at the same time, the following filter does not work correctly — it also shows materials that belong only to P18 or only to P20:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')AND "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')Do you have any idea how to fix this?Thanks! 

180
Saba
Level 4
thomas.guerr
Level 4
thomas.guerrLevel 4
asked in Data Ingestion & Infrastructure
Extractor configuration for data transfer from MS Sharepoint to Celonis

Hello,I am trying to get data from a Microsoft sharepoint list to the Celonis Platform.According to the Flowchart provided by the API-Team - When to use the Standard Data Ingestion API (and other methods) - the extractor builder should be used for a Sharepoint data transfer, since the REST API is exposed.I tried to set up the connection, but I fail when configuring the endpoint, since I get xml-data even if I specify that I would like to have a json structure (Request Parameter - Accept: application/json;odata=verbose)Does anyone have experience with connecting the MS universe with the Celonis universe?I also found a workaround that works (Push CSV to Data Integration), but I would rather orchestrate all the data loads in the Data Integration environment instead of using Process Automation modules to make a data transfer.Thanks for your support!BR THomas

772
thomas.guerr
Level 4
Hafsa
Level 2
HafsaLevel 2
asked in Process Analysis
Process analysis

Hello,To better analyze the Service Now process (a very complex process with many parallel tasks and loops...) in Celonis, is it preferable to use the pm_project and pm_project_task tables or the sys_audit tables?Thank you,

371
mariia.meles
Level 2
S
Level 3
sayan.chakr12Level 3
asked in General Product Q&A
How Can i connect the purchase side and sales side in a process explorer which will display the P2P-AP process in one side and O2C-AR process in one side AND the explorer should also display the connection between the 2 process flow??

I am working on an intercompany transaction where one subsidiary of the parent in buying material from a vendor which is a subsidiary of the same parent. Hence O2C-AR of the buyer should be synced with the P2P-AP of the vendor.

115
swapnil.karad12
Level 2
swapnil.karad12
Level 2
swapnil.karad12Level 2
asked in Data Ingestion & Infrastructure
Linking tables for O2C and P2P in SAP

I want to visualize end to end process of a buisness; order received → purchasing begin→ production → payments to vendors → order shipped to customer → cutomer payment receivedhow i can connect in SAP all this O2C to P2P; what are common tables to link all this

150
swapnil.karad12
Level 2
varvara.bachu
Level 2
varvara.bachuLevel 2
asked in General Product Q&A
Wrong result when adding percentages

Dear Community,I want to calculate an average error rate for each year under certain conditions. Even though it may seem quite simple, I receive an incorrect result. 🤔This is my formula:COUNT (DISTINCT (“Table”.”Column”))/COUNT (DISTINCT (“Table”.”Column”)). The KPI “2023” has the following conditions as filters: Do you have any idea what is wrong with my formulas? Many thanks and kind regards,Varvara

130
varvara.bachu
Level 2
thomas.keim
Level 4
thomas.keimLevel 4
asked in General Product Q&A
Create Table with field of various 1:N and N:1 Relations

Hello Community,I hope you can help me to find the best approach of my issue. My challenge is to build a table with the complete SAP Process Flow: Order, Delivery, ShipmentFor this I have created a data model with the following linked tablesVBAK (1) - (N) VBAP (1) - (N) LIPS (N) - (1) LIKP (1) - (N) VTTP (N) - (1) VTTK When I try to add fields from all tables into one studio table I get the following error:I have understand the problem but missing the best approach to solve it.What do you think? Is the a studio table with different PQL formulas the solution? If yes, how can I do it?Or is it better, when I create a table (e.g. TAB_PROCESS_FLOW) within the transformations that includes all the key columns and connect the other tables (VTTK, VBAK...) within the data model. So the table TAB_PROCESS_FLOW is like a case/common table.Best, Thomas 

190
thomas.keim
Level 4
Clearner
Level 2
ClearnerLevel 2
asked in Process Analysis
Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables

I am using the free version and custom functionality.Have two event logs and trying to create two flows with transition using the process explorer.Data model, KM, Data Explorer everything is working.  In the KM link between logs is enabled. In Views - Process explorer , it shows two flows. but the transition is not showing so trying to enable the configure transition in the Transition toggle and getting the error as Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables1.What should be data structure.?2.Do we need same event in both logs?3.How does multievent log works with Transition enabled in backend.   

231
Clearner
Level 2
gauri.pai11
Level 3
gauri.pai11Level 3
asked in Data Ingestion & Infrastructure
Content-cli Profile creation

Hi team,I am using this command content-cli profile create.I am asked for name,url and api key.I have added all the three, but it gives me error as - The provided team or api key is wrong.Name of the profile: XYZYour team (please provide the full url): https://XYZ.eu-5.celonis.cloudProfile type: OAuth Device Code (1), OAuth Client Credentials (2) or Application Key / API Key (3): 3Your api token: XYZ*API token is directly fetched from celonis-edit profile-api key.Is it necessary to have admin role for this.Currently i have analyst access.Please help me with this.

271
abdulnour.duale11
Celonaut
manuel.wetze
Level 5
manuel.wetzeLevel 5
posted in Process Analysis
Best practices to share Insights found in a Dashboard

Hi Community I need your inspiration for a big challenge of mine: Share an Insight made on a dashboard to colleagues with the least amount of effort. a bit of context:I have an Analytical Dashboard, it is not ment for Management and its not Operational. Its purpose is for Process managers to analyze the visuals and find inefficiencies. Now quite naturally if the enduser found something they want to communicate this finding (current Values+ be able to document which filters allowed to come to this finding). Receivers of those findings could be:other Users of the same Celonis Dashboard or persons which do not have Celonis access and also should not have it.Ideally I would like to have a Button or Action within a table called “Share Insight” which automates the  process for the enduser as much as possible. My initial thoughts around this:“Export PDF” is nice to share with non-celonis users. “Share Link to this view” (with Filters) is great to share with those who have viewing rights on th

130
manuel.wetze
Level 5
SHASHANK
Level 2
SHASHANKLevel 2
asked in Celonis Free Plan
Request for Re-attempt of Rising Star Program Business Assessment

Unfortunately, despite my strong dedication to completing the program successfully, I have encountered some challenges that prevented me from obtaining the certification. My first attempt at the business assessment was disrupted due to an unexpected technical issue during the exam, which caused me to lose that opportunity. In my second attempt, I unfortunately did not pass the test. As a result, I currently remain uncertified, which is disheartening given the effort I have invested throughout the program.WHAT SHOULD I DO NOW ?

161
N
Celonaut
P
Level 2
pablo.layneLevel 2
asked in Process Intelligence Graph (PI Graph)
How can you configure the sorting of activities in OCPM?

How can you configure the sorting of activities in OCPM?

1548
abhishek.chatu14
Level 7
A
Level 2
akash.suhag12Level 2
asked in General Product Q&A
i have activity table which have same timestamp(T) for multiple activities in a single case.for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C.but flow is A->B->C

i have activity table which have same timestamp(T) for multiple activities in a single case. for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C. but flow is A->B->C

246
herique.sarme
Level 3

Badge Winners

VIEW ALL
Community Code of Conduct