General Product Q&A

Example: line belnr bukrs koart1 12345 d01 K2 12345 d01 S3 12345 S01 D4 12345 S01 Shere my extraction logic should pull only line 2 and not line 4.

I am trying to replicate the following in Cloud connector extraction job for a table named order_status: create table `order_status_filtered` as( SELECT S.order_id ,S.created_dt from `order_status` S where exists (select * from `fact_order` O where O.id = S.order_id) and S.STATUS NOT IN ('Created','Sale Confirmed','Not Started'));  I am unable to add the where exists part in the extraction filters.Is there a way to do it?

Hey guys,I want to select periods, week, month, quarter, year. I would like to create a custom objectBut it's not letting me save, I've never created a CUstomObjects before. - id: date_contract_    displayName: Período Contrato    customAttributes:      columns:        - id: EKPO.for_week        - id: EKPO.for_month        - id: EKPO.for_quarter        - id: EKPO.for_year  

For eg; I have a values in column like 9, 30, sixty days, five monthsI want to convert these sixty days to 60and five months to 5I have done this using case when for possible scenarios looking if there is any direct function I can make use of..Thanks in Advance!!

Hello everyone, We are in the process of implementing Replication Cockpit and have several questions about the best way to adapt our current pipelines to this new paradigm: 1- Our business uses multiple SAP systems and we need to unify tables across them. Is there a way to do this in real time through Replication Cockpit or should we keep the unification scripts on a scheduled data job that runs before the data load? 2- For optimization purposes, we make extensive use of filter joins during extraction to restrict our tables to just the relevant data. Outside initialization joins, what is the recommended way to maintain this behavior for replications? Should we create a transformation that deletes all rows from Table A where there are no matching entries in Table B? 3- It is our understanding that once a table is being extracted through Replication Cockpit we should remove any scheduled extraction involving it to avoid conflicts. Is this understanding correct? 4- Once a table is activel

Action Flow: Is it possible to save a CSV file on the local PC drive with an Action Flow?

Hey community, I had the opportunity to join the Celonis for Consulting and I would like to ask you what VMD Mismatch stands for:

Hi,I am using Celonis training instance and trying out ML workbench.I am referring Celonis documentation to fetch analysis data using python in ML workbench (https://celonis.github.io/pycelonis/1.6.0/tutorials/api_tutorial/01_Pulling_data/) I am getting this error on this line of code:Error:AttributeError: 'Celonis' object has no attribute 'analyses' On Line:analysis= celonis.analyses.find("testanalysis") Looking for some help on this.Please suggest. Thank you.

Hello, for some reason I can´t find any solution online for this problem. It is probably out there but I cant find it. I simply want to showcase the following: The Average throughput time between Activity A and C, but ignore all cases where it touched Activity B inbetween.  This feels like a very easy task but I can´t seem to find how to filter out Activity B. Basically I thought it would like this: AVG ( CALC_THROUGHPUT (  FIRST_OCCURRENCE [ 'A' ]  TO  LAST_OCCURRENCE [ 'C' ] ,  REMAP_TIMESTAMPS ( "_CEL_O2C_ACTIVITIES"."EVENTTIME" , DAYS ) )) And then in the component filter: FILTER "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" NOT IN ('B') This obviously doesn´t work so I am here. Maybe someone can answer me this rather simple question I suppose.  Thanks!

Hi all, How can I retrieve the second values from a source column. I want the second LINK from the PU_FIRST("MARC","PICTURES"."LINK")

We are trying to migrate a package between Celonis teams using the ML workbench. Some assets are correctly downlading while others disappear without showing an error. What is happening?

For SRM tables understanding which site is better? e.g SAP - leanx

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.

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.

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

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 ?