- - Knowledge base overview
Product Updates
Groups

Welcome to the Celonis Community

5 months ago

Home
Community
Product Q&A

Product Q&A

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

3097 Topics

Most replies

Most views

Newest first

raman.silot11Level 3

asked in Data Ingestion & Infrastructure

Delta filter using joined table

Hi everyone, I am currently working on optimising extractions in Celonis and applying delta for tables. But tables like BSEG, RSEG and CDPOS are not having the relevant date fields nor I can apply header table filters which I joined with these tables in delta filters. Is there any possible solution to apply delta on these tables ?

321

3 months ago

balu.maganLevel 2

asked in Process Analysis

Creating Users in Celonis

Hello,Can we create users in Sailpoint and can we integrate with Celonis so that user will be created automatically with a role in Celonis?

201

3 months ago

lars.henniLevel 2

asked in Process Analysis

Display correct throughout times in Variant Explorer for cropped process flows

Hi all,I try to display the correct throughout time for the process variant in the Variant Explorer (shown to the right for the graph/list) for cropped process flows.I have cropped the process scope using CALC_CROP, both as a custom dimension and as a load script filter. The Variant Explorer returns the correct process of scope, but the total throughput time shown per process variant (shown to the right for the graph/list) is still based on the default CASE_START and CASE_END and not the process defined in the CALC_CROP.I.e, the sum of throughput times between the displayed process steps is not the same as the total throughput time for the variant.Is it possible to show the correct throughput time, given the process defined and visualized in CALC_CROP?Thanks!

3 months ago

dhruv.jinjh11Level 1

asked in General Product Q&A

Hey everyone, I have designed an Action Flow using the List Items module in Microsoft SharePoint Online, and it has a limit of 3500. Essentially, if my SharePoint list contains more than 3500 records, not all the records will be fetched.

Is there a way to fetch all the records present in the list?

312

3 months ago

bennita.dutoi12Level 4

asked in General Product Q&A

Secondary axis in new views

Hi All - How can I add a line on the secondary axis to this stack graph in the new views?

883

4 months ago

hugo.deubeLevel 2

asked in Process Analysis

Forward filter through the URL in Studio View

Dear Celonis Team, I tried to forward a filter through the URL in an View in Celonis Studio. I followed the instructions indicated at the followig doc page: https://docs.celonis.com/en/advanced--forward-filter-through-the-url--e-g--from-an-analysis-.html. Unfortunately, although it is described in the docs using a View, the function to forward a filter via "?filters=.....Base64Tag..." does not work and the filtered View does not open after inserting the string into the URL. I wonder if there is a bug into the function, because following the proposed gif in the documentation it worked well in the past. Please help if you have experience using Views.

332

4 months ago

celopeers.musupLevel 3

asked in Data Ingestion & Infrastructure

Knowledge Model | APC [Data Consumption) Space tequirements / impact.

Knowledge Model | APC [Data Consumption) Space requirements / impact.Does a Knowledge Model have any APC [Data Consumption) Space requirements / impact?If yes, how can this be determined? The space size is required to be known as to discern if we’ll exceed APC space.

261

4 months ago

ayushi.ade12Level 3

asked in Data Ingestion & Infrastructure

Hi All,Any best practices on optimizing the APC consumption or any solutions.

Hi All, Any best practices on optimizing the APC consumption or any solutions.

494

4 months ago

johann.riedeLevel 3

asked in Data Ingestion & Infrastructure

Setting up a OAuth 2.0 connection to SuccessFactors

Hi community, has anyone managed to set up a OAuth 2.0 connection to SAPs Success Factors yet?We're running in some issues there and I'd be happy to know if there are users out there who were able to successfully connect the two systems. Best regards!Johann

134

4 months ago

miguel.ferna11Level 3

asked in General Product Q&A

How to download a zip file from ML Workbench directory?

I have generated a zip file with the content-cli module and now I need to download it locally, but every time I press the “Download” button it creates an HTML file. That HTML redirects me to a “Secure download” which re-downloads the same HTML. How can I avoid the HTML and just retrieve the zip file?

342

4 months ago

balu.maganLevel 2

asked in Process Analysis

ML Workbench for Predictive Analysis

I was going through various packages in the celonis and i found out that there is a package called "Celonis_ml" with no other documentation and when gone further it says it got deprecated and moved to pycelonis and the demo O2C - On Time Delivery Prediction has been built importing the Celonis_ml can anyone help what changed and how to build ML Workbench predictive analysis and what libraries need to be used an upgraded documentation..thanks!

260

4 months ago

astha.jLevel 3

asked in Process Analysis

How to add additional data in existing webhook ?

152

4 months ago

tomnguyenLevel 2

asked in General Product Q&A

How to learning using Celonis

Hello everyone, I am an employee from a technology company called Terus. I am assigned to learn and know how to use Celonis, then bring it back to apply to the company's process, but I currently do not have a clear plan for this move because in my country, not many people use Celonis.By chance, when I was researching, I noticed that this community and everyone shared a lot of information related to Celonis. I want to ask about the roadmap that everyone learned to use and apply Celonis? I hope everyone can give me an answer!

352

4 months ago

preethimani.sundaLevel 1

asked in General Product Q&A

I have not completed my celonis rising star assessment as I have taken the assessment 2 times now the assessment is not opening plss help me to complete the assessment

Please help me to complete the assessment

302

4 months ago

jonas.venneLevel 2

asked in Data Ingestion & Infrastructure

Hi Everyone,I am trying to Filter my data/table for entries, if two columns are empty. If they are empty I don't want to see them at all (Filter them from all my data).But the Filter (X!='' and Y!='') is not working.

This Screenshot show my unfilteres table:As you can see I got a lot of data where my resultsqueeze and resultvalidation is empty. I want to filter those entries. What i did is Filter the whole sheet with the following statement:FILTER ("reportdataextraction"."resultsqueeze" !='' and "reportdataextraction"."resultvalidation" !=''); But the statement is filtering every entry where either one of the columns is empty. This is my result: What am i doing wrong? Thank you for the help! Bests,Jonas Vennemann

173

4 months ago

julio.bolan12Level 2

asked in General Product Q&A

FILTER some data only when a condition is true.

I want to filter based on a condition like this:FILTER Color = 'blue' WHEN Shape = 'square'. I'm having trouble creating a formula like this because what I have tried is filtering all instances where Color = 'blue', but I want to filter only for blue color when the shape is square.I think this should be something very easy to do, but I'm having trouble. Thanks in advance :)

4 months ago

pruthvin.v11Level 3

asked in General Product Q&A

Do anyone know the PQL formula to find PR which is not converted to PO within 2 days

4 months ago

henning.gertzLevel 3

asked in Data Ingestion & Infrastructure

PQL Formula

The data model looks like this. (1) is VBAP(2) is VBEP(3) is MARA(4) is MVKE Now I created an OLAP table with columns from different SAP table. When I now want to include the SAP field MVGR1 from table MVKE is receive following error message. How should the formula look like by using e.g. DOMAIN_TABLE or BIND together with PU-Function so that I can display the field MVKE.MVGR1 in the OLAP-Table?

869

4 months ago

julia.bauerLevel 5

asked in Process Analysis

Creation of a WORKDAY_CALENDAR

Hello everyone, I want to use the WORKDAYS_BETWEEN function, however, in preparation for this function, I need to create a Workday Calendar. How do I do this within data integration/KM? Thank you so much! BRJulia Bauer

635

4 months ago

paul.lymbuLevel 2

asked in Process Analysis

Calculating Order Backlog

I’m trying to determine how best to calculate order backlog by using the activity table and event statuses. The calculation would be used to render the data into either a table, histogram or bar chart grouped into week (Round_Week(Event_TimeStamp)). Please share any ideas or code examples.

341

4 months ago

victor.diensLevel 2

asked in Data Ingestion & Infrastructure

How to use a table twice in an extraction

Hi everybody! I’m pretty new to celonis development and never ask a question here before, but I hope you can help me! I’m extracting data from SAP for Production data and now have the issue that I want to join the JEST table to two other tables (AUFK and AFVC) on the column AUFK.OBJNR and AFVC.OBJNR. How can I do that since downloading the whole JEST table means like 200 million entries :-( I hope you can help me! Thank you very much!

323

4 months ago

astha.jLevel 3

asked in General Product Q&A

How to delete trigger subscribers?

I have a trigger which is link to 2 subscribers. I'm not able to delete the subscribers, so when I delete the trigger, it gives following error.

271

4 months ago

karl.guentLevel 4

asked in General Product Q&A

In Warranty Claims and I want to isolate ("include") Claims over -$10,000 and below over$74.99. I am doing it in the filter bar (see red box below). However, I'd like to add it as a component, like the Date Picker (purple box below). I can't

101

4 months ago

denise.kruge12Level 4

asked in General Product Q&A

Finding an error in transformations

Good day, When I get an error message in my transformation “error at character 28152”, how do I find character 28152? Thank you,

342

4 months ago

andres.naran12Level 4

asked in Process Intelligence Graph

Hi, I am not able to find the Universal Starter Kit package in the marketplace, does anyone know how to find it?

When I try to look for the following package at the marketplace: The marketplace only shows me this one to download: I don't need this one, since this is designed for OCPM models, in my case I want the first one but I don't know how to get it. Does anyone have the same issue?

141

4 months ago

Page 5 / 124

Badge winners

takeo.satohas earned the badge Qualified to Build Action Flows
miwa.inouehas earned the badge Qualified to Build Views
javier.garci11has earned the badge Qualified to Create and Deliver Demos
javier.garci11has earned the badge Qualified to Deliver Business Value with Celonis
javier.garci11has earned the badge Qualified to Manage Change and Scale Adoption