Skip to main content

Product Q&A

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

4367 Topics
david.stefa13
Level 3
david.stefa13Level 3
asked in General Product Q&A
Is there an easy way to use Action Flow to generate an Export of an OLAP table into an xlsv file (the standard export capability of an OLAP table).

Is there an easy way to use Action Flow to generate an Export of an OLAP table into an xls file? (the standard export capability of an OLAP table). The OLAP table was created via in an Analysis and has some rather robust calculations. I'd prefer not to have to effectively recreate it via Queries.

230
dennis.pflug
Level 6
S
Level 3
suvam.nayak12Level 3
asked in General Product Q&A
Hi Everyone, We got a requirement from client where they are asking whether we have the option to use Power BI dashboard as a source system and get the data into Celonis EMS. Kindly help if anyone is aware of the options available.

Hi Everyone, We got a requirement from client where they are asking whether we have the option to use Power BI dashboard as a source system and get the data into Celonis EMS. Kindly help if anyone is aware of the options available.

32
dennis.pflug
Level 6
swathi.devir
Level 2
swathi.devirLevel 2
posted in Process Management
careers.abb

Business Analyst - Location - Hybrid , India, Europehttps://careers.abb/global/en/job/87496904?utm_source= ·       Management of Strategic Data/Process Mining for FTP P2P (Procure to Pay) globally.·       Collaborate with developers, analysts, and business users (Business areas, FTP P2P program (GBS/Corporate) to understand their goals, objectives, and requirements to translate them into Celonis requirements and use cases.·       Manage, design, implement, test and validates all dashboards, analyses and reports within Celonis.·       Present implementation progress and results to users.·       Document Celonis implementations and builds a library of use cases.·       Ownership and responsibility of Data/Process Mining for FPT P2P (procure to pay) workstream globally in Celonis.·       Provoke, challenge, and feed the organization with new and modern ways of data usage in alignment with Analytics and Process Management in the ABB organization.·       Provide User Training directly to Us

50
swathi.devir
Level 2
M
Level 3
mpho.matheLevel 3
asked in General Product Q&A
What are the top 3 industries that Celonis is deployed in?What are the top 3 use cases that Celonis is deployed for?

What are the top 3 industries that Celonis is deployed in? What are the top 3 use cases that Celonis is deployed for?

21
S
Level 1
N
Level 1
nura.linggLevel 1
posted in General Product Q&A
Improve your Supply Chain Sustainability with Celonis ♻️ 

Improve your Supply Chain Sustainability with Celonis ♻️  How? Download the Realistic Guide to Sustainable Supply Chains. This guide doesn’t just cover the “why” but also how you can turn vision into action and drive change.  Read the guide to:Discover the reasons why organizations are struggling to bridge the gap between sustainability & visionLearn the practical steps to identify the areas that have the greatest impact on the scope you’re targetingUnderstand how to make tangible change within your organization’s Supply Chain processes 📗 Download the guide now to make your supply chain even more sustainable!  👉🏼 Link here Kind Regards,The Celonis Sustainability Team 🌍

20
N
Level 1
S
Level 3
suvam.nayak12Level 3
asked in Process Intelligence Graph (PI Graph)
In OCPM module i clicked on publish button and got the error message which is mentioned in the details tab. If anyone has any resolution then kindly revert.

BadRequestRemote application on http://ems2-factory-execution/ems2-factory-execution/api/internal/ocpm[POST] responded with 400 : {"status":400,"message":"Remote application on http://integration-business-graph/integration/api/internal/data-pools/48911b83-c87a-409b-9f94-d35c018d3a42/data-models[POST] responded with 400 : {\\"frontendErrorKey\\":\\"create-data-model-failed\\",\\"errorInformation\\":{\\"numberOfExistingProcessConfigurations\\":3,\\"numberOfExistingDataModelsWithoutProcessConfigurations\\":7,\\"numberOfProcessConfigurationsToCreate\\":0,\\"numberOfDataModelsWithoutProcessConfigurationsToCreate\\":0,\\"numberOfLicensedProcesses\\":10,\\"monitoringTargetPool\\":false,\\"numberOfExistingProcesses\\":10,\\"unlimitedNumberOfLicensedDataModels\\":false,\\"numberOfInstallableProcesses\\":0,\\"canCreateDataModel\\":false,\\&quo

270
S
Level 3
E
Level 2
elen.groch13Level 2
asked in General Product Q&A
Blueprint for Push CSV to Event Collection it is not working.

Dear Celopeers community, I am learning a bit more about Action Flows and would like to work with the action flow for Push CSV to Event Collection from Marketplace, but it seems to be an invalid blueprint. All the other Action Flows blueprints are working fine to me. Can I get this blueprint in some other way? Best regards! 

