Skip to main content

Product Q&A

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

4407 Topics
C
Level 3
christoph.schus12Level 3
posted in AI
Hello all,

Hello all, I would like to send an xlsx file as an e-mail attachment. The file is generated by a Python script in ML Workbench. Due to the formatting of the xlsx file, it is not possible to load this file into the data model without further ado. Is it still possible to send the file automatically, e.g. via an action flow or skill?  Best regardsChristoph 

32
G
Level 8
kailash.potha12
Level 5
kailash.potha12Level 5
asked in General Product Q&A
Is there any way to download PDF report on views? ( Action Flow or Skill)

Is there any way to download PDF report on views? ( Action Flow or Skill)

60
kailash.potha12
Level 5
S
Level 1
sheryl.ngLevel 1
posted in Data Ingestion & Infrastructure
Hi,

Hi,  I have stumbled upon an warning message that states "The join between table "_CEL_P2P_CASES_6" and table "_CEL_P2P_ACTIVITIES_6" did not find any matching rows."  Prior to this warning message, I have assigned the activities and case table respectively as well as assigned their foreign key, "Case_ID".  Is there a way to fix this error message?

21
abhishek.chatu14
Level 7
V
Level 1
vinicius.franc11Level 1
posted in Process Analysis
Attached 1

Action Flow to Update a Augument Attribute Error: Validation failed for 1 parameter I would like get an Augument Attributes from an Excel file using an Action Flow. So, I tried the following steps: 1. Creating a record called “Clientes Comercial” and created a Augument Attribute called “Gestor” in the Knowledge Model. Attached 1 – Record: “Clientes Comercial” Attached 2 – Augument Attribute: “Gestor” 2. Creating an action flow called “carga executivo e adm de vendas”:2.a. Creating a of Microsoft 365 Excel component - List Worksheet Rows and set it to get the data in a sharepoint address. Attached 3 - Microsoft 365 Excel component - List Worksheet Rows2.b. Creating a Celonis Component – Update Augumented Attribute and set to update Attached 4 - Celonis Component – Update Augumented 3. When I run the action flow, I got the following error: Validation failed for 1 parameter(s). Attached 5 - Validation failed for 1 parameter(s)But both, Excel value and Augumented Attributed was

30
V
Level 1
F
Level 3
federico.sparaLevel 3
asked in General Product Q&A
Get activities linked to given activity

Hi, I need to create a table with the infos related to activities linked to a given activity.It's like a Process Explorer but in table form, where the user selects an activity and the table provides infos (name and other columns) related to the activities linked to the selected one. Is there a PQL statement that allows me to do so?

00
S
Level 4
Q
Level 1
qiuyu.renLevel 1
asked in General Product Q&A
For Power BI, I've failed to find any information about how to do it.

For Power BI, I've failed to find any information about how to do it.

60
abhishek.chatu14
Level 7
S
Level 1
sapna.goyalLevel 1
asked in General Product Q&A
How can we get access to Training Analytics Tab in Celonis?

How can we get access to Training Analytics Tab in Celonis?

00
L
Level 1
N
Level 2
niharika.jainLevel 2
asked in General Product Q&A
How can I schedule a Action Flow?

How can I schedule a Action Flow?

80
N
Level 2
E
Level 4
e.nLevel 4
asked in General Product Q&A
Training Environment

In the Celonis Academy training environment, there is no configuration screen for scheduling event triggers. Is it possible to check in the training environment?

30
D
Level 1
S
Level 3
sandra.gerbaLevel 3
posted in Data Ingestion & Infrastructure
How to schedule a syncronization of data?

How to schedule a syncronization of data? I have some tables on another connection, from SAP Ariba (Purchase Requisition e Sourcing)We use some of these tables on data model on P2PSo I need to run detal load every day on all jobs.How can I syncronize automatically data from another connections, once when scheduling I only found the option to do it manually?Thanks

11
abhishek.chatu14
Level 7
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
From which port do we need to open an access request so that we can access the mail from Action Flow?How to solve an Error while sending an E-mail via Action flow?I attach the error in below details.

@Vildan Aslan​ @emre.karad​ 

50
R
Level 4
C
Level 3
chakradhar.pokalLevel 3
asked in General Product Q&A
Process AI in analysis need link for deep understanding

Hello Celopeers, I have built KPI dashboards and doing some analysis on process explorer. Manually going through analysis. Heard Process AI will automatically detects deviations and find root causes.  Need to deep drive. if any one knows the link from learning portal pls suggest.   

10
E
Level 2
R
Level 4
rahul.bhat13Level 4
asked in AI
Add_Table_From_Pool deprecated in 2.x?

Hi,Im trying to add a table from Datapool to datamodel and i found this function, add_table_from_pool in the release notes of 1.5Now when i try its not present. Is this deprecated?If so, are there any alternatives?Please let me know. Now the error: 

20
R
Level 4
jiri.linha
Level 1
jiri.linhaLevel 1
asked in General Product Q&A
I have multiple values (20 of them) for example orders which I need to insert into filter, but after entering and confirming it, the filter is not applied. I tried to even change format in excel to number before, but still not working.

I have multiple values (20 of them) for example orders which I need to insert into filter, but after entering and confirming it, the filter is not applied. I tried to even change format in excel to number before, but still not working.

10
S
Level 1
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
How to update to latest data connector?

