General Product Q&A

Hi everyone, I would like to create a chart where I show for each month the number of cases that satisfy some conditions in terms of process activities. Specifically, I need to count the number of cases that every month end with activity A. Therefore, if a case at the end of the May and at the end of June ended with activity A and in July it ends instead with activity B, I want to see it in both the column of May and June but not in the column of July.I tried to combine the TIMELINE_TABLE function with the MATCH_PROCESS function but it only takes into consideration those cases that satisfy the requirement today.Do you think it is possible to get what I need?Thank you in advance for your help!

How to enable "Label: True" in Histogram for New View?

I want to add descriptions to KPIs and predifined filters in my view so that this description is shown when the user hover over. I tried to do so in the KM, but nothing is shown and the components themselves don't have the label or description field. Any idea how to do that?

Hi, Please help.I want the blue bars to be broken up /split up into vendor names, so if there is 2 vendors their order values should add up to the total stacked on each other.id: chart-c1c15300-c92b-4d97-8598-b90b8aa0069dtype: chartsettings:  limit: 20  sortBy:    - id: f8639d07-e8cb-4f72-b6b4-16da36b1d74b      field: KPI_PO_ITEM_THREE_WAY_MATCH_ORDERED_VALUE      direction: DESC      order: 100  visuals:    - id: 3eabb17a-7f5a-43d1-8d50-0d24bfa526e8      mark:        type: bar        bandwidth: 0      order: 100      encodings: {}  encodings:    x:      field: PO_ITEMS.MATERIAL_GROUP_MATERIAL_GROUP_TEXT    y:      field: KPI_PO_ITEM_THREE_WAY_MATCH_ORDERED_VALUE

 Hi, I'm attempting to create a PDF report that includes a time filter, such as a start date and end date. The timestamp column in my data is currently in the format of "Mon Feb 28 2022 11:45:11". The values in the timestamp column are in the format of YYYY-MM-DD HH:MM:SS. I've set up a filter using the following code: FILTER "table"."column" >= TO_DATE({{13.Start_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' )) AND "table"."column" <= TO_DATE({{13.End_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' )); However, I'm still receiving an empty PDF report. Could you please help me identify what I'm doing wrong? Thank you.

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?

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, 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 an

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/XTF5daSXZxn1R

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.

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,

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?

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?

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

I am trying to create the comment table but it's not showing anywhere. I want to use that comment section in my OLAP table to provide access to user to comment on any of the cases please help.

My company is planning to update the codes used in the MARA.MSTAE and MARC.MMSTA fields. What I'm trying to figure out is where these fields are used in formulas and filters. I can look at the data models and see that we only use those tables in three specific data models. The knowledge model in one of those was pretty easy, because it has an internal search function. I tried to use the search bar inside of each package, but that appears to only do a surface level search of column titles and such. My question is this: is there a way to search the filters of each analysis/component and code within OLAP tables without opening/editing each analysis and table individually? To phrase it differently: a code-level search function within a space or analysis?