Skip to main content

Solved

360 Topics
N
Level 3
navalan.veera13Level 3
asked in General Product Q&A
Is it Possible to Integrate Celonis EMS with ARIS Connect ( BPM Suite ) ?

Dear Experts , We wanted to understand the possibility of integrating Celonis EMS platform with third party BPM application like ARIS Connect to transfer discovered BPMN model from Celonis EMS to ARIS BPM application. Thanks in Advance. Regards,Navalan Veerapandian

63
mark.b.olive
Level 2
andres.naran12
Level 4
andres.naran12Level 4
asked in General Product Q&A
Hi team is that possible to create a filter like this in an extraction filter statement? I need to create a filter that allows extracting the data of the last 15 days every time is running.

102
andres.naran12
Level 4
Lovise Hellner
Level 4
Lovise HellnerLevel 4
asked in Process Analysis
How to create Pareto Charts?

Hi team, Is there a way to make Pareto charts in Analysis or Views ?It does not appear to be off the shelf, just wondering if someone managed to build one. It is a quite comon tool used in the process improvement field. Thanks

3010
Lovise Hellner
Level 4
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
What is the difference between an eventlog and digital footprint?

What is the difference between an eventlog and digital footprint?

94
Z
Level 4
.
Level 5
.146004200Level 5
asked in Process Improvement
Problem running Nested Skills, does anyone have experience in triggering skills from another skill?

I'm trying to kick of a manual sensor skill by using the execute process automation skill. Running this skill than triggers the manual input that is required in the subskill. Has anyone gotten to make such a link working? I'm struggling with not knowing where the issue exactly lies, since the error message is extremely vague.

12
.
Level 5
jonas.frisc
Level 3
jonas.friscLevel 3
asked in General Product Q&A
i want to setup a olap table in the studio and I have this PQL formula: Do you know how I would work?

CASE WHEN "AE_SIGNALS"."AE_SKILL_NAME" LIKE ('%Veredelung%') THEN COUNT ( "AE_SIGNALS"."SIGNAL_ID" ) * 30 / 60 ELSE NULL ENDI get the following error:The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

179
wein.nadin
Level 3
milan.eric
Level 3
milan.ericLevel 3
asked in General Product Q&A
How to add a conditional filter to a component filter (load script)?

Hello everyone, I am writing here because I couldn´t solve my issue with other questions asked. My Situation: I have an OLAP-Table with a lot of Data and dates regarding finances.Now I want to add an Input Variable where User can input a single date.Depending on that input, the OLAP-Table should change (2 columns)The field is OPTIONAL and I am struggling with handling the case of "null" as input. My current idea: FILTER "Table"."SomeDate" >=  CASE WHEN <%=DATE_OPEN_ITEMS%> is not NULL      THEN TO_DATE( <%=DATE_OPEN_ITEMS%>, FORMAT ( '%d-%m-%Y' ) )     ELSE ignore the filter all together     END;  Now if I type in '31-12-2022' it works great! But 1. If the input field is empty there is an errorand 2. the User has to use ' ' while typing it in. Any ideas? Thanks! 

204
janpeter.van.d
Level 8
F
Level 3
francois.courtLevel 3
asked in General Product Q&A
Hello, can I filter to display only multiple attributes in an Olap table ?

Hello,I need to display in an Olap Table only the “Codes” appearing twice or more (same code for different Building) : the user doesn’t want single “Code” but I am facing difficulties as I can’t put a count in my Case When statement. Do you know any way to do this ? Thank you for your time !Best regards,François  

52
F
Level 3
D
Level 3
dan.griebLevel 3
asked in Data Ingestion & Infrastructure
How to grant access via data permission for more than one value?