hi all, Now I'm trying to update data connector and dashboard to latest version.(I found some difference between my celonis version and latest O2C asset.) In one time upload case, do I need to create celonis at first: I mean, add data connector, upload data and add dashboard? or do we have a way to add something patch to my old celonis environment? Thanks and regards, 

00
S
Level 1
S
Level 1
shiwansh.tiwarLevel 1
asked in General Product Q&A
Basics of Process Mining

Basics of Process Mining

00
S
Level 1
rene.szere
Level 3
rene.szereLevel 3
posted in General Product Q&A
Hello,

Hello, I have an activity "OCH_Activities". "Source_Queue_TXT" and "OCH_Activities". "Target_Queue_TXT".I want if source and target are the same, that I get the value 1 for example.I have already tried COUNT( CASE WHEN "OCH_Activities". "Source_Queue_TXT" = "OCH_Activities". "Target_Queue_TXT" THEN 1 ELSE 0 END)but this does not compare the two activities. What would be the correct approach here.Thanks

22
rene.szere
Level 3
pietro.fratt11
Level 2
pietro.fratt11Level 2
asked in Process Improvement
Connection with Salesforce and API rest limits

Dear Celopeers, we are connectiing Celonis with a Salesforce production environment using the standard Celonis Extractors/Process Connectors. This connector, as stated on the Celonis documentation, uses Rest API. Using rest API impacts the limit of concurrent calls that the platform can support (25 in parallel with a maximum duration of 20 seconds). This means that the Celonis connector competes with calls from other applications causing possible service interruptions. Is there any option within Celonis extractor/connector to set API limits and ensure that extractions do not have a negative impact on the productive Salesforce system performance? Or, can such API limits be set only within Salesforce?

60
P
Level 1
sree.c
Level 4
sree.cLevel 4
asked in Process Analysis
Hi All, Is it possible to send email (email by celonis) with all the PDF reports generated? For example, In the below figure, 2 PDF outputs need to be attached in one email. please suggest.

490
sree.c
Level 4
.
Level 4
.146192833Level 4
asked in Data Ingestion & Infrastructure
I have requirement , user wishes to upload some excel files downloaded from external tool till integration is well established.

I have requirement , user wishes to upload some excel files downloaded from external tool till integration is well established. What can we do so that User can place the file in one fixed folder and Celonis can upload on regular interval like monthly. Can you please guide me here ?

00
.
Level 4
P
Level 4
preethi.p12Level 4
asked in General Product Q&A
I want to know how many activities occurred for each group

I have a category table, table2 and Activity tablerelation is category(N) - table2(1) - Activity(N)in a bar chart, I want to show group from category table and count of activities for each group. I’m getting no common table error while configuring a component.how to fix this for a relationship N:1:N 

20
P
Level 4
P
Level 4
preethi.p12Level 4
asked in General Product Q&A
Based on onClick of a KPI list component, the remaining components in a View like charts and tables should change It’s data accordingly

I’m using Knowledge models & Views for this requirement.I’m trying to create use the option as shown in the attached image file.I’m able to add onClick to the Kpi list component in view,but not understanding how this can be used to update a different component.Thank you

00
P
Level 4
dhruv.shah
Level 2
dhruv.shahLevel 2
asked in Data Ingestion & Infrastructure
The Data Model Load experienced an issue with the Data Pipeline Orchestrator Error

Hi All, I am facing an issue while uploading data to Celonis. My transformations are working fine but it fails at the data model load stage with the following error: "The Data Model Load experienced an issue with the Data Pipeline Orchestrator." Has anyone faced this issue before or knows of a solution to fix this. Thanks,Dhruv

130
G
Level 8
Lovise Hellner
Level 4
Lovise HellnerLevel 4
asked in General Product Q&A
Load permissions from tables - please share your experience

Hi all, I am looking into the possibility of loading data permissions from tables.But reading the documentation (here), I have a couple of questions. Do I need to first load an excel spreadsheet with my permissions in the data model, to create a "permission table", is that correct ? How does it work when you manage the data access using groups ? Instead of a column with emails, I just have a column with the group names ? Regarding the unlimited access, you just need to create a column called "unlimited" with the value Yes/No, is that correct ? Over time, if I update the data permissions (new, delete, or update), do I just need to re-upload my file in the data model to refresh the data permissions ? or do I need to do something extra ? Any experience you could share would be much appreaciated. Thanks 

40
V
Celonaut
pavan.bhara13
Level 3
pavan.bhara13Level 3
posted in Data Ingestion & Infrastructure
Hi All,

Hi All,  I have an interesting requirement, where i need to find the data type of the column (table field) in PQL.  Ex : Implementation is done in Views and knowledge model:  Case_Key = 400100200300,400A00200400Variable ${CK} = Case_Key  Requirement ==> Case when ${CK}= String then ${CK} else to_String(${CK}) END Any insights on this would be much appreciated. TIA!

11
marc.v
Level 2

Badge Winners

  • Qualified to Manage Implementation Projects
    kalparup.paulhas earned the badge Qualified to Manage Implementation Projects
  • Celonis Certified Data Engineer
    colton.linem12has earned the badge Celonis Certified Data Engineer
  • Celonis Certified Data Analyst
    luke.becke13has earned the badge Celonis Certified Data Analyst
  • Celonis Certified Data Analyst
    arushi.vashi12has earned the badge Celonis Certified Data Analyst
  • Qualified to Deliver Business Value with Celonis
    matilde.pesce11has earned the badge Qualified to Deliver Business Value with Celonis
VIEW ALL
Community Code of Conduct