Product Q&A

For joining tables by timestamp I need to round by the minute. I found date_trunc listed as supported function but can't get it to work. update TABLEset MATCH_TIME_START_MINUTES = date_trunc('minute', TIME_START); gets me this: Execution error: ERROR: Function date_trunc(unknown, varchar) does not exist, or permission is denied for date_trunc(unknown, varchar) TABLE.TIME_START is converted with to_timestamp() before and then looks somewhat like '2022-02-20 01:04:32'. How can I "round_minute" in data jobs?

Can someone please help me with the Automation rate PQL formula, when we have the User type as A and B?

Is it possible, that I create an OLAP table or a histogramm, that categorizes by, lets say 5 different amounts of attributes, and sums the number of cases that belong to one of those categories?Here is an example: Case 1 has Attribute ACase 2 has Attribute ACase 3 has Attribute BCase 4 has Attribute CCase 5 has Attribute DCase 6 has Attribute ECase 7 has Attribute ECase 8 has Attribute ECase 9 has Attribute ECase 10 has Attribute E  -> My table should show: No. of same Attribute Case Count5 /// 5 --------------(cases 6,7,8,9,10)2 /// 2 --------------(cases 1,2)1 /// 3 --------------(cases 3,4,5)   I only want to display the Case Count per No. of same Attributes. Furthermore I want to filter on for example all the cases that have the same amount of attributes.  Would that somehow be possible to Create such a table or histogram within Celonis? Best regards

Hello Do you have any case studies using Celonis for eWM data model within S/4Hana Cloud? Thank you

Data Upload execution 581859e5-c443-4108-b042-0b9838112fd9 has failed. Failure type OTHER_CONVERSION. Failed to parse text in CSV. Length of parsed input (15001) exceeds the maximum number of characters defined in your parser settings (15000). line=297954, column=39, record=42988, charIndex=90270185 caused by Failed to parse text in CSV. Length of parsed input (15001) exceeds the maximum number of characters defined in your parser settings (15000). line=297954, column=39, record=42988, charIndex=90270185. Celonis Support ID: ef2703fe-10f5-4845-9b87-f67953166d29

The same function was working a week back, but we are recently noticing that api_request() is not an attribute of Celonis anymore.  Same goes for Celonis.pools() function as well. where it displays the list of data pools available. Any inputs on how to tackle this issue is much appreciated. TIA! 

Hello team,​I'm unable to find pie chart and radial component in view.can anyone please help me with this.thank you in advance...

Hi, is there a unique repository for all Industry wheels?I was able to find only the value trees in the Celonis Library.Thanks for your HelpW.

Hi all, I have exported my data pool as a .json file but I have not found a way to import it via a button in Celonis or via CLI. Is there a solution to import the file into Celonis? Thank you.

I have created KPI List and Add on Title name but It was showing Title Name And KPI name How to hide KPI name.??

In the doco, there is a description of how to connect different teams to one extractor but not how to configure this for Linux. Any ideas? https://docs.celonis.com/en/how-do-i-connect-to-multiple-teams-with-the-same-extractor-.html

I have 3 tables:Fact Table A with n entries per case and a time dimension (round_hour)Case Table which containts the case keysAnother Fact Table B with m entries per case and a time dimension (round_hour)The data model is n : 1 : m. Unfortunately a generel snowflake model is not possible. Now I need to sum up the duration from Fact Table B aggregated by the time dimension from eventtime2 (round_hour) and display the sum in a chart. The time dimension for the chart is represented by the time dimension eventtime 1 from Fact Table A (round_hour). I tried bind, domain_table in combination with PU-Functions but nothing worked.  Is there a any way map those time dimensions from different fact tables with a n : 1 : m relation? 

Hi, I am receiving "Column name is reserved" for a particular column in table that is causing the complete extraction of that table to fail Is there any way to change the name of column while extracting ?

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).

I’m trying to create an Action flow and Action skill to generate a PDF report of the Studio Views, but I’m only able to generate for Analysis sheetsdo we have an option to generate a pdf report of Views?

I have done to create tables and charts in view but how to add table border margin colors and in charts & graphs section how to add in different colors.

Hi, I am running through the Celonis Guided Learning tools and through the build Analysis, the "Configure a Date Picker" it always takes me back to the start and I can't go through the tutorial. I have already done the previous tutorials

Hi All,I have created and used variables in analysis before. But I don't know how to use variables in view and KM. I'm able to create variable but can't use it in formulas.Can anyone help me with this. Thank you in advance.

how to remove the graph control (#) in process explorer ?

Business Analyst - Schwerpunkt Customer Value Analytics (m/w/d) (Vollzeit, Teilzeit)E.ON Energie Deutschland GmbH Location: Essen (NRW), München (BY) (Hybrid)Description: Du unterstützt uns bei der Bewertung des Bestandskundenportfolios anhand verschiedener analytischer Use Cases mit den Schwerpunkten Lifecycle Analysen, Preisanpassung, Portfolio - Analytics und Kohortenanalyse. Dazu screenst du Daten und baust Datenmodelle zur Abbildung der Business Logik auf.(Check out the full description following the link) Apply here

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

Is there a way to share Business Miner insights with users who do not have access to Celonis (such as a download)?

Hi there, I am working with the Views App in Celonis Studio, and one of my graphs is a stacked barchart, with two KPIs. I am looking for a way to set the color for each KPI separately.  I already found a way to include diverging colors for both KPIs treated as one group, but that is not optimal because I cannot choose the color that I want since there are not so many options for that setting. So I would like to set the color for each KPI independently. The YAML Code looks like this id: chart-xxxxxxtype: chartsettings:  name: NAME  showLegend: true# colors: DIVERGING_RED_TO_GREEN (THIS IS THE LINE I WANT TO REPLACE)  encodings:    x:      field: RECORD.ATTRIBUTE      type: ordinal  visuals:    - mark:        type: bar        bandwidth: 0      encodings:        y:          stack:            - KPI1            - KPI2      legend: true      id: b9ddxxxx      order: 100  sortBy: []  limit: 1000  Thank you very much!Best regards,Javier

I am on a Udemy course that uses the Celonis EMS Free. I have subscribed, but when I login I am prompted for an MFA token. I get a Verification Token via Email that does not work. How do I get past this?

Hello Team, I need information on hire to retire work day connectors and what tables need to consider for extraction or uploading files. A brief on establishing connector tooo. If any one can share required tables and some links on connectors please let me know. Thanks in advance.......