Skip to main content

General Q&A

Can't find what you're looking for? Ask it here!

  • 1,169 Topics
  • 2,528 Replies
1169 Topics
ayush.gupta11
Level 2
ayush.gupta11Level 2
asked in General Q&A
Getting Error while trying use domain table function for two different tables

HI Team,I have One table which has Vehicle ID and other Table which has PartDetails. I want to count claim number from this but both columns are coming from different tables. When I tried using this with DOMAIN TABLE it is giving me following error message:-Pull-Up-function could not be executed. PU_COUNT_DISTINCT: Cannot execute PU-function on tables [<DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )>] and ["o_custom_Claim"], since they do not have a 1:N relationship. You might want to make use of the BIND function. Join path: [DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )]1 --> N[o_custom_ClaimLineDetails]N <-- 1[o_custom_ClaimLines]N <-- 1[o_custom_Claim]. For more information on the join path, search for "Join functionality" in PQL documentation.Can anyone assist?

02
ayush.gupta11
Level 2
mateusz.skurz
Level 2
mateusz.skurzLevel 2
asked in General Q&A
How to open a filter bar from the view that was opened in overlay?

Hi all,In my View analysis I added the filters into the ‘Show Filter Bar’ that resided on the right side of the view. However, once the same view is opened in overlay, the ‘Show Filter Bar’ is not visible - hence I have no access to the filters.  Is there a way to include a Filter Bar into a view opened in overlay? Thanks and kind regards,Mateusz

31
abhishek.chatu14
Level 7
douglas.souza
Level 2
douglas.souzaLevel 2
asked in General Q&A
Action Flow partial result http

Hello celonauts, I have a question. I'm creating an action flow that will access an API, but it needs to generate a token and then go to access. In the first step, I generate my token, but it comes composed. I would like to get only the part that brings the token: Example{"token_type":"Bearer","expires_in":3599,"ext_expires_in":3599,"access_token": "value-token"}.I need to get only the "value-token" part after the "access_token":Is there any way I can do a spit or something like that? I don't know how to get out the other side.  

02
douglas.souza
Level 2
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Q&A
How to write pql for this tables.

Hi Team, I am trying to create a column chart where I am using  2 tables custody and activity_table .However I am end up with no common table error. The joining in the datamodel as follows:custody(N) ← MCA_CA_ID_NEW(1) → Line_table(N) ← Head_table(1) → Activity_table(N).How I can write the pql statement for this .  

30
kandi.naidu
Level 4
utkarsh.rasto11
Level 2
utkarsh.rasto11Level 2
asked in General Q&A
How to create OLAP Tables with sub-categories?

As evident from the above image, there are further sub categories in the metrics column. Can we create an OLAP table in similar fashion? 

141
abhishek.chatu14
Level 7
Mst11
Level 2
Mst11Level 2
asked in General Q&A
Changing the color of the textbox

Hi, in the legacy view there was possible to change background color of textbox, buttons etc. but I cannot find a way how to do it within the new views. I tried to do it through the YAML but it’s not working. So if someone has an idea it would be awesome!

151
abhishek.chatu14
Level 7
milan.eric
Level 3
milan.ericLevel 3
asked in General Q&A
ActionFlow: Update Augmented Attribute

Hello, I am trying to create an ActionFlow for updating augmented attributes but its keeps giving me errors. The operation failed with an error. 400: Failed to update augmented attribute. Failed to query engine to map identifier from one value to separated columns. Unknown query engine failure I created an augmented attrobute in legacy views with a unique identifier. Now in the ActionFlow I do all my selections with the correct identifier:   And I get the correct result in the input: But it doesnt update the augmented attribute due to the error: As you can see the identifier is the same. What am I doing wrong here?

361
yevhen.riabt12
Level 2
lpk2005
Level 2
lpk2005Level 2
asked in General Q&A
Request for Retake or Reduced Blocking Period for Celonis Assessment

I recently attempted the Celonis assessment but have exceeded the allowed attempts, resulting in a six-month block. I understand the policy, but I am eager to improve my skills and demonstrate my understanding of Celonis. I have been actively studying through the Celonis Academy and other resources. If there is any possibility of reconsideration for an additional attempt or reducing the blocking period, I would be extremely grateful. Please let me know if there is a way to review my case.

30
lpk2005
Level 2
bunyod.sap
Level 4
bunyod.sapLevel 4
asked in General Q&A
Dropdown Filter in New Views

