Product Q&A

Is there a variable in PQL that I can use to display the datamodel refresh date & time?

Hi Everyone, I want to ask if exists some way to extract data with PyCelonis lib but based on SQL scripts ( with transformations, for example). I know that we have access to the SQL script by this example: https://github.com/celonis/pycelonis-examples/blob/main/pycelonis1/03_Connectivity/05_Transformation_Download_to_MLW.ipynbbut my idea is to use this SQL and run it and export (.csv files ) or work this data with Python ( pandas data frame ) .

I am trying to bring in LIKP fields like ZZCarrier, Delivery number into VBAP. In the transformation while doing a left join i get duplicates per case key in VBAP. Is there any other way to bring in Likp field into VBAP?

Level 1: Newbie (0 - 10 points)I just join Celonis. Help me to explore Celonis Platform!

I want to add days to a date in vertica SQL in transformations. I have tried using DATEADD and TIMESTAMPADD, both are showing permission denied. Please help how can i achieve this.

Hi, I wanted to create a pdf report of an analysis sent to my mail account. Therefore, I created an action flow with the Celonis module "create PDF report".To filter the analysis to get the correct data, I'm using a runtime variable which needs to be implemented in the action flow.I implemented it as you can see on the first picture. The result of the pdf report is, that it doesn't show me any data in my charts as you can see on the second pic.  Thanks for helping me.  Niklas

Hi All, I am trying to create a overlay view in new studio, created a target view as well. However when I click on the sales order in my main view the target view value is not updating, mapped a variable as well

Hi All, This is the detailed explanation regarding what Information I have, what steps and option I followed to make this connection:Steps followed: Add Data connection-->Connect to Data Source-->custom-->Build Custom Connection-->Build a new extractor: (1) Extractor Information: Input provided in the Name filed(2)Connection Parameters: Unchanged(3)Authentication Methods: API Key Authentication Selected and In the API Key header: Key generated from admin setting was entered .e.g. x-api-key:"Generated Key".(4)Define Endpoints: Add new endpoint--> (A)Configure Endpoint:  Endpoint name(entered)-->HTTP Method(GET)-->Use this endpoint for connection test(enabled) (B)Configure Request URL: {Connection.API_URL}/"Endpoint URL entered"Request Parameters: Leaved as it isHeaders-->Add new header-->"Key and Value" enteredPagination Method: Leaved as it is (C)Configure Response: Leaved as it is Clicked Fininshed. 

Hi team, Is there any way to link power apps to celonis to enable workflow mechanism.

I would like to create a KPI to determine the % of the confirmation date changes which were caused by a requested date change in the Order to Cash activity flow.If the 2 events: Requested Date Change and Confirmed Date Change happened at the same time and with the same change number (which is stored in a separate column in the activity table), we assume the confirmed date change was caused by the requested date change.What would be the best way to check for this? SOURCE? TARGET? ACTIVITY_LAG/LEAD?Any ideas are appreciated. 

Hi team, This is related to PQL function CURRENCY_CONVERT_SAP. I want to know how this field GDATU from TCURR table is converted to date once it is in string in celonis.

I am trying to upload FK company logo using YAML script in new view. Below is the coding of image uploading. I am not getting any error however image is also not appearing in front end.Please Help. id: image    type: image    settings:      src: data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALIAAAA1CAYAAADlP7EIAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFiUAABYlAUlSJPAAABDqSURBVHhe7Z0JdFXFGcfdal0qLtVqF5daW6217rba2oW61H2ptdtpra0giqAiIqIoiwJVEYEiiGJFUVlUNkEBKUmABEJIQkgIEEJCCEsWEkjIBgGm87u5kzd37ryXPAL0CPM/5zvAvd9d3tz/zHzbDIedc/ZZwomTL7scJhwcDgI4IjscFHBEdjgo4IjscFAgQOSahl2ifPtOq+xo3O1rRbB7zx5RWdto1a+o2Sn2+Ho66nfutuojtfL5Dg57gwCRczfViCv7p4nLDblCymtz1ovGXUFqSh6LgTPXhfSRaweli/mrt/qaERSW14sbXs20XtPpvVUe0R0c4kXItHjw3VXisAfmheT8ZxaLjVt3+FoRbKlpFF9/bIH1mr+NyRUNlpG81yf5Vv2Tus4XM7K2+FoODq1HiMgZRdvFVx5MCJHsiA4JYuKSUl8riF6frA3pIxC8uKLe14qgtKpBHPtQovUaOtJum03i4BADISJv3NogvtszxUqye0dm+1pBLMjbJg7vENZHpmaW+1pBXN4vzap/Sd9UsdMwYRwcWkKIyFuk0/XTF5daSXZxn1RfK4jsDTXia52TrNcM+6LY1wrirhHLrfqnyVHc5lg6OMSC

