question

Ankur A3 avatar image
0 Likes"
Ankur A3 asked Felix Möhlmann commented

Quick check on calculated table interval updates?

Hi Team,

I am working on model where values are first extracted to calculated table from global tables to check as statistics while using optimizer.

Also, I am using some more calculated tables to extract some statistics from calculated table. But I am not sure that how to make sure that calculated tables are updated in the same sequence one after another every time.

Does it follow the sequence in which it is created when getting updated at the same time?

Currently, I am updating it every 1440 minutes, but I am afraid if it doesn't happen in same sequence, I may lose the last row values.

Can you help me in this?

Thank you!

FlexSim 23.1.0
statisticscalculated tableupdate
· 1
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

Hi @Ankur A3 , was Parker's answer helpful? If so, please click the "Accept" button at the bottom of the question. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 Likes 0 ·

1 Answer

Parker S avatar image
0 Likes"
Parker S answered Felix Möhlmann commented

@Ankur A3

I recreated this with two calculated tables with the same update interval of 5 seconds. The sequence in the event list follows the sequence of creation.

1697043325960.png

I confirmed this by deleting CalculatedTable1 and recreating it. It is now second in the sequence:

1697043551392.png


You could avoid any potential issues by changing the update interval to "Always" for both calculated tables unless there is a specific need to use time intervals.

I hope this helps!


1697043325960.png (75.6 KiB)
1697043551392.png (75.8 KiB)
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Ankur A3 avatar image Ankur A3 commented ·
Yes, I got it.

But if we use always option, model speed will slow down. That's the reason I thought of using 1440 as interval.

Thank you! @Parker S

0 Likes 0 ·
Felix Möhlmann avatar image Felix Möhlmann Ankur A3 commented ·
As far as I'm aware "Always" means the table is updated whenever a value on it is accessed. If the only thing in the model that reads values from it is another calculated table, then the table should update only when the Calculated Table that uses it as a data source does.
0 Likes 0 ·