Dear all, I have in one view two OLAP tables(with complex calculations and predefined conditions) for which I want to create independent dropdown filters. The reason for that is that one should be filtered based on date type “received entries” and the other one based on date type “processed entries”. I was wondering if you maybe came across such an issue or if you have maybe some tips & tricks or solution for me? In advance thanks for your help. Best, Bunyod

274
bunyod.sap
Level 4
wojciech.brol
Level 2
wojciech.brolLevel 2
asked in General Q&A
How to use Action Flow to convert a CSV file to XLSX?

Hi,I'm trying to create an Action Flow that allows me to convert a CSV file to XLSX and then send it via email.Current Flow:The user enters their email in the application view and clicks the "Send Email" button.A webhook retrieves the data. We then use Celonis Get Rows to fetch data for a specific Account ID (one Account ID may have more than one document).   The data from Get Rows is added to a CSV file.Expected Solution:Instead of saving the data to CSV, I would like to:Aggregate the data differently, e.g., fetch it from another HTTP output or webhook. Use ML Workbench in Celonis to convert the JSON format to XLSX. Then send the XLSX file back to Action Flow to attach it to the email.Question:Is it possible to implement such a solution? Or is there a simpler way to generate an XLSX file as an output?

683
wojciech.brol
Level 2
D
Level 3
deepti.gandhLevel 3
asked in General Q&A
Excel file with Activity definitions and the conditions

Hi, Came across the below slide in Partner asset library but couldn't find any file in the below format. Can you please let us know where to find activity definitions for a particular process along with the conditions used. Thanks.Regards,Deepti

75
Adam Smith
Level 2
K
Level 1
kartic.rawatLevel 1
asked in General Q&A
Hi, I am not able to finish the Exercise - Push Flat Data via ML Workbench and Exercise - Push Nested Data via AWS CLI as in both the cases even though I am doing all the steps correctly still it is giving me S3 file upload error.

Hi, I am not able to finish the Exercise - Push Flat Data via ML Workbench and Exercise - Push Nested Data via AWS CLI as in both the cases even though I am doing all the steps correctly still it is giving me S3 file upload error.

92
chijioke.okonk
Level 2
s.a14
Level 3
s.a14Level 3
asked in General Q&A
Account Hierarchy

Hi, Is there a way to arrive at hierarchy of accounts as shown below using SQL (or) PQL?I need to identify the first sold to account (ZSLD) for partner 2 using Table1 and Table2Example  

20
s.a14
Level 3
bas.matsu
Level 2
bas.matsuLevel 2
asked in General Q&A
Extract Filtered Data from Analysis Process Explorer to Machine Learning Workbench

Dear Celopeers, Currently I am trying to extend the simulation capacity of Celonis in the Machine Learning workbench. To do so, I need to import an event log through, I think, PyCelonis. I would like to use the UI of the Process Explorer in a premade analysis of Studio to define the activities and connections that are imported.The following link suggests this used to be possible within PyCelonis 1.7 using the ‘Share your selection’ URL. (Analysis: Pull data - PyCelonis) This appears like a very elegant and user friendly solution to me.However, I can't figure out how to do so using the newer PyCelonis 2.12. I did find out how to navigate to the correct space, package, and analysis through different IDs. But the Python methods attached to the analysis object created through .get_analysis() do not make apparent how to perform the filtered data extraction I alluded to above.Any ideas or references on how to do this? Thank you in advance, Bas

121
matt.witty13
Level 5
nitish.kumar23
Level 2
nitish.kumar23Level 2
asked in General Q&A
open order app

Any work on open order app in OCPM?

10
nitish.kumar23
Level 2
andres.naran12
Level 4
andres.naran12Level 4
asked in General Q&A
How to get component values from a view with PyCelonis

Hi everyone I have a challenge that I’m trying to figure out related to pycelonis.I’m currently trying to get the component values from a view using pycelonis. Unfortunately, I couldn’t find any information inside the documentation that can help me with this.It seems that the documentation only explains how to work with analysis or knowledge models. Does anyone know how to work with components of a view inside pycelonis?Best wishes!

3716
matt.witty13
Level 5
Akshay Haridas
Level 3
Akshay HaridasLevel 3
asked in General Q&A
Analysis date dropdown sorting

Hi All,I have created one column Month_Year in one of my tables which I am using for creating the analysis dashboard. The Month_Year column is of type Varchar and so when I am creating a drop-down component in the analysis rather than getting the Month_Year column in date order I am getting it in alphabetical order. Sure I know there would be answers to this query saying to change the datatype to date and then do the to_date function in the front end but in that scenario, I am getting unwanted things like day, time, hour, seconds and all. I only want the month and year to be displayed in the dropdown and that to in date order. Can anyone please help me on this query

202
Akshay Haridas
Level 3
ArthurS
Level 2
ArthurS
asked in General Q&A
Question About Partnership Opportunities

Hello,I’m an independent consultant specializing in process optimization and based in the Netherlands. I often help clients adopt and integrate new tools to improve efficiency and am very interested in Celonis.I’m curious if there are opportunities for independent consultants like me to partner with Celonis. Specifically, I’d like to know if the partner program supports using the platform with clients and possibly providing training on the software.Could someone provide more details about the possibilities and requirements for such a collaboration?Thanks in advance!

100
ArthurS
Level 2
eby.t12
Level 2
eby.t12Level 2
asked in General Q&A
OCPM for a Website Journey

I’m trying to build a Website journey with OCPM. I expect to have various objects like Web Object, Order Object, etc in the flow. Considering just the Website frontend, in case centric approach, to show the traversal throught the various webpages, I could imagine having the webpages as the activity, however when moving to OCPM, I’m wondering how the scenario should be modeled. Since (I assume) the webpage traversal would be events affecting the Web Object itself and there is a possibility that there is far too many webpages to manually keep adding to events, is there a better way of building this journey with OCPM?

80
eby.t12
Level 2
C
Level 2
carlos.meizo12Level 2
asked in General Q&A
Has anyone implemented JD Edwards P2P connector? I need to understand how it works and recomendations coming from real project experience.

Has anyone implemented JD Edwards P2P connector? I need to understand how it works and recomendations coming from real project experience.

105
denis.pede12
Level 2
amy.marti
Level 2
amy.marti
asked in General Q&A
Adding a total line to a table

I’m trying to add a total line to a table in Celonis, similar to a total line in an Excel pivot table. In my table, my first column is a dimension and the rest are aggregated KPIs. But my end user needs to see the overall total, too. Any thoughts?

261
muthappan.alaga
Level 4
sivasakthi.dhand
Level 3
sivasakthi.dhandLevel 3
asked in General Q&A
Filter using parameter in view not working in object centric data model table.

I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'

61
sivasakthi.dhand
Level 3
michael.kaemp
Level 3
michael.kaempLevel 3
asked in General Q&A
assign date value from an augmented attribute to a variable and use it

Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute  - id: CM_MONTHS    identifier:      id: id      displayName: Id      pql: '"CM_MONTHS"."MONTH"'    attributes: []    newAttributes: []    augmentedAttributes:      - id: late_creation_deadline_date        displayName: "Late Creation: deadline date"        possibleValues: []        columnType: DATE        format: "%Y-%m-%d"        housekeeping: false        type: AUGMENTED_ATTRIBUTE    flags: []    priorities: []    triggers: []    businessRules: []    type: RECORD    origin: PACKAGE The component to update the augmented attribute  type: table  settings:    data:      columns:        - id: 3486adcd-a996-49a5-97e0-af17da07e9af          field: CM_MONTHS.MONTH          order: 100        - id: 10c08937-649f-48a0-88fe-929d3107e824          field: CM_MONTHS.AUGMENTED_late_creation_dead

120
michael.kaemp
Level 3
sagar.belur
Level 2
sagar.belurLevel 2
posted in General Q&A
Calculate a KPI without affected by change in Dimension

Hi,I am working on a KPI (A), which is calculated based on the result from another KPI (B) but this KPI (B) should not affected by Dimension selections. Do you know if this is possible? Thanks

141
mathijs.lende12
Level 2
leon.boere
Level 2
leon.boere
asked in General Q&A
How to Exclude NULL Values in a CASE WHEN Statement in PQL?

Hi All,When using a case when statement how would I go about excluding all the values which are not true from the result.Lets say:CASE WHEN PROCESS EQUELS 'A' -> 'B'THEN 'A to B'WHEN PROCESS EQUELS 'C' -> 'D'THEN 'C to D'Now I'm only interested in plotting the values fall in the 'buckets' basically. How do I exclude the rest which are NULL (very large number of cases).

210
leon.boere
Level 2

Badge winners

Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2024