Hello everyone, I want to create a dimension switcher within a view (s. example from a Celonis App). In the installed APP, however, I cannot access the originial knowledge model as the one visible is an extension. Hence, I do not know how the configuration of a dimension switcher is done on the YAML knowledge model side.  Does anyone have a step by step explanation?Thank you! Best regardsJulia Bauer

Hi Celopeers,  Is it possible to create an overview (i.e. Olap table) of all Celonis users (per group), and set up an action flow with this info (i.e. send a list of all users to specific email addresses monthly). Does something exists about it? I`m looking for smth that automates the manual process: manually going to Admin/Users & downloading the user list.

Hi everyone,I am currently playing with features like the PAM in OCPM and stumbled across something that struck my mind. I remember that in the context of case-centric Process Mining, Celonis is using a Token-based-Replay variant for Conformance Checking. Within the PAM (Process Adherence Manager) for OCPM, there is now an "Alignment Explorer" available. Is this based on Alignment-based Conformance Checking techniques, or is Token-based-Replay still being used for this? Is there a similar implementation of this in case-centric Process Mining? Tim

Hello All, I am trying to get a KPI PQL statement for SAP field KDATE(Date) when the date in the field = 9999-12-31 Has anyone done PQl statements like this before? Thanks for your help in inadvance

Hi all,  I have questions about SAP onetime data download ABAP program.Doese anybody give me the screenshot for selection screen sample? I mean, I'd like to know the syntax to write in selection scree, such as comma separating or if I need to use quotation to define table name.Is all data extracted if I push Execute extraction in background if I write selection condition to custom table data download field? (I mean, will data be downloaded wheateher O2C data + selected data or only selected data?) (In case I'm using O2C download template.) Regards,

Hi All, I'm wondering if there is an option to see history of augmented attribute? Let's take a look on below example: If we are changing status (augmented attribute) to "Urgent", we always want to see this case with priority "High", no matter that we will change this status to "In progress" later on. Priority field should works like IN() formula - we want to check if at least once this status was used so the priority can be assigned properly. In addition to that, can we somehow see the history of those changes in simple table? For example three columns - date | user who set the status | status.And I'm not talking about Activity History which seems to not be very customizable and is showing each field as separate change. Many thanks in advance for your help!

I want to insert date-time data from one table to another but I am getting Execution error: ERROR: Column "event_time" is of type timestamp but expression is of type varchar error

How can I pass data from all the tables from a view on a button click to a webhook, if through YAML then how can I configure it in YAML?

To join these 2 tables I use the fields "MANDT" and "AUFNR".In the table B, there can be several dates for the same order (AUFNR) and in table A I want to have only the most recent date for the order.So I tried the formula LAST(table.date ORDER BY table.date ASC) but it did not work. CREATE VIEW PP_QALS AS (  SELECT DISTINCT    "QALS".*,    LAST("AFRU"."IEDD", ORDER BY "AFRU"."IEDD" ASC) AS AFRU_IEDD,  FROM QALS_U_PP AS QALS  LEFT JOIN "AFRU_U_PP_TEMP" AS AFRU ON 1=1    AND "AFRU"."MANDT" = "QALS"."MANDANT"    AND "AFRU"."AUFNR" = "QALS"."AUFNR"), Do you know how I can add this date field in table A ? @lovise.helln​ (FYI)

I am unable to find the Celonis value calculator anymore where we could input value and it would give us the potential benefits that can be uncovered. Has it been removed or am I doing something wrong?

Populate variable based on another attribute of selected record (e.g. select material no via drop-down, but populate variable with value of material group of selected material, i.e. another attribute of the selected record) - is this possible?

Hi All, I am trying to create a conformance analysis for the P2P process. The problem is that we don't have one process model for it since it is a really complex process with multiple sub-levels. I already have the high level process model and its sub-levels, but they are on separate files and I can't upload them all on Celonis for Conformance Analysis. Are there any suggestions on how to address this and perform a conformance analysis for a complex process such as the P2P process? Thank you! 

Vendor registration for deploying remote technical resources