Skip to main content
Top Header

General Q&A

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

  • 1,202 Topics
  • 2,569 Replies
1202 Topics
.
Level 3
.1683757Level 3
asked in General Q&A
Conformance Checking for P2P is not accepting multiple files

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! 

10
.
Level 3
A
Level 1
amit.mandoLevel 1
asked in General Q&A
Vendor registration for deploying remote technical resources

Vendor registration for deploying remote technical resources

00
abhishek.chatu14
Level 7
.
Level 3
.1683757Level 3
asked in General Q&A
How to Filter POs from a specific date UNTIL TODAY?

Hallo, I am trying to create a predefined view filter to filter POs starting from 01.01.2023 until today, so that users when opening the view get all the data regarding POs from 01.01.2023 until the date they open the view. This is how i did it but it is not working i guess because it sees the date format as String. Any Idea of how can i solve this, will be appreciated! FILTER "EKKO"."AEDAT" BETWEEN '2023-01-01' AND TODAY(); Thank you!

220
rita.kiss12
Level 4
A
Level 3
arturo.orteg11Level 3
asked in General Q&A
I am using an olap table where a record from my dimension dissapears when i use a kpi which is based on a table that does not have this record. Why does this happen? can I make it appear using this kpi?

I am using an olap table where a record from my dimension dissapears when i use a kpi which is based on a table that does not have this record. Why does this happen? can I make it appear using this kpi?

60
A
Level 3
dany.moual11
Level 3
dany.moual11Level 3
asked in General Q&A
Dear Community,Did you ever handle the following delta extraction error message on JDBC: Columns: (SYS_NC00065$, SYS_NC00066$, SYS_NC00067$, SYS_NC00064$) have changed. Table won't be delta loaded. Please perform a full load instead. ?

Dear Community, Did you ever handle the following delta extraction error message on JDBC:  Columns: (SYS_NC00065$, SYS_NC00066$, SYS_NC00067$, SYS_NC00064$) have changed. Table won't be delta loaded. Please perform a full load instead. ? The columnname all include a $-symbol, but I cannot understand whether that is a reason.  I would welcome any helpfull suggestion. Thanks a lot

70
matt.witty13
Level 5
C
Level 3
cristina.oyamaLevel 3
asked in General Q&A
Is there any use case using Service Now connector ? I want to see how Celonis was able to bring value.

Is there any use case using Service Now connector ? I want to see how Celonis was able to bring value.

50
P
Level 2
N
Level 2
neda.petro11Level 2
asked in General Q&A
Banner Notifications shortcoming

Hello All, I have been looking at the banner notifications feature, but it seems that :  no hyperlinks are possible, only URLs as text no formatting of the text is possible via HTML (e.g. bold text, line breaks etc.) Is there any workaround to that so we can publish interactive and visually appealing messages to the users? Thank you!

30
rita.kiss12
Level 4
S
Level 1
shivani.lonis11Level 1
asked in General Q&A
i cannot found fundamental process mining in business analysis what can i do

i cannot found fundamental process mining in business analysis what can i do

00
rita.kiss12
Level 4
J
Level 2
julio.bolan12Level 2
asked in General Q&A
What does the impact mean on the starter kit inefficiencies?

The starter kits usually have a Surface Inefficiencies section where there is a column called ‘impact.’ I would like to better understand the meaning of this column. The example bellow is from the order management starter kit and the tab touchless orders. Thanks,Julio 

30
S
Level 3
A
Level 2
akash.suhag12Level 2
asked in General Q&A
while using replace function in celonis pql getting an error because string contains a comma in the value and replace function is considering it as a parameter in the function. is there a work around for it?

while using replace function in celonis pql getting an error because string contains a comma in the value and replace function is considering it as a parameter in the function. is there a work around for it?

30
K
Level 2
V
Level 3
vinay.sutarLevel 3
asked in General Q&A
i failed rising star technical assessment attempt 2 time but fail both time then after 2 days i came back see there is not refill again then what i should do?

i failed rising star technical assessment attempt 2 time but fail both time then after 2 days i came back see there is not refill again then what i should do?

320
R
Level 2
A
Level 2
ashwin.hosbeLevel 2
asked in General Q&A
SOURCE - TARGET

Hi I am trying to calculate the time elapsed since the occurrence of a particular activity and all subsequent activities in the case.For example, if there are 5 activities in a case, of which the activity 'Lodgement' is the second activity. I would like to calculate the time take between 'Lodgement' and the 3rd activity, 'Lodgement' and the 4th activity and 'Lodgement' and the 5th activity.Note:1.The number of activities per case is not a fixed number.2.The occurrence of 'Lodgement' activity is not fixed in the activity order. Any pointers on how this can be done in PQL is much appreciated.Many ThanksAshwin Hosbett

20
G
Level 3
A
Level 2
ashwin.hosbeLevel 2
asked in General Q&A
SOURCE - TARGET

Hi All,I am trying to find out how long a case officer spent time on a case on a daily basis.For Example - If there are two officers - Alex and Rick, I would like to find out how much time Alex and Rick spent per case every day.Any pointers on how this can be done would be helpful.Many Thanks!RegardsAshwin H

10
A
Level 2
douglas.souza
Level 3
douglas.souzaLevel 3
asked in General Q&A
ORACLE EBS - COLUMNS ERROR FLOAT

HELLO, CAN YOU HELP WITH THIS ERROR: The load failed: Load failed. Error message: Error joining table ["OE_ORDER_LINES_ALL"] with table ["HR_ALL_ORGANIZATION_UNITS"]. The data type [FLOAT] of column ["OE_ORDER_LINES_ALL"."ORG_ID"] does not match the data type [INT] of column ["HR_ALL_ORGANIZATION_UNITS"."ORGANIZATION_ID"]. I HAVE ALREADY PARAMETRIZED THE COLUMNS AS FLOAT IN ALL EXTRACTIONS BUT THEY STILL HAVE AN ERROR

00
douglas.souza
Level 3
P
Level 1
peder.stenbLevel 1
asked in General Q&A
Hello; I get the error message "Extraneous ''' "when I try to write the following PQL-Query in Views.KPI("REPEATED_CASE_COUNT_SELECTED", VARIABLE('Scan Invoice', 'Send PO Auto (Jaggaer)'))Does anyone recognize what the problem is here?

Hello; I get the error message "Extraneous ''' "when I try to write the following PQL-Query in Views. KPI("REPEATED_CASE_COUNT_SELECTED", VARIABLE('Scan Invoice', 'Send PO Auto (Jaggaer)')) Does anyone recognize what the problem is here?

100
P
Level 1
U
Level 3
ugandhar.konapLevel 3
asked in General Q&A
Hi Celopeers, How to apply saved filter(i.e., saved in KM) for a component in Views..?(getting error while applying the saved filters)

In analysis we can use component filter to filter by using saved formulas whereas in Views able to filter only by selecting attributes but not saved formulas. Even I have created filter in KM and published & tried using that filter for a component in Views getting error like PQL ErrorA PQL error is preventing this query from executing.KPI with name "Case_type_new" could not be found.

170
abhishek.chatu14
Level 7
A
Level 1
ana.alves14Level 1
asked in General Q&A
If I change all filters in the Replication Cockpit Configuration to: "directly delete data from the data Pool table", would all dashboards be affected? or would it only be possible for certain dashboards?

if so, do I need to make this change in all Filters?  Thank you BRAna

00
abhishek.chatu14
Level 7
P
Level 3
pruthvin.v11Level 3
asked in General Q&A
I'm getting "undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found." Error in the Procurement Starter KitI have added INEFFECIENCIES as well kin

I'm getting "undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found." Error in the Procurement Starter Kit I have added INEFFECIENCIES as well kindly help

260
P
Level 3
andrej.barto
Level 3
andrej.bartoLevel 3
asked in General Q&A
Is it possible to update package dependencies automatically (via pycelonis, action flows...)? My base knowledge model is extended in multiple different packages and I would like to automatically update all extension KMs.

Is it possible to update package dependencies automatically (via pycelonis, action flows...)? My base knowledge model is extended in multiple different packages and I would like to automatically update all extension KMs.

100
Lovise Hellner
Level 4
angelika.kleme
Level 1
angelika.klemeLevel 1
asked in General Q&A
Hi, I am working with Views and trying to create two process explorers within one page and, to make benchmark possible, I need independent filter dropdowns.

Is there any way to somehow connect one filter with one specific process explorer instead of filtering both simultaneously?Was trying with the YAML editor, but with no success.

100
A
Level 1
B
Level 3
bhupendra.singh.thakuLevel 3
asked in General Q&A
Why i am getting error : Table with name INEFFICIENCIES cannot be found?

System: SAP S4/HANAApp Name: Accounts receivable Starter Kit Section : Value Discovery App  undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES cannot be found.

100
P
Level 3
T
Level 1
taira.itoLevel 1
asked in General Q&A
How can I extract the 10 most recent records based on the timestamp for each Innercode in　the table?

Hello. I work as a data analyst in a logistics warehouse, and I am totally new to Celonis and not very experienced in SQL servers either, but I was given the seat, since former analyst has retired.My task is to create a Item-weight master that daily updates unit weight , with average of unit weight calculated from 10 most recent weighted record. Since there are no RANK or TOP functions in Celonis, I am confused how can this be done.Can anyone tell me how is it possible to be done on celonis?  Thank you.

20
R
Level 1
milan.eric
Level 3
milan.ericLevel 3
asked in General Q&A
How to use the D3 Formatting to align a single column?

Hey, I cant really find a lot of information about how to use the D3 Format for columns.How do I align a single column to the center here?It says to use "^" but I cant implement it. Thanks!

70
P
Level 1
A
Level 4
akshay.haridLevel 4
asked in General Q&A
How can we extract data related to Action Flows using python.

Hi All, I would like to know if anyone has any idea on how we can extract data of Action Flows into machine learning workbench using python.(NB: I am using pycelonis version 1.7.2)

70
matt.witty13
Level 5
apurva.patha12
Level 3
apurva.patha12Level 3
asked in General Q&A
How to limit the filter for the one table only in new view?

How to limit the filter for the one table only in new view?

110
apurva.patha12
Level 3

Badge winners

  • Qualified to Get Data Into Celonis
    Tom Haringhas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Deliver Business Value with Celonis
    lasse.muellhas earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Certified Data Analyst
    akash.akash13has earned the badge Celonis Certified Data Analyst
  • Celonis Certified Data Analyst
    saimanohar.kosur12has earned the badge Celonis Certified Data Analyst
  • Celonis Certified Data Analyst
    benedikt.stenghas earned the badge Celonis Certified Data Analyst
VIEW ALL
Community Code of Conduct