Product Q&A

How can an order be matched with an invoice in SAP? In other instances, the amount on the order is not the same as the amount in the invoice.

HI Community, I have created some views on Celonis Studio and published. But these views are not visible on Apps. Do you know what could be the possible reasons for it?

For the following AP KPIs, is there anyone who knows the definition (formula) for each KPI. And in which Apps where can I find the KPIs.・Collection Effectiveness Index・Accounts Receivable Turnover Ratio・Average Days Delinquent・Days Sales Outstanding (DSO)

I use PyCelonis to get Data as follows: analysis = celonis_manual.analyses.find()sheet = analysis.draft.sheets.find()component = sheet.components.find()df = component.get_data_frame()But sometimes get_data_frame() doesn't work and i get the following Error:  Exception: Export failed. Status: {'id': 'aab0d447-a0d5-419d-b25d-36ee3d504b71', 'exportStatus': 'FAILED', 'created': 1702286071091, 'message': 'Encountered " "(" "( "" at line 1, column 10.\\nWas expecting one of:\\n ")" ...\\n "||" ...\\n ', 'exportType': 'PARQUET'}  I dont understand why as the Tables do not seem different from the ones where it works. Im working in pycelonis 1.4.1.  Any help would be greatly appreciated.  Thank youGina

Hi Community, I am trying to create a view, which has 2 different components(Tables/Charts) with different knowledge models behind it. I have created 2 separate knowledge models, but was not succesful referincing them on the same view. Does anyone has experience building components withdifferent knowledge model on the same view?  Best Regards, Sooraj

I've built a simple variable with static value. If I enter in the code editor, it shows a value (like 3.05, that is fine), but if I exit, it shows me NULL, and in the analysis it follows the NULL behaviour, creating lots of messes. I don't understand why it is happening, since if I try to fix it, it shows me the correct value.I can't replace it in the formula of the KPI, since I'm calculating a static QUANTILE value to be compared which every row of a table, if I put it directly in the formula it tells that I can't use aggregation function etc etc...

Does anyone know anything about Extract display value columns?They are displayed in General under Extractions in DataJob.

In marketplace , we are seeing Concur connector, but while installing it it not showing any transformation scripts and Data model. Any help?

How do i access the Partner Performance?

The rescheduled date is sometimes null and in some cases there is an entry, hence the whole module should not stop once the date is null.

Hi folks! I'm trying to get the attributes of shipment activities in the VTTK, but when I link the VTTK through the VTTP in the Datamodel. I have the following error message "Not common table" Do you know how to handle this?

Von: Karl-Friedrich Löschhorn Gesendet: Freitag, 8. Dezember 2023 12:05 An: partnerportal@celonis.com Cc: Marco Poloni <marco.poloni@paw-systems.com> Betreff: How to become a Celonis Partner? Priorität: Hoch Sehr geehrtes Celonis Partnerportal Team,  im Namen der People at Work Systems AG bewerbe ich mich um den Zugang zu Ihrem Partner Portal.Wie kann ich Celonis Partner werden?Was ist das am besten geeignete Partnerprogramm für unsere Organisation?Gibt es einen strukturierten Anmeldeprozess und wo finde ich diesen? Im Marktsegment „Travel and Transportation” gibt es mit der Deutschen Lufthansa AG bereits einen gemeinsamen Kunden mit einem gemeinsamen Projekt. Informationen über uns finden Sie unter www.paw-systems.com Ich freue mich auf ihre baldige Rücksprache. Mit besten Grüßen Karl-Friedrich LöschhornVice President|Business DevelopmentPeople at Work Systems AGFeringastraße 10 AD-85774 Unterföhring Tel:       +49 - 89 - 540 42 45 - 0Fax:     +49 - 89 - 540 42 45 - 11Mobil:  +

We are trying to build a profile view where we are trying to add a date picker into it, but we are unable to find any date picker component in Views as we have it in Analysis. How could we add a date picker in Views? Please assist with this question.

Good morning, I am looking for a way to convert a BLOB field (i.e. a long varbinary in vertica sql) into a string, in order to capture a hidden information. Is there a way to do this conversion? I am not finding anything in the documentation, except for the question in https://www.celopeers.com/s/question/0D50700000lQGtPCAW/converting-from-binary-to-string-in-ems?language=en_US . Thanks

Unable to find Link to Level 2 and Level 3 courses

why do we only see 33 attributes in the KM and when opening the Record we see 79?

Is the process explorer customizable in such way that in addition to the number of activities per process step, the automation rate of each step will also be shown. Is this possible or has anyone tried to implement such a requirement?

I have created a view variable which will capture selected ids by user from a list of drop down. if 3 or 4 customer number are seleceted out of 100, i want those 3 or 4 number in data pool. I was trying to capture those customer numbers via manual sensor and write data in table skill, but the manual sensor was not able to take inputs from view variable.  What will be the way if i want to get those selected numbers in my data pool?

Hello All,Where is my certificate. Kindly confirm where i am getting certificates.

Hello @All i'm trying to export data from an ready/productive Analysis with pycelonis. My Analysis has a table, from which i got the query (compontent.get_query()). With this query i wanted to export the dataframes (data_model.export_data_frame(query)).I'm getting some errors on all variables and saved formulas.e.g: PQLColumn(name='<%=ZZ_ABC1%>', query='<%=ZZ_GHJ2%>'), Is there an option to use variables & saved formulas in pycelonis export? Thanks in advance!  

Hello everyone, I am new. My environment is case centric. At KPI level, I want to count how many customers have 3 cases. And I also want to count how many customers have more than 3 cases. Can someone help me please? Thks

Hi, I am working on a university project. For that, I constructed event logs in such a way that the event logs contain some parallel processes. But Celonis is showing all parallel processes in a linear style. But I want to see all parallel processes in parallel style in Process Explorer. So, can you please help me know how can I modify my event logs or how can I visualize parallel process as parallel in the academic version of Celonis. If you recommend some video tutorials that will be more helpful.

Ayushi Ade5 months ago Actions for this Feed Item CommentHi Marco,I have already created an ML workbench to create/save as an excel file and send via skills and this is working properly. In one of your solution you have develop this can you please tell me how you develop this cause i am looking for same solution for my use case if you have any screenshots for it please share so it can be helpful for me 

I want to be able to get the username of someone that executes a skill and update an augmented attribute with the username. In Knowledge Model, I created a KPI with the PQL formula - USER_NAME(). This works fine in the knowledge model and returns the user. However, in action flow when I use Get Rows to get the KPI, it returns Unknown User. Does anyone have an idea why this is the case or perhaps any other idea to achieve what I want?