Hi, I am setting up the data permission for our organisation.We want to grant access to certain data models by Profit Center.However a certain Business Unit may have more than one Profit Center. When I limit the access to a data model to these Profit Center, only the data associated with on of the Profit Center is shown in the Analysis in Studio. ExampleBusiness Unit A uses Profit Center Offline, OnlineTherefore the data model access is granted for Table.Profitcenter --> Offline, OnlineBut in the analysis only Profitcenter Online is shown Do you have any idea why the data permission works like this?Or did I miss something? I am grateful for your advise.Dan

54
D
Level 3
P
Level 2
pierre.aless12Level 2
asked in General Product Q&A
How can I enable the Transformations Center in my Sandbox team? Currently I don't the the option in the "More..." drop down menu.

How can I enable the Transformations Center in my Sandbox team? Currently I don't the the option in the "More..." drop down menu.

11
S
Level 1
irfan.suria12
Level 4
irfan.suria12Level 4
asked in Data Ingestion & Infrastructure
Calculate AVG partitioned by week (WINDOW_AVG?)

Hi, I have the following use case and challenge: Use Case: Add a line as second KPI to an existing column diagram that shows the average of a KPI value for each labor week Dimension: ROUND_DAY("TABLE"."TIMESTAMP") KPI 1: COUNT("TABLE"."NUMBER" || "TABLE"."FIELD") - columns KPI 2: Show the average of KPI 1 from Monday - Friday for each week - line My attempt: WINDOW_AVG(COUNT("TABLE"."NUMBER" || "TABLE"."FIELD"), 0, 5, ORDER BY("TABLE"."TIMESTAMP"), PARTITION BY(ROUND_WEEK("TABLE"."TIMESTAMP"))) This does not work unfortunately as I can not use the COUNT within the WINDOW_AVG function. Does anyone know any alternatives?

105
irfan.suria12
Level 4
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Restrict data extraction to the last few years

Hi, we have a requirement to restrict extraction of purchase orders to last 2 years. We are planning to go ahead with ERDAT from EKKO table. But what about other tables like T*, CDHDR and the rest. How can we restrict data extraction in those tables? Also, How can we make EKKO as a parent table to consider the extraction of the rest of the tables based on the data from parent table like EKBE-EBELN = EKKO-EBELN?

64
D
Level 3
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Connection issues with Standard SAP Connector

I could able to successfully establish connection between SAP ECC and Celonis EMS standalone and the test extraction works fine. Now when I try to install standard SAP O2C connector with this connection, I get the below error. I dont get this error if I test the connection defined outside the connector. Request your inputs. 

112
D
Level 3
A
Level 2
ayan.banyoLevel 2
asked in General Product Q&A
Hi ,Do we need to setup Extractor server to Connect to SAP HANA ?

In celonis documentation in one place it says to setup extractor server for SAP HANA , and in another place it says to access data using API . So , a bit confused on this . Any help is highly appreciated. RegardsAyan 

146
teuku.faruq13
Level 5
salma.zeped
Level 4
salma.zepedLevel 4
asked in Process Analysis
How to activate the "hide column" option to temporarily hide a component in Views.

Sometimes this options shows up and sometimes it doesn't. Should it be manually input in the code?

54
salma.zeped
Level 4
J
Level 2
jannes.nagel12Level 2
asked in Data Ingestion & Infrastructure
Celoxtractor - Custom Messages in Extraction Log

Greetings,is it possible to display custom messages, defined in the python script of the celoxtractor, in the real time log of a extraction (when the extraction gets executed)? We are currently writing debug messages to local logs on the celoxtractor server. Having it directly in Celonis would be a blessing. Best Regards

31
J
Level 2
W
Level 2
willem.van.d11Level 2
asked in General Product Q&A
Do overlaying components increase the page's data usage? 😕

Some of my pages contain (a few) hidden components behind big grey background text boxes. In one case, it had four variant explorers. I'm wondering.Does this reduce the page's speed?Can I check the consumption of a single analysis sheet? Thanks very much in advance for your time 😀

02
W
Level 2
C
Level 3
claire.chen12Level 3
asked in General Product Q&A
Data Extraction - Error executing function /CELONIS/EX_STATUS

