Product Q&A

Do you have any experience with exporting Celonis app into another tools? I was hoping we could not only expose raw data but allow data discovery (inc. process explorer).

Hi folks! I'm trying to create a load balance between my connections since some of them are failing frequently, is there any way where I can see the extractor related to a connection? I think I have some extractors with too many connections

I’m trying to configure an input checkbox component with a chart/kpiI’m not getting to configure it correctly. I’m unable to use sharefilters attribute in kpi list any help on configuring this component will be helpfulthank you

I’m trying to add display rules like e.g.,background colour blue and kpi value to be in white but I’m not finding a way to add this to a textbox component. It works with KPI list component and some other componentsAny suggestion to get this requirement done?

Any best way to debug the out of the box Knowledge Model KPIs

Hi everyone,  as the title of the topic suggests, I'm searching for the possibility to connect Celonis and Marketing Cloud Salesforce. The official documentation doesn't say anything about, and there isn't a specific connector to make possible this operation. Does anyone have news of this implementation? It would be ok for me also building a custom API to retrieve data from the Marketing Cloud. Thanks in advance for the help,Regards,Emanuele

what is celonis?

uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

I want to calculate the week average daily number of employees doing one action. For that I need to calculate the number of different usersID's (thus a count_distinct) each day And then calculate the average of of those values in the same week. That will tell me, during that week, what's the average daily employee attendance to that action. How to do it? It should be fairly standard by I can't get it! I have a case table with timestamp of the action, and the user that did the action. And I want a OLAP with Week number - average of daily users I have used this struct: AVG(PU_COUNT_DISTINCT(DOMAIN_TABLE(ROUND_DAY(CASE.TIMESTAMP)),CASE.USER)) but the results are incorrect Can anybody tell me what I am doing wrong? TIA

Hi, During initial implementation there was a decision to pseudonymize column USNAM in multiple tables. Currently it was agreed that we need to have actual (not pseudonymized) users data in Celonis just like it is in SAP.Usually unticking the Pseudonymize box in extraction setup would do the trick and I will do it for some smaller tables for which we have full loads. However we have couple tables for which we are doing only delta loads, as they are way to big for full loads (over 40 GB). Doing full load for them would take ages and I'm not entirely sure how Celonis would manage with such a huge load done at once. The idea is to create one time mapping by downloading second iteration of that big table (BKPF is original one, the second one lets call it BKPF_RAW), that would only contain the 4 key columns and USNAM that is not pseudonymized. Next step would be to add new column (lets call it USNAM_RAW) to original BKPF, then update it with data from BKPF_RAW.USNAM by matching the two

What can be reasons for Open Invoices. Any Available views for Open Invoices in Accountz Payable.

Is there a best practice to chose a KPI (saved Formula) over a variable in Celonis (or vice versa)? For example, I seem to recall that all KPIs are calculated upon loading the analysis? Would that make certain uses more suitable to a variable?

I think communication is key when developing something new. However, when we are dealing with people all over the world, we need to think it in a smart way. I am looking for something opened and clear, also friendly and not full of formality. Hopefully you are able to share some good practices :) Looking forward!

I'm looking for a study group at NY/NJ/PA or virtual for Celonis Data Analyst Certification. Can you please advise? Thanks!

Hello All, can anyone share how to best respond to customer concern on subjecting their tables to cloud environment and is there any on premise option in Celonis? Thanks you

Hi, How can I "hide" a published package inside a space? Just like i can hide (Visibility On/Off) the assets inside a package, i was looking for a solution for hiding the whole package. thanks

Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)? Thanks for the help!

We are seeking to access detailed data from the accounts receivable demo, but we are unsure of the process to export this data. Could anyone kindly provide guidance on how we can achieve this?

Hi Community, can anyone tell me if there is a maximum number of eventlogs (activity tables) that can be used in a data model? Thanks Himanshu

I am trying to understand how can I use a Signal Link Explorer (SLE) component in a view.  I found in Celonis documentation orientation about Network Explorer (NE), even it is mentioned that exists SLE, but I didn't find further information about it.  I would like to access an explanation about the YAML components of it.  I found it applied at Inventory Management app and I would like to use it, but I didn't understand how to get there.  I hope someone is able to help me on it. 

Hello All. For our Clients process, we need activities that are happening in the process, but should not be shown as a process step, because it's a violation. How can we implement that?

Hi Community. Quick question here. Do we have any success story avaliable with big numbers in Telko for: Rework activities Stock avaliablity/ succes rate on minimum stock Or something similar? Thanks

Hello. I just want to ask about the BSEG table. What would be the best approach to do a delta extraction on the BSEG table to capture the changes on invoice clearing date? Currently we have 2 delta extractions, 1 is based on the CPUDT of BKPF and the other is based on AUGCP of BSEG (latest AUGCP-5days). We did the offset -5 days on AUGCP to capture the changes over the weekend since the job is only scheduled to run during weekdays only. Thank you. Regards,Marco

Hi, does anyone have benchmark values for Mining and Metals industry? Particularly for the Asset maintenance process

Hello, I am using PU_LAST to find the last activity in each case to find the user.PU_LAST ("OCH_Cases", "OCH_Activities". "User_Group_NAM") But now I always want to find the second to last activity. How could I do that? Thank you Regards,Rene