Skip to main content

Solved

360 Topics
G
Level 2
georg.sondeLevel 2
asked in Celonis Free Plan
First day of a month - thee month ago

In my analysis filter I need a range over three month exactly.With this formular I get the last day of the preceding month:ADD_DAYS(ROUND_MONTH(TODAY()), -1) Today: 07.06.2021 Result: 31.05.2021This is the secound part of the BETWEEN order.Now I'm searching for the first formular in the BETWEEN ordersImilar to VBA: DateSerial(YEAR(Date()),MONTH(Date())-3,1)Is there a chance? 

41
G
Level 2
M
Level 2
mel.schic11Level 2
asked in Data Ingestion & Infrastructure
I would like to count how often a Sales Order (Header) goes out of a credit block. The issue is while this activity happens at the header level, I only manage to get my KPI at the item level. Which means that it is multiplied by the number of lines.

So, I tried to solve it with a pull-up function. PU_COUNT("VBAK", "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN", "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Credit Approval Release') )   But the results do not seem correct to me:I do not think this offers a distinct valuewhen putting the KPI in an OLAP against the customer, I get duplicates for the customer. Another option that I could think of, made use of match_activity. However, this is then still at line item level.

66
M
Level 2
thorsten.schne
Level 3
thorsten.schneLevel 3
asked in General Product Q&A
KPI - Variable - Limit Characters of Expression

Hi everyone, I created a Chart and face the problem that the expression of the KPI does not fit into the tooltip.   Option 1: Is there a setting to change the size of the tooltip box? Option 2: Alternatively I wanted to limit the characters of the variables. Could you help me to insert a LEFT or RIGHT statement? My syntax does not work. <%= MyVariable %> --> Full text is shown<%= LEFT(MyVariable,10) %> --> Only show the left 10 characters

03
A
thorsten.schne
Level 3
thorsten.schneLevel 3
asked in General Product Q&A
Syntax - Replace "FIRST_OCCURRENCE" with a variable

Hi community,  I created a dashboard and would like to use a variable so that the end-user can easily switch between first-to-first // first-to-last occurrences. Could you help me with getting the syntax right. Thank you!

71
A
M
Level 2
mel.schic11Level 2
asked in Data Ingestion & Infrastructure
Aggregation to two dimensions

Hi,I am looking for a PQL code to solve the following.We have data for multiple dimension over a period of time. I would like to get the data aggregated on one dimension per month.All the data is within one table.|Dim1|Dim2|Dim3| Month | KPI ||----|-----|-----|------|---|| A    | X1   | Y1   | Jan-21 | 300 || A    | X2   | Y2   | Jan-21 | 200 || A    | X3   | Y3   | Jan-21 | 400 || A    | X1   | Y1   | Feb-21 | 200 || A    | X2   | Y2   | Feb-21 | 100 || A    | X3   | Y3   | Feb-21 | 500 || B    | X1   | Y1   | Jan-21 | 300 || B    | X2   | Y2   | Jan-21 | 200 || B    | X3   | Y3   | Jan-21 | 400 || B    | X1   | Y1   | Feb-21 | 200 || B    | X2   | Y2   | Feb-21 | 300 || B    | X3   | Y3   | Feb-21 | 500 | What I would like to get is.jan-21feb-21diff.A900800-100B900100200 I have been trying with the domain table and PU functions but I was not able to make it work.Thank you

42
W
Level 1
.
Level 2
.14600921Level 2
asked in Process Analysis
Jumping to SAP sales order from Celonis

Dear All, I remember linking SAP CRM URL to Celonis so from detailed Tab, I can jump to the transaction in URL. I dont find the steps to do that. Can someone help here? Thanks

71
M
Level 1
salma.zeped
Level 4
salma.zepedLevel 4
asked in General Product Q&A
How to manage standardization and quality control when you support the self-service approach for users to create their own analyses? Besides, offering established templates for it.

After viewing the "Thought Leader Panel: Managing Real Organizational Change: The New Center of Excellence on CoE" I wonder: How to manage standardization and quality control when you support the self-service approach for users to create their own analyses? Besides, offering established templates for it.

11
L
Level 1
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Product Q&A
Celonis Community Archive available?

Today I noticed we moved from the Celonis Community to CeloPeers.com. This needs some getting used to of course. My main question however is if the Celonis Community will be available for archive purposes (e.g. read only), as I found it a valuable resources and it will take time before Celopeers will be at the same level.

11
EBrozio
Level 2
.
Level 3
.14600835Level 3
asked in Process Analysis
Index sheets - Front end

Hello All, Anyone knows how to use and what is the benefits of using index sheets on front end analysis? I tried using and seems its scanning open requests but not sure how is it working? Thanks, Kalpesh

13
M
Level 1
thomas.keim
Level 4
thomas.keimLevel 4
asked in Data Ingestion & Infrastructure
PU_COUNT_DISTINCT - No Common parent between tables could be found

Hello,Im looking for an solution for this challenge:We have 3 SAP ERP TablesVTTK (Shipments)VTTP (Shipment Items)LIKP (Deliveries)LIPS (Delivery Items)VTTK is linked 1:N with VTTPVTTP is linked 1:1 with LIKPLIKP is linked 1:N with LIPSI want to count the distinct material numbers per shipment.Count per delivery works fine: PU_COUNT_DISTINCT(LIKP, "LIPS"."MATNR")But I need it per shipment for further calculating KPIs, like this:PU_COUNT_DISTINCT(VTTK, "LIPS"."MATNR")Here I get the following error:No common parent between tables could be found - Please check your schema. The tables VTTK und LIPS do not have a common parent in the schemaWithin the help I found the BIND function. I tought, this can be the solution:PU_COUNT_DISTINCT(VTTK, BIND(LIKP, "LIPS"."MATNR"))But here I get an error in the formula.How can I solve this with a formula und without changing the data schema.Thanks for you helpThomas

127
D
Level 2

Badge Winners

  • Qualified to Prove Celonis Value
    Gero Busatishas earned the badge Qualified to Prove Celonis Value
  • Qualified to Manage Change and Scale Adoption
    tim.winklerhas earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Identify and Drive Opportunities
    Gero Busatishas earned the badge Qualified to Identify and Drive Opportunities
  • Qualified to Build Action Flows
    rajarshi.chauh11has earned the badge Qualified to Build Action Flows
  • First Post
    Chethan Shettyhas earned the badge First Post
VIEW ALL
Community Code of Conduct