General Product Q&A

For exmaple: There is a dropdown selection which includes different vendors. I want to create an column chart of the first 5 vendors if no selection of a specific vendor is used. On the other hand if a vendor is selected in a dropdown menu i want to display only that vendor in the said column chart.  Thank you!

So, I'm trying to implement a filter that changes depending on the input of the user. A button dropdown was included to collect the input of the user, said button contains three options which change the value of a dynamic variable, the possible values for this variable are 0, 1 and 2. Lastly, I wish to filter a component depending on the value of said variable. I tried implementing a load script as follows: FILTER DATEDIFF(mm, VBAK.ERDAT, VBAK.MBDAT) CASE WHEN <%=variable%> = 1 THEN >60 WHEN <%=variable%> = 2 THEN <=60 ELSE ENDThis solution does not work. Any help?

Hi, does anyone know the table requirements for an O2C process in TradeCloud? Thank you.

Hello - is anyone aware of a glossary of key terms that Celonis has published? Something that we can share with people who are new to the technology.

I would like to dynamically change the value of Load Script (Analysis settings) using variables. Switching the filter on/off according to one's choice. But, i am not able to achieve it. According to the documentation, variables are not accessible in Load Script. Can anyone suggest how to achieve this.? https://docs.celonis.com/en/load-scripts.html

Dear Sir/Madam, Currently, I'm using the trial account of Celonis Process Mining and Celonis Task Mining. And I'm installing "Celonis Task Mining" and "Celonis Task Mining - Configuration Editor" on my laptop also. I have some questions:s How I can check the information on my trial license? And how long can I use this software on my laptop? Thanks so much.

Our approach was to link BSEG to the VBRK table in the data model through MANDT and VBELN, but we are unsure about this being the best practice. Any recommendations?

Is it possible to trigger an Action Flow as soon as a data model has finished loading? If not is this feature planned because this would be helpful for a lot of use cases.

I wanted to get the extraction logs (like date, info, message). And I wanted to get this data through an API (Pycelonis) so I can post it elsewhere.

I want to create an OLAP Table or a histogram that shows on the distribution Axis/column the case count per linked attribute and on the Occurence Axis/KPI column the number of distinct attributes that are linked to that specific case count. See the attached OLAP Table as example:I want to create a new table that shows in a first column the second column of the attached OLAP Table. In a second column the new OLAP Table should show the occurences of each distinct number of column two from the attached OLAP table. I indicated with the red numbers on the right the occurence count i expect to be seen in the new OLAP Table (in the new OLAP Table the number 11,040 would only be displayed once in the first column and in the second column would be a 2 because two different vendors are linked to that specific case count).  Can you help me? Thanks in advance.

how to password reset

Is there any online training content available on SAP tables? Please recommend a good online course.

Eg: for a column "NAME" one of the value is "HELLO-WELCOMETO-CELONIS" I want this to be split to 3 columns..Intro: HELLOGreeting: WELCOMETOTool: CELONIS​As 3 different columnsCHARINDEX giving error that this function does not support. ​

I have a violation raised in the conformance overview while the violation raised is normally mapped in the process model should not be raised in the process overview. How can I solve this issue ?

Observations:Same sheet takes different time to load for different peopleSame sheet takes different time to load for the same person at different time of the dayInitial hits to the sheet take longer time to load and subsequent hits to the same sheet load faster

Hi,  is it possible ot replace empty cells with dashes (-) in a csv file generated from an Action Flow which is based on Celonis Data? I found a template for Action Flows to generate and csv File with a appropriate format (see below). Unfortunately my data from celonis contains empty values, which bothers me in the csv since they appear empty. I would like to replace them with dashes(-).  Thank you for your help and best regards,Jurgen 

How much time does it take to the support team to change the email account?

Is it possible to capture at what time the delta load started or ends in a table? If yes please help with the approach

I failed to clear certification exam two times of "create and deliver value" in value assessment will I get more chance ?

I already setup the identifier in the record on the KM, the profile view too and the link from the table to the profile view is working. But the details on the profile do not correspond to the one I choose Table:settings:  data:    columns:      - field: WF_CASOS.CASE_KEY        id: 5e4d0cde-30b1-484c-8e99-71ce53dab11a        order: 100        onClick:          linkToRecordProfile: true          showInModal: true          openView:            carryFilters: true            carrySelections: true            openInSideOverlay: true            profileView: true            viewKey: detail-dollaridProfile viewmetadata:  key: detail-dollarid  template: false  name: Detail ${id}  knowledgeModelKey: ots-criticas  knowledgeObjectId: WF_CASOS  profileView: truevariables:  - id: fd1cc79c-005f-4ec9-b831-97fbf28f301e    name: id 

Hi I am unable to login to Celonis cloud. The landing page says "We're sorry but your activation link is invalid". I want to complete the training by practising in demo environment. Please help.

For each Billing Date, I am attempting to count the number of Communications received on that same date even though not all Communications received belong to a document Billed on that date. The issue I am encountering is that only those Communications received on the Billing date are included in the numerator of the ratio. The billing document serves as my case key.

Hi all. Is there a problem with the file uploads? We had some data pools with files uploaded but they are not there anymore. Is anyone experiencing the same? Many thanks.

Hello, I small encountered a problem when I wanted to create a simple column chart with a trendline in an Analysis. I created a dimension with ROUND_WEEK(), a KPI with case count and a KPI with a MOVING_AVG for a count trendline of the last five weeks. Now, I only want to show the last six weeks using the limit rows / max. elements fields. When I do this and sort by the week dimension the most recent week is on the left, not on the right as it's usually common practice. Changing the ordering results in showing the first week in the data set, not the most recent ones. Then I tried to use a filter to only show the last weeks but then the MOVING_AVG calculation is wrong since previous weeks get filtered out.  Maybe someone can give me a hint :) Thank you

Hi,I'm building an AF that sends via email some pdf report and some csv from an analysis.The thing is that I need to set different filters for the same pdf report or the same table exported in csv. At the moment I have as many modules as are the objects that I need, for example, 4 Create PDF Report modules that print the page with different filters, generating 4 different PDF objects; same for the csv file, I query the data 4 times and generate 4 different csv files for the same table, but with different filters. The AF is working fine, but it's extremely long and it generates A LOT of objects that I need to send via email. I'd like to make it smarter by, if possible, aggregating the PDF sheets into one single file, as well as the csv tables into one file, creating multiple sheets in the csv. Best case scenario would be one PDF file generated by one module in the AF and one csv file, generated by one query data and one create CSV module. Thanks!