General Product Q&A

Hi, I need PQL code for below query. 1) Need Sum total of "BSEG"."WRBTR" column based on a new manually created column having concatenation of "BSEG"."LIFNR" and "BKPF"."XBLNR".

Example in the below picture is one of the scenarios: 1. Invoice is posted in Jan 2023 but paid in May 2023. Hence, the total open invoice amount should be accountable for not only Jan but also for feb, march and april. Unfortunately, I get the Total open invoice amount accounted from the posting month followed by all the rest of the month in the data set.  My current approach:Round(Posting Date) column: RANGE_APPEND(((ROUND_MONTH("O2C_AR_BSEG"."CPUDT"))), '1M')Total RUNNING SUM column: RUNNING_SUM( SUM(  CASE WHEN ROUND_MONTH("O2C_AR_BSEG"."CPUDT") <> ROUND_MONTH("O2C_AR_BSEG"."AUGDT")  THEN  (  CASE WHEN ISNULL("O2C_AR_BSEG"."AUGDT") = 0  AND ROUND_MONTH("O2C_AR_BSEG"."CPUDT") < ROUND_MONTH("O2C_AR_BSEG"."AUGDT")  THEN "O2C_AR_BSEG"."WRBTR_CONVERTED"  END)  END  )) I know that I should set a start and end range to my PQL query: R

In the celonis View do we have any component to create a pivot table similar like in Analysis.Please let me know the steps if there is a possibility in Views(to create pivot table)

I want to create a variable in new view which would add every current year automatically into the table. Please help.

Is a procedure as described in the screenshots possible with extractor builder?

Is there a way to share a link for a view (also package) to a user with access rights, but the link is easier for them to open the dashboard?

Is it possible to connect multiple sources into one process ,with different type of sources (ARIBA +SAP ECC , Success factor + SAP ECC, MS-SQL + SAP ECC) ?

I know it might seem simple question but i am struggling with uploading BPMN file for my conformance sheet. can anybody tell where and how to upload it ?

I would like to have the green start where the blue stop (Stacked graph)- how can I do that? 

I want to know who is my Partner Manager Urgently: Thanks gabriel.cifuentes@cliptecnologia.com

I have add the action send an email for the enhanced view for a table but when i select the button to execute the action it is giving me a pop up. Any way to resolve it

In extraction I want to change data type of a column from text to timestamp. Format of data is 2022-10-27 07:27:19.01 +00:00. Now I want to change it to timestamp and enter format for it in extractions. What format will be accepted there. 

Can i change my name after completing training track and get certificate with the changed name?

Hi Everyone, I'm trying to create a dropdown in legacy views, it should work as filter if I select value from the dropdown and it should update the variables too.

I registered a few days ago for c4c and have not heard anything since. Just to be sure, how long does it normally take until I have been vetted? (I still have enough to do in the Academy but it would be nice to know a timeframe) Thx Mark

 Hello, Actually I have passed 3 out of 4 sections in my first attempt itself but I failed in one section which is Section 2: Process Mining Fundamentals. For this section I failed in my first 2 attempts. So now I want to give it try but I am unable to. So, the instruction say that we have 4 attempts in total. First two and then 2 days cool-off and again last 2 attempts. So now it's been more than 2 days since my last 2 failed attempts but still I haven't got my last 2 attempts, it's saying 0 attempt left.

Hello, Actually I have passed 3 out of 4 sections in my first attempt itself but I failed in one section which is Section 2: Process Mining Fundamentals. For this section I failed in my first 2 attempts. So now I want to give it try but I am unable to. So, the instruction say that we have 4 attempts in total. First two and then 2 days cool-off and again last 2 attempts. So now it's been more than 2 days since my last 2 failed attempts but still I haven't got my last 2 attempts, it's saying 0 attempt left. So please help me with this.

I did not use my attempts but it is showing 0 attempts remaining What should i do?

Hi! i want to integrate a dynamic pareto front to scatter plots in my analysis. I want to integrate the pareto front point as red points into the plot. The optimals could change depending on the actual filters of the dashboard. Do you know how to do this?

Good evening,I have consulted the documentation on OnPremise Celonis Extractor Server (https://docs.celonis.com/en/on-premise-extractors.html), but as far as I can see there is guidance only for SAP and servers with JDBC.I would like to implement Celonis Extractor Server directly on a SQL Server without JDBC endpoints, is this possible?Where can I find a guide or documentation?Thanks

Now i want to have this number for Change Price as a single KPI number, my idea was to use the count table for the kpi and a Component filter with 'FILTER PROCESS EQUALS 'Change Price''. But it shows me a much larger number. Can pls anyone help me. Thanks in advance, king regards Louis

This means I want to calculate the throughput from A OR B OR C OR D to X. Is there any way of doing this?

Hello everyone, I have set up an Action Flow that informs our suppliers regularly and also requires an information import back to us from our supplier. The information flow to the supplier is possible via an Action Flow (Sending of a CSV attachment via Mail). My question is there a possibility for the supplier to send the answer back to Celonis (via a Webook, Web GUI) etc.? I know this is a predestined case for Emporix, however, as this is a very urgent topic, I'm wondering if there are any possibilities with the "normal" Action Flows? Thank you so much! Kind regardsJulia Bauer

we are facing some issue the error like below:Extraction failed. java.util.concurrent.ExecutionException: java.lang.NullPointerException.Please let what does the error mean and how to resolve it  

Saw a similar post from a few years ago but believe my question is slightly different. I want to write PQL that calculates the difference in days between the time stamps of when a "Next Status" was entered. The image is an example of what my raw data looks like and the column in yellow is what the PQL would help calculate.