Workday calendar isn't working in Studio Analysis

Hi,

I have a client calendar with their working days uploaded to my data model in a SAP TFACS format.

This TFACS table is also added to the model but not connected to any other table.

I have done a complete reload properly already.

When I go to my analysis and see the throughput time, it didn't change, even if I put all the working days to "0" in the TFACS table. It seems that isn't tacking into account my calendar.

How can make it works in my analysis? Do I have to use functions to make the analysis use the new schedule?

Many Thanks,

Paula.

Page 1 / 1

Hi @paula.garci11 ,

are you using something like this when you're calculating the tpt?

REMAP_TIMESTAMPS (

"TimestampTable"."Timestamp" ,

DAYS ,

WORKDAY_CALENDAR ( "TFACS" ) ,

"TFACS"."Ident"

)

https://docs.celonis.com/en/workday_calendar.html

Hi @1460067637,

I added your formula but it gives me the next error:

Do I have to put a timestamp field in my TFCAS table?

Many thanks for your help!

Paula

Hi @1460067637,

I added your formula but it gives me the next error:

Do I have to put a timestamp field in my TFCAS table?

Many thanks for your help!

Paula

I believe you will need to connect your tables in the data model @paula.garci11

Yes, but if the TFACS table have the format 1001... I do not have any field with timestamp.

If I make other kind of table with dates and hours it wouldn't be TFACS format that is required to connect the calendar with the datamodel, isn't it?

Thank you @1460067637

@1460067637 I solved it. I put just 'BAY' instead of the "TFACS"."Ident" field.

Many thanks for you help!

@1460067637 I solved it. I put just 'BAY' instead of the "TFACS"."Ident" field.

Many thanks for you help!

Amazing! Happy I could help :)

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN