Product Q&A

Need to do in PQL, not in backend SQL

ADD_DAYS(KPI(BLINE_DATE),KPI(CATEGORY_VENDOR_TERMS_DAYS)) where KPI(CATEGORY_VENDOR_TERMS_DAYS) = GREATEST(KPI(INVOICE_TERMS_DAYS),KPI(REG_VENDOR_TERM_DAYS)). The output of above KPIs is days only in INT value. Not sure why this error is showing up.

I get the following error while trying to "Export Data (XLSX)" from an OLAP Table: "Failed! (Syntax error near < after reading () at line 2" The Analysis settings allow excel and csv export of analysis components "Export Cases (XLSX)" works fine

Is there a way to extract the data from OLAP table which includes color formatting into Excel?

can we create dependency between action flow and Data model/Data Job successful run. This is to make sure that if the data model did not load or the related data job ran in to some error then the action flow also does not run on that schedule.

Hello everyone. I am trying to create an action flow that send a message one on one, creating a chat.   However, when I run the action flow it gives me the following error:  [400] Exception has been thrown by the target of an invocation. Does anyone Know how to solve it or what is causing it ?

The premise is in regards to the process explorer and its behavior when applying different levels of filters:applying process-related filters (flows through, select cases going from A to B) everything works as expected.Applying attribute selections on an activity level, i.e. selecting all activities performed by a single department, process explorer returns all cases where at least one activity within that case abides by the selected filter.Thus it appears that the behavior of the process explorer is as follows:First find all activities that meet the defined conditionSelect all cases that belong to those activitiesvisualize all activities for those cases in the process explorer without filtering the activities that do not meet the criteria. What makes this matter more complex is the following:Standard Process Explorer KPIs (case count, activity count) are calculated based on the latter conditions. So all information of the case and all activities regardless of activity attribute condit

Hi everyone, We are having some problems with the load of data chunks, sometimes its gets too longer to load a single chunk, in the process many times it stops at any point of the execution, its freeze for one hour or more and after continue. Please if someone had face this problem could you tell us what we can do to inprove this stops of execution. Many thanks. Best regards.

Hi I am looking into a product portfolio analysis based on SAP OTC data and would like some input and inspiration related to Celonis use cases. Is the SAP table, VBAP.ARKTX, the correct one to focus on for product information?

I am struggling with the implementation of a Multi-Event Log with O2C and P2P processes. After building the data models and succefully loading it, I am not getting the _CEL_MERGED_ACTIVITIES table generated. How could I do to fix the issue?

Does anyone have a full list of Analysis (Process Analytics) Edit mode keyboard shortcuts? Can you share please? Cannot find it anywhere in the documentation E - enable edit mode Shift - toggle edit mode 1 - jump to sheet 1 etc.

What the max size of number of character that can be extracted in table.column of type Text in celonis.

Hello,  There were no announcements about new Pycelonis version, however recently, by accident I&#39;ve seen that 2.0.0 appeared out of nowhere. I&#39;ve took a peak, and I&#39;m dumbfounded. It&#39;s completely unreadable, missing a lot of important information (like examples or methods/attributes that can be used). It&#39;s also important that even if you find some example, it&#39;ll be single line of code (or two) that won&#39;t work even with modification... It should be marked as BETA Version, and users feedback should be taken into consideration. Also very important migration guide is very easy to miss:https://celonis.github.io/pycelonis/2.0.0/tutorials/executed/04_migration/01_migration_guide/ Some more interesting screenshots: 1) Action flows: thanks for detailed description on how we can interact with Action flows!2) Lack of the most useful function: api_request() It was only a wrapper for request, however it allowed to get things like list of Celonis users very conveniently. 

I did some courses in Celonis, how do I get badges for the same? I don't have anything in my Credly account too. I need to do some other courses too but holding them off till I understand the certification process

Hi Andre,Can you please help me Celonis on-premise SAP Agent installation,I would like to Work on SAP in Celonis studio. Can you please help me out? Thanks,Nandita R 

 From &quot;COMPONENT+&quot;I would like to create a same in the dashbord (figure below from Process Overview).

How I will get certificate from you after complete my course.

Hi I have following requirement to have ceolins user info. in SharePoint O365 excel file Step1: Download &amp; Upload all Celonis User Information in Excel File in office 365 (Do we have any database table for this user information, like when the onboarding was done, when user was locked and which user groups and permission we assigned to this user, I want to see that information in SharePoint excel file.) Step2: Every Onboarding, off-boarding and locking of user get updated by action flow in Excel file in Office 365. Celonis User Database --&gt; Update in O365 Excel file on any change in Celonis user  ThanksAnimesh

Hi Can anyone help me understand this error message please? I&#39;ve used templates throughouthttps://guidemesolutions-startover-c4c.us-1.celonis.cloud/

Upgraded data integration release date? I read a while ago about the new changes to the data integration section in the Celonis EMS. I can't find if there's any date set when the update goes live. Is there a date set? Thanks in advance

It is already possible to execute data jobs and data models. But I have not found anything for schedules in PyCelonis Docs. The reason I want to do this is to distinguish between an automatic execution via DI/Python schedule or a true manual one with a &quot;real&quot; user behind. If I execute a data job via Python, it will be shown as &quot;Manual Execution&quot; in the logs. Best regardsIrfan

Hello, Do you have any experience how to in corporate MSEG & MKPF into O2C data model? Seems that we can join MSEG to MARA through material number. I would be grateful for any hints. Best regards, Lukasz Best regards, Lukasz

There is one file per analysis and another for the entire package, all in YAML script detailing the visuals.

Will i be again required to participate to complete 3 certification or I will be considered as certified ?

Hi All, I have a quick question and I tried to find out on Celonis help but could not. I am trying to create an action flow which can access different data models to make a consolidated report (we have multiple instances of SAP)SO instead of creating 5 different action flows, I am planning to implement only one. Could you please guide if that is possible and and if yes, how? Thanks!