Skip to main content
Solved

Workday calendar isn't working in Studio Analysis

  • July 13, 2022
  • 6 replies
  • 36 views
P
Level 4
Forum|alt.badge.img+14

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.

Best answer by .14600110018

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

6 replies

.
Level 11
  • .14600110018
  • Level 11
  • Answer
  • July 13, 2022

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

P
Level 4
Forum|alt.badge.img+14

Hi @1460067637,

 

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

 

image.png 

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

 

Many thanks for your help!

 

Paula

.
Level 11

Hi @1460067637,

 

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

 

image.png 

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 

P
Level 4
Forum|alt.badge.img+14

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 

P
Level 4
Forum|alt.badge.img+14

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

 

 

Many thanks for you help!

.
Level 11

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

 

 

Many thanks for you help!

Amazing! Happy I could help :)

Community Code of ConductAccessibility statement