Product Q&A

"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" --> this gives me all the timestamps"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" LIKE {t '00:00:00'} --> things like this do not work Thanks a lot! Greetings, Ronja 

I have a delta load schedule applied for every hour and every day and I have implemented a action engine skill with Machine learning bench for Duplicate checker on some source tables . But for the 28th Jan , I have some records but they haven't ran on 28th delta load schedule as well as on 29th . But they ran on 30th delta load and a signal is created on 30th . Now I need help on why that 28th data haven't loaded on 28th and 29th but on 30th ?

Studio Views are very powerful with data and actions but, by default, they are not aesthetically appealing like Process Analitycs. For example I dont find this functions: change colors or backgroud colors (and transparency).change borders and borders type.use KPI dedicated components like Gauge tool menu to guide inside big applicationsIntegration with third parts javascripts components....and so onIs there a way to do this things?Thank for every suggestion. 

Do we have any Cloud extractor to connect to SAP HANA neo cloud database?

I was looking for all possible process connectors on Celonis but could only find a few. Celonis claims they have over 100 process connectors, so I was hoping to know which process connectors are available.

Hey,I want to measure the lead time between two activities, but which must contain a certain (variable) attribute. I tried this with the function "BIND_FILTERS" but fail. Does anyone have a solution for something like this? MEDIAN (  CALC_THROUGHPUT (    FIRST_OCCURRENCE [ '<%= Step_1 %>' ]    TO    FIRST_OCCURRENCE [ '<%= Step_2 %>' ] ,    REMAP_TIMESTAMPS ( "_CEL_SCHUTZBRIEF_ACTIVITIES"."EVENTTIME" , MINUTES )  ),  BIND_FILTERS ( "_CEL_cc_claim","ANS_KNZ_Mapping_csv"."ANS" = '<%= ANS_01 %>' ))

i am using pycelonis in jupyter notebook to get list of spaces, list of packages and its analysis. I am able to get list of spaces, but list of packages is not possible, also space.packages.find is not pulling one of my package key. If i can get the documentation to find list of packages and analysis that will help. ThanksMuthappan

I am setting up Task Mining and want to see what is being saved prior to uploading. It is currently being saved as a parquet file but I cannot install a parquet viewer on the machine due to security restrictions. Is it possible to save the files as a different file type that I can view in plain text?

Hi everyone! When I using format values using "Abbreviated format" is showing different way. Some users see correctly with "M", "B", "K". But some users see like "millions", "billions", etc. Did you guys facing that problem? I need to all user could see the Abbreviated format correctly, like "M", "B", "K".

I've uploaded all the tables that the ABAP reports generated, but now I need to use that tables to create the Data Model and hence be able to use the O2C apps. After installing the O2C app, it gives error as it cannot find the Activity Table. How can I create it? I thought this was automatically performed once the CSV files are loaded. Am I missing something?

Hello everyone! I would want to use the "Proxima Nova" font not only for Latin but also for Cyrillic. Is it possible to do it somehow?

Hi everyone,I'm new on this topic, therefore possibly a not so solid question. ;-)Can it be a problem with permissions or did I miss a point? I have downloaded and installed the data consumption/pipeline monitor from the EMS store.APC calculation has taken place after serveral daysI followed the instructions in the help center (activating monitoring, looking at problems with bug)activated "Eventlog automerge" in all three data models / also tried without activated automergeData jobs for Data Consumption Monitoring & Data Pipeline Monitoring (Transformation/Data Load) successful executed (= green)Data model was loaded according to log Thanks in advanceJens

For Oracle EBS, AR, there is no data in AR_DISPUTE_HISTORY (0 rows). Hence when running the transformation, it is giving the following error. How to resolve the same ? Error while executing transformation Create View: AR_DISPUTE_HISTORYERROR: Relation "ar_dispute_history" does not exist

For example: The time between activity A-1 and activity LIKE A. Activity LIKE B can be A-2, A-3, ..., A-n. I always want the activity that is closest to activity A. Between A and B can be other activities. thanks for helping

Hi ,We are in the process of initiating a PoV with one of our clients .We want to setup an extractor server to connect the On-Prem Oracle EBS system. Client confirmed : They have issues in configuring Windows and Ubuntu OS for the same purpose. My Question Is:Which OS should be suitable for this ?Please share the Extractor server setup Step details for that OS.   RegardsAyan    RegardsAyan

First we have created AP process and added tables which are required for Kpi's of P2P process. Extraction part is done, but we have stucked in data model. 

Why is the format field in the pql-editor offering more options in formatting the output than the FORMAT() function? E.g. I can enter in the format field in the pql-editor the format '%d.%m.%y' without any occuring errors but not in the format function while converting a date to a string. 

Kann man CO2 Werte anzeigen lassen. Ich möchte eine Excel Datei mit Aktivitäten und deren CO2 Werte hochladen, doch bislang habe ich keine Lösung dafür gefunden?

In the below table I am checking for duplicate values in Name column. I need the count of duplicate values for example Name ABC has twice, so the out put should be 2. Could you please help me with it.  OUTPUT:

Converting from BINARY to STRING is available directly on On-Prem system.But the same is not available on EMS or I am missing out on the feature.Can you please suggest a good way to CONVERT BINARY to STRING. I do not want to CAST AS STRING as that doesn't help. I need to CONVERT BINARY to STRING

We have a functionality where we need to create a sequence from 0 with increment of 1 and going up to a maximum value (count of a table).We are using a dynamic variable 'maxi' that take the max count of a table and stores this max value.Next we are creating a SEQUENCE between 0 and maximum value that we obtained in the previous step.Query we are using is - CREATE SEQUENCE SERIES increment by 1 minvalue 0 maxvalue <%=maxi%> start with 0 The problem is: We need to store this sequence in a table and then use that table to do a CROSS JOIN with another query. We are not able to develop a correct syntax to store this sequence in a table. We would need your help in developing the correct queries to:Create a table that stores a sequence from 0 to a max value (say 100), andCreate a correct CROSS JOIN reference with another query 

i would like to know the pattern for implementation professional certification and the important topics like which kind of questions they can ask