12
E
Level 2
A
Anonymous
asked in General Product Q&A
Can we create our own functions in queries?

Hi there,​I was wondering if we can create our own functions in queries.​For this I am using the example provided in the VERTICA documentation.​https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ExtendingVertica/UDF-SQLFunctions/CreatingUser-DefinedSQLFunctions.htm​Query 1: Create functionCREATE FUNCTION myzeroifnull(x INT) RETURN INT AS BEGIN RETURN (CASE WHEN (x IS NOT NULL) THEN x ELSE 0 END); END;​Query 2: Create tabelCREATE TABLE tabwnulls(col1 INT);INSERT INTO tabwnulls VALUES(1);INSERT INTO tabwnulls VALUES(NULL);INSERT INTO tabwnulls VALUES(0);SELECT * FROM tabwnulls;​ Query 3: Check if function exists​I can see that the function is listed under USER_FUNCTIONS(see https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ExtendingVertica/UDF-SQLFunctions/ViewingInformationAboutUser-DefinedSQLFunctions.htm) SELECT * FROM USER_FUNCTIONS WHERE function_name = 'myzeroifnull'​​Query 4: use functionSELECT myzeroifnull(col1) FROM tabwnulls;>> Ausführungs

00
carlos.taleg11
Level 5
Lovise Hellner
Level 4
Lovise HellnerLevel 4
asked in Process Improvement
Action Flow - Send HTML format email to users based on data

Hi all, I am relatively new in the Action Flow but I am making good progress. But I currently struggling to find a solution to my problem. I want to send one scheduled email to users whom created Sales Orders matching certain criterias. 1/ to avoid spaming their mail box, I want to group all the matching Sales Order in one email (this I managed to do). The format of the email is HTML to make it readible. But this is maybe the root cause of my problem since I am using a text agregator. 2/ The list of recipients will depend on the output of the query, and I can't find a way get this input to the Outlook module without getting rid of my HTML email format. Ideally I would want to send ONE grouped email with all recipients. But ONE email per user is acceptable. Note: the reason I am using an Array Agregator is because in this cases what is important is the Sales Order regardless of the number of Items/Cases. Any help will be most welcome       UPDATE: I think I may have a solution, but

540
Lovise Hellner
Level 4
C
Level 3
conny.brintLevel 3
asked in General Product Q&A
Is Celonis EMS supported on any Redhat Open Shift installation?

Is Celonis EMS supported on any Redhat Open Shift installation?

00
C
Level 3
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
What does "{t 946771200000 } " refer to? What is returned as O/P for the above part in the PQL statement -CASE WHEN "Table1"."Column1" IN ( {t 946771200000 } , {t 1009756800000 } , {t 1245145600000 } ) THEN "Table1"."Column1" ELSE null END

It is mentioned in the scenraio 5 of 'IN' Predicate function documentation page - IN (celonis.com)  Thanks in Advance!

40
abhishek.chatu14
Level 7
R
Level 1
raúl.ramírLevel 1
asked in Data Ingestion & Infrastructure
Task Mining trying to see my screenshots in Studio View

Hi, I'm having issues with displaying the screenshots in the Task Mining Screenshot Viewer component in Studio Views.  The error is the following: 

00
H
Level 1
akshay.patil14
Level 2
akshay.patil14Level 2
asked in General Product Q&A
Need help with extracting data from OLAP table using PyCelonis 2.4.0- AttributeError: 'Analysis' object has no attribute 'get_content'

