How does the workday calendar in data model look like?

Hello Liz,

Here you can find how original, standard TFACS SAP table looks like:

https://www.se80.co.uk/saptables/t/tfac/tfacs.htm

MON01(02, 03, 0N) are just filled with 01010101 values:

Here you can see additional examples:

<you_celonis_link>/help/display/CIBC/WORKDAY_CALENDAR

Best Regards,

Mateusz Dudek

Hi Mateusz, Thanks for the quick reply. It helps.

One more question, have I understood correctly? If I use the workday option, the calculation of lead time will only skip the date when it is set to 0 in the calendar.

Is it possible to add working hours, similar to the weekday calendar? For example, 1.1 will be skipped due to public holiday. The working hour on 1.2 is 9-18. So only the lead time between 9-18 will be taken into account.

Best Regards,

Liz

Hi Mateusz,

I have tried to create the table manually and uploaded it. Somehow it cannot be recognized.

My table looks like this. Could you help here? Thanks!

Best Regards,

Liz

Hello Liz,

Hard to tell, I will make some tests in my spare time, and check what's the difference between real TFCAS SAP table and the example ones in the Celonis documentation.

For now, the reason can be that each value has ' character at the start and the end. Table from sap doesn't have such additional characters. Try to remove that, and also upload file as "CSV UTF-8(Comma delimited) (*.csv)" filetype.

However if you only want to exclude some days (for example weekend) in calculation you can use weekday calendar, or weekday formula, as it may be easier. The function should produce the calendar in the celonis itself based on selected days).

<your_celonis_link>/help/display/CIBC/WEEKDAY_CALENDAR

Best Regards,

Mateusz Dudek

Hi Mateusz,

I have also tried the csv version without quote. It is also not working. I have attached my test.csv.

Thanks,

Liz

Hello,

It seems last 4 columns were missing, I've tried and the file seems to be accepted.

Try with that one:

Best Regards,

Mateusz Dudek

Hi Mateusz, thanks for the corrected file. It works in our sandbox. The problem seems to be our prod-environment then. I need to investigate more.

Best regards,

Liz

Hi everyone, I found this post extremely useful but I'm having some difficulties trying to get my TFACS calendar loaded into Celonis properly and being detected in the analysis.

I have followed similar to what is being mentioned above in terms of the schema and format but Celonis was not able to detect it as a possible workday calendar:

Attached is a sample data created:

Update: We were able to resolve it. The formatting in the above is correct. Just need to refresh and load the data model along with the case + activity table. Also in the above file, the Feb data is incorrect (only has 20 data points, where it needs to need to have 28 data points for year 2023) 😁

TFACS_table: The name of the TFACS table in the data model. Must have at least the following attributes

• IDENT: STRING column containing the TFACS entry identifier (e.g., to refer to a location-specific calendar).

• JAHR: INT column containing the respective years covered by the TFACS table entries.

• MON[01-12]: STRING columns containing the respective bit encoded days for each month (1: working day, 0: non-working day).