I had this error occurred during data extraction and could not be executed. Does anyone know why?

153
G
Level 8
P
Level 4
preethi.p12Level 4
asked in General Product Q&A
How to add days to a date column in vertica sql?

I want to calculate start and end week of a particular date where week start date is Monday and end is SundayI’ve tried using ADD_DAYS & DATEADD which is in supported vertica sql functions but getting error that it requires permission

294
P
Level 4
omar.elmou
Level 3
omar.elmouLevel 3
asked in Celonis Academy Group
Dear Celomates,I encountered a problem during file upload. The case table (xslx) is attached as well as screenshots. Screenshots include data type choices in order to trouble shoot possible causes of failure. Many thanks.

Dear Celomates, I encountered a problem during file upload. The case table (xslx) is attached as well as screenshots. Screenshots include data type choices in order to trouble shoot possible causes of failure. Many thanks.

55
omar.elmou
Level 3
D
Level 3
dinesh.kumar35Level 3
asked in Data Ingestion & Infrastructure
What's the best practice for Master Data tables Load, Full or Delta?

Hi Experts,Could you please advise what's the best way to load Master Data tables like Vendor, Material etc. In my opinion, since the tables are not huge, can be fully loaded each time. Any different view suggesting delta load etc. from a best practice perspective? Please guide. Thanks!

45
ravi.kumar23
Level 4
omar.elmou
Level 3
omar.elmouLevel 3
asked in General Product Q&A
Hello,I have a problem when uploading a csv file (activity table). After selecting the file only 1 column is returned when oonfiguring the data schema. However i was expecting multilple columns. Please find attached the c file and a screenshot.

Hello, I have a problem when uploading a csv file (activity table). After selecting the file only 1 column is returned when oonfiguring the data schema. However i was expecting multilple columns. Please find attached the c file and a screenshot. Thanks!

36
omar.elmou
Level 3
R
Level 3
rahul.bhat11Level 3
asked in AI
Hi All,Is there any way to access the data and display it from the tables from the datapool in the Machine learning module and later do some queries and push it back into the datamodel?

There is a method to push data into the datamodel, but i could not find any that can access it.Please let me know if anymore details are needed.Thank you 

115
M
Level 3
andré.link
Level 3
andré.linkLevel 3
asked in General Product Q&A
How can I calculate the Share of Product Type for each Delivery Number?In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of

How can I calculate the Share of Product Type for each Delivery Number? In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of result.

72
andré.link
Level 3
J
Level 3
jurgen.gakovLevel 3
asked in General Product Q&A
Execute an Action Flow automatically with a Skill triggered by new data within in Action Engine

Hello togheter,  currenty im trying to set up an action flow which is triggered by new Data in an Action Engine. I read that this can be done via a Skill. The Action Flow starts by using a custom webhook and then quering data from Celonis. For the skill, i first set up an Action Engine Sensor and secondly an "Execute Action Flow" command. Within the Action Engine i filtered the data for the data im looking.  Currently I am facing the problem that if I delete all manual inputs in the 2 commands of the skill the skill seems to trigger the action flow but the custom webhook component within the action flow doesnt receive any data. Based on this if I want to put data into the webhook it will be done manually, which is not the point of the aciton engine.  So my question is: how can i set up all these components that the skill, based on new data in an action engine, only triggers a action flow without trying to provide data to the action flow? Is that possible? Thank you very much!

101
R
Level 4

Badge Winners

  • Masterclass in Implementation
    shashank.sharm12has earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    alvaro.rivashas earned the badge Masterclass in Implementation
  • First Post
    emily.helvehas earned the badge First Post
  • Qualified to Prove Celonis Value
    Gero Busatishas earned the badge Qualified to Prove Celonis Value
  • Qualified to Manage Change and Scale Adoption
    tim.winklerhas earned the badge Qualified to Manage Change and Scale Adoption
VIEW ALL
Community Code of Conduct