I'm currently working on extracting data from an OLAP table using the PyCelonis library. However, I've encountered an AttributeError while attempting to retrieve the content of an analysis(olap table). Here's the code snippet I'm using: ```pythonfrom pycelonis import get_celonis celonis = get_celonis()space = celonis.studio.get_space('4c************1b')package = space.get_package('64**************de')analysis = package.get_analysis('e7*************b')content = analysis.get_content() # This line raises an AttributeError The error message I'm receiving is: AttributeError: 'Analysis' object has no attribute 'get_data' I've checked the documentation, but it seems that the 'Analysis' object doesn't have a 'get_content' attribute. Could you please guide me on how to correctly retrieve the data or content associated with this analysis? What method or function or attribute should I use after the 'analysis&

90
akshay.patil14
Level 2
A
Level 3
ayushi.ade12Level 3
asked in Process Improvement
Hi,How to send data using action flow in the from of excel file?

Hi, How to send data using action flow in the from of excel file?

260
P
Level 4
R
Level 1
raul.salom11Level 1
posted in Data Ingestion & Infrastructure
Hello, can you help me with this? I want to see my screenshots in a View Sheet.

Hello, can you help me with this? I want to see my screenshots in a View Sheet.

01
R
Level 1
R
Level 1
radek.jLevel 1
asked in General Product Q&A
How to setup 2 dropdowns to two separate Variant Explorer which are based on one table?

Hi Community, Recently I wanted to add two separate variant explorers with designated dropdowns for each of them whit same table as source.However after adding dropdowns, selection in one is duplicated in another slider.Can you kindly support me how to configure them so they will be connection only between 1 dropdown and Variant explorer?  Thank you in advance for your support.

21
dennis.pflug
Level 6
mallik.koruk11
Level 3
mallik.koruk11Level 3
asked in General Product Q&A
How to Epoch to Date conversion in EMS using SQL or PQL?

To explain in simple terms, how can I convert Epoch number "1691989479" to date "August 14, 2023 6:04 AM" using PQL to SQL logic?

180
mallik.koruk11
Level 3
V
Level 2
verlon.salayLevel 2
asked in General Product Q&A
Why are my errors not being automatically reprocessed even when the module is attached to a Break Module?

I've been wanting to find a way to automatically retry/reprocess errors(mostly RunTime Error) whenever my Microsoft 365 Excel encounters one. I've connected a break module to it with this configuration - but somehow it's not automatically retrying. So I resort to resolving it manually.

22
V
Level 2
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Data Ingestion & Infrastructure
How to declare a variable in the data jobs?

I am trying to create a variable and set a dynamic value to it using the below syntax. DECLARE @my_variable INT. But it shows syntax error near "@". I tried checking the syntax in the Vertica SQL and i could not find a difference. It would be helpful if someone would help on this or can share your prior experience on the same.

30
abhishek.chatu14
Level 7
S
Level 3
sean.fergu12Level 3
asked in General Product Q&A
I cannot view a table I want to extract in the interface to add a table to my extraction job.

I want to extract table RM06E out of my SAP environment, but I am not able to select it as an option when I am looking for tables to include in my extraction tasks. Why is this happening? Is this a table I can't extract? Is there something else I should be doing?  

30
dennis.pflug
Level 6
C
Level 3
chaitra.shett12Level 3
asked in General Product Q&A
APC Trend by Month

Hello! we are using the data monitoring dashboard to cleanup redundant tables and improve capacity. We want to show the APC trend by Month. Currently it sums up the APC per day and shows the total . is there a way to show this trend with accurate APC usage per month ?

40
Lovise Hellner
Level 4
S
Level 2
sainadhareddy.munagLevel 2
asked in General Product Q&A
How to send multiple Excels in one email attachement by using Action Flow

I have Created one Action Flow Get the all data by using celonis Query Data Module after that Data differentiate by using Router Module and create 4 Excel files ,These Excels Files send throught one email Attachement,How possible please guide me.Please find my Action Flow Diagram.

367
janpeter.van.d
Level 8
T
Level 2
travon.petitLevel 2
asked in General Product Q&A
Data model ErrorI got the following message for data model load error. What causes this issue?The load failed: Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship.

The load failed: Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "BSEG": key columns ("GJAHR", "BELNR", "BUKRS", "MANDT"), key ('2021', '0100408024', '7000', '100'), rows 1028848 and 1028849. Table "BKPF": key columns ("GJAHR", "BELNR", "BUKRS", "MANDT"), key ('2021', '5102905179', '4001', '100'), rows 1404891 and 1404892.

292
dennis.pflug
Level 6
P
Level 4
preethi.p13Level 4
asked in General Product Q&A
How to clear or reset the selected value from a dropdown?

I’m trying to understand if we can clear the selected value from the dropdown. For example, I’ve configured a dropdown component and assigned a variable and using it in chart/tableThe chart/table will display according to the selection. After the analysis I want to clear or reset the filters like how we do it globally…

213
kailash.potha12
Level 5
tsholo.lesof
Level 2
tsholo.lesofLevel 2
asked in General Product Q&A
Can I apply a filter in individual components in views?

Can I apply a filter in individual components in views?

384
tsholo.lesof
Level 2

Badge Winners

  • Qualified to Get Data Into Celonis
    michele.digio11has earned the badge Qualified to Get Data Into Celonis
  • Value Realization Expert
    josplezhas earned the badge Value Realization Expert
  • Qualified to Deliver Business Value with Celonis
    josplezhas earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Technical Expert
    josplezhas earned the badge Celonis Technical Expert
  • Qualified to Create and Deliver Demos
    josplezhas earned the badge Qualified to Create and Deliver Demos
VIEW ALL
Community Code of Conduct