Product Q&A

Hello, I use my formula (CASEWHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%'   THEN 'South Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-A%'   THEN 'Saxony-Anhalt'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-W%'   THEN 'West Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-B%'   THEN 'Brandenburg'ELSE ' ' END) to cluster values. Works great, except that it always gives me the ELSE values as 0 in my graph. 0 means that there is actually no ELSE, or in other words, everything is clustered. How can I hide the 0 in the formula or in the component filter?  thx :-)

Hey Peeps,  can someone help me. I try to connect, the correct PO to the corresponding SO in the IM Datamodel.See picture below.  I tried the BIND() and several PU functions.  Would be great if someone could help.  Thank you.  Daniel

Hello, I would like to count how many items have a crossing time under 1 day from activity1 and activity2. To calculate the crossing time, I used this formulated that I recorded in saved formulas: CALC_THROUGHPUT(FIRST_OCCURRENCE[<%=From%>] TO FIRST_OCCURRENCE[<%=To%>], REMAP_TIMESTAMPS("_CEL_P2P_ACTIVITIES".EVENTTIME, <%=unit%>)) Then I tried to write the following formula to do the count but it gives me an error: COUNT(CASE WHEN KPI(TEMPO DI ATTRAVERSAMENTO) =< 1 THEN 1 ELSE 0 END) Is there another solution? Thanks

Hi @all, I have cases like this A-B-C-A-B-C or A-B-A-C-B-C like a loop with 3 activities, I want calculate between A and C activities. Also I have activity attribute for example first A-B-C activities have "ORDER" column value "1" and second A-B-C loop have "2". How can I calculate this situation?Thanks, Selim

I have tables A, B, C, D, E which are connected as on attached scheme. I want to create an OLAP table which shows A, C and E data. I already have one OLAP with A + C and second with C + E but when I try to have A + C + E I get an error message. It is possible to join these tables?

Hello, could someone tell me where can I find the Celonis Process Repository?

===============================Usability of MarketPlace Connectors in "REALITY"================================= Hi Team,I have started my market place journey by installing SAP "Order to Cash" Connector. Below was my experience :1)I tried to install the app in studio but it gave multiple errors for the Data Model.2)I looked at the data model and tried understanding it. -There are no documents to understand why that data model is build in the way it is.3)I looked at standard SAP tables and tried to understand it by looking into transformation.4)Transformation does have big quereis and most of the places there is no explanation of what does those quereis mean.5)I finally reached SAP functional consultant and technical resource to help me understand the quereies.6)Currently i am working with them and reverse engineering to understand what has been provided with connector.7)Parallely i raised a ticket to Celonis support for providing comprehensive documents but they re

In celonis documentation in one place it says to setup extractor server for SAP HANA , and in another place it says to access data using API . So , a bit confused on this . Any help is highly appreciated. RegardsAyan 

How to search for a tag in the new data pool GUI?Since the data pools are presented as a list instead of tiles the functionality to search for a data pool with a specific tag attached seems to be missing. Unfortunately the search bar doesn't take tags into account and even the browser search (Ctrl+F) is useless because Celonis splits up the pool list into several pages. We have a lot of data pools and tags in use and without a filter for a certain tag I have to got through every page manually. Is there still a way to filter data pools on base of their tags? br Florian

Is there a standard in Celonis for stock transport orders with delivery in SAP?

Is there an easy way to move everything I have from a server to another? I.E., I'm going from eu3 to us1 and I'd like to duplicate all my analysis and workspaces in Studio

Sometimes this options shows up and sometimes it doesn't. Should it be manually input in the code?

and always start with User ID. How can I fix it? When I use advanced CSV, it doesnt allow me to name the column. it automatically name as Column1 name, Column2 name etc.Thanks

But, I will have to keep these records once the system is processed and published using OLAP table in the Studio. So, for example the columns might be Record Number and Record Created Date (System processed date). What is the best way to do so?

I'm getting an error when trying to add a table to a data modelThe main problem is: it was working last week and, when I tried to re-run today, I got the following error: HTTPStatusError: Client error '400 Bad Request' for url I dont know what could be triggering it, specially because it was working before and I didn't  

Greetings,is it possible to display custom messages, defined in the python script of the celoxtractor, in the real time log of a extraction (when the extraction gets executed)? We are currently writing debug messages to local logs on the celoxtractor server. Having it directly in Celonis would be a blessing. Best Regards

Hi, I have a python script that retrieves information about knowledge models, variables, and KPIs for documentation purposes. For some reason, the script is errorring out, when trying to retrieve KPIs, whereas previously it worked.  Has anyone got an idea why this is not working now and how I can fix the error? Thank you, Teun

Some of my pages contain (a few) hidden components behind big grey background text boxes. In one case, it had four variant explorers. I'm wondering.Does this reduce the page's speed?Can I check the consumption of a single analysis sheet? Thanks very much in advance for your time 😀

I had this error occurred during data extraction and could not be executed. Does anyone know why?

Anybody has a "strong" definition of what will be a use-case in Celonis? I am thinking on a wording that could be use in proposal. Like when we limit the effort to "3 use cases", add that definition. TIA

I want to calculate start and end week of a particular date where week start date is Monday and end is SundayI’ve tried using ADD_DAYS & DATEADD which is in supported vertica sql functions but getting error that it requires permission

Hi, is there a way to prevent that an Action Engine Signal is resolved by the system automatically, but can only resolved manually by the responsible user?

Hi All, I have created a task component in a view and we have tested it by creating multiple demo tasks. Now, we would like to delete all test tasks we have assigned before we launch the app. Is there a way to do that without creating a whole new record in the KM? Thank you,Kalina

Hi all, In my activity table I have two specific activities named subprocess start and subprocess end. Before, between and after this two activities there are other activities and I need to count how many happened before, during and after the subprocess.Each activitiy has an eventtime, but I'm not able to compare them. Approaches already tried (for now I'm focusing on activities happened BEFORE, since I thought that it would have been easy to add other case when for during and after scenarios afterwards: (CASE WHEN DATEDIFF(ms, "ACTIVITY_TBL"."EVENTTIME", CASE WHEN "ACTIVITY_TBL"."ACTIVITY_NM" = 'subprocess start' THEN "ACTIVITY_TBL"."EVENTTIME" END) > 0THEN '1' ELSE 0 END) (CASE WHEN "ACTIVITY_TBL"."EVENTTIME" < CASE WHEN "ACTIVITY_TBL"."ACTIVITY_NM" = 'subprocess start' THEN "ACTIVITY_TBL"."EVENTTIME" ENDTHEN 1 ELSE 0 END) Both

I would like to know how to retrieve files on the local server using Celonis functionality. For example, I would like to know how it can be realized with the functions provided by Pycelonis and Celoxtractor. Is it possible to get files to Celonis without using Data Transfer API such as HULFT?