Quick check on calculated table interval updates?

[rajankur6494]

[ FlexSim 23.1.0 ]

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!

[parker_s · Accepted solution]

@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.

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

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!

[jason_lightfootVL7B4]

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.

[rajankur6494]

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

[moehlmann_fe]

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.