General Product Q&A

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 🌍

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! 

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

Is Celonis EMS supported on any Redhat Open Shift installation?

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&

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.

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?

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.

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?  

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 ?

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.

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.

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…

Can I apply a filter in individual components in views?

Can we apply filters only to olap table so the other components in Views remain unchanged.I tried of creating a button which will route to new view which only has olap table configured in it. looking for any other approach possible for this.Thanks in advance!

When i am giving a very small-time filter (1-2 days) for the same table it works fine. Anyone faced this before? [Simba][BigQueryJDBCDriver](100034)

I am writing into a package runtime variable from input-box in a View. I want to wrap the contents of the variable with single quotes. Tried below YAML, but the single quotes disappear after I save and reopen. id: input-box-e779d853-ce7f-46ed-b5f5-ddc3d277d9d0type: input-boxsettings: placeholderText: ${ABCD} name: ABCD type: string onChange:  update:   variables:    - name: ABCD    - name: 'package_ABCD' infoText:  title: Mandatory field  content: Please enter X to create XXXXXXXX with xxxxx xxxxx. 

The status of the upload stays on "uploading files" forever. I know of the 1GB upload limit and have tried it with several different .xes files and none work.

In which module i can get data back to Celonis in a Table in Actiojn Flows?

Some of our databases used Windows authentication instead of the self-Instance/user name & password on each database. The process is, I need to login to Jump box (Server) and login to the database (MSSQL) with different Windows authentication (not just my user name)Your help & guidance is highly appreciated. Thank You!​

And Can I send data back to Celonis after creating table in Action Flows? Thank you in advance.

How to add Data labels under each bar in a view's configuration?

We want to migrate a table from a data model where the table column names have dollar signs ($) in the name. When we try to migrate the table we get a column not found error on those columns that have a dollar sign in the name. Is there a way to encode or otherwise provide the column names to the pql.DataFrame function such that it can use columns with $ signs?

Hi expert, I'm not quite good at SQL and I have a question about SQL. In my case, I would like to filter activity table with event time with its only time(hh:mm:ss). Does anybody let me know how to do that in Celonis data integration task?

Hi Guys, Just wondering if celonis provide any connection to the software Tasy from Philips? Thanks