Product Q&A

I am trying to create the comment table but it's not showing anywhere. I want to use that comment section in my OLAP table to provide access to user to comment on any of the cases please help.

My company is planning to update the codes used in the MARA.MSTAE and MARC.MMSTA fields. What I'm trying to figure out is where these fields are used in formulas and filters. I can look at the data models and see that we only use those tables in three specific data models. The knowledge model in one of those was pretty easy, because it has an internal search function. I tried to use the search bar inside of each package, but that appears to only do a surface level search of column titles and such. My question is this: is there a way to search the filters of each analysis/component and code within OLAP tables without opening/editing each analysis and table individually? To phrase it differently: a code-level search function within a space or analysis?

Filter on the most common variant #3 and #4. Make sure the two variants are superimposed on top of each other. Looking at the Process Start and Process End dotted lines, which of the below statements are accurate? Select TWO options.

I am trying to find a way to modify the following PQL code to change the KPI by the selection of the specific time frame.  KPI("days_considered_for_inv_lt")*MOVING_MAX( PU_SUM(  DOMAIN_TABLE(ROUND_MONTH("o_custom_StockHistoryStorageLocation"."CurrentPeriod")),  FILTER_TO_NULL(COALESCE(   CURRENCY_CONVERT(    "o_custom_StockHistoryStorageLocation"."BaseTotalValuatedStockQuantity"    *     BIND(     "o_custom_MaterialMasterStorage",      PU_LAST("o_celonis_MaterialMasterPlant",     "o_celonis_StockHistory"."UnitPrice"))    ,FROM(     BIND(      "o_custom_MaterialMasterStorage",       PU_LAST("o_celonis_MaterialMasterPlant",      "o_celonis_StockHistory"."BaseCurrency")))    -- ,FROM("o_celonis_MaterialMasterPlant"."BaseCurrency")    ,TO('EUR')    ,PU_MAX(CONSTANT(), "o_celonis_StockHistory"."CurrentPeriod")    ,&

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!

Thanks, Kandi Ajith Naidu.

Hello, has anyone set up a connector to Intaact, Netsuite, or dynamics great plains? Also, does anyone know if Celonis even has connectors for these three ERP's? If you could let me know, and where to find this information, I would greatly appreciate it.

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?

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

Hi, how can I write the value of a KPI into a variable, to use the value in another Views component? Thanks!

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 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. 

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

Navigate between your object-centric data models in separate data pools (Available on request) (2024-06-05) You can now switch between multiple data pools in the Objects and Events UI, rather than entering the UI from the data pool each time. If you've enabled our solution for data segregation for object-centric process mining, where you have an object-centric data model in every data pool, you'll get the new navigation feature. If you haven't, and you're using a single object-centric data model in the OCPM Data Pool, you won't see it. Talk to your Celonis point of contact if you want to use object-centric data models in all your data pools - you can read more about it at Multiple object-centric data models. If you're an admin or analyst in a team with multiple object-centric data models, you can now go to Data > Objects and Events in the Celonis navigation bar and get a list of your data pools to choose from. We'll open the Objects and Events UI for the

Hi, Can anyone help me to calculate time difference between LAST TWO activities in the process where last two activities are not fixed ones. Thanks in advance!

KPI("cancelled_cases")*(KPI("cost_per_transaction"))The Cost per transaction should stay the same figure:Cost per transaction: KPI("total_operating_costs")/Global(KPI("case_count"))So the Case count above must stay the total amount of cases and not reduce if I filter for a shorter time. The Total operating cost is a constant figure.

Do you recommend one in particular? Found issues to integrate? TIA!

Hello everyone, I have an action flow that executes an API request based on the selected data in the frontend. Different users per country should only see data in the frontend and trigger the Action Flow that applies to their country. Is that possible?

Hi folks! Is it possible to create a table in a view that every time a user enters an input in that view, that input can be stored in a variable and this can be used to add new rows to this table inside the view?

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!

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

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 

How to get access to the training environment>

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?

Firstly I wrote the following code: space = celonis.apps.get_spaces().find('Accounts Payable')package = space.get_packages().find('Accounts Payable Starter Kit')analysis = package.get_analyses().find('Process Cockpit Advanced')content = package.get_analysis(analysis.id).get_content()data_model_id = content.data_model_id I got this output from the code above: [2024-06-26 11:01:22,515] INFO: `get_analyses` returns analyses without content. To fetch the content for a specific analysis call`analysis.sync()` or use `package.get_analysis(analysis_id)` And then I run the following codes:  sheets = content.draft.document.componentssheet = sheets.find('Activities') -It worked. components = sheet.componentscomponent = components.find("APTable")Finally, I got this error:---------------------------------------------------------------------------PyCelonisNotFou

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?