Quick check on calculated table interval updates?

Question

question

Ankur A3 asked Oct 9, '23 Felix Möhlmann commented Oct 17, '23

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!

Software Version:

FlexSim 23.1.0

statistics calculated table update

· 1

Jason Lightfoot ♦ commented · Oct 16, 2023 at 05:45 PM

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 ·

Answer 1 · 2023-10-11T17:05:22Z

Parker S answered Oct 11, '23 Felix Möhlmann commented Oct 17, '23

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

1697043325960.png (75.6 KiB)

1697043551392.png (75.8 KiB)

· 2

Ankur A3 commented · Oct 17, 2023 at 02:50 AM

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 ·

Felix Möhlmann Ankur A3 commented · Oct 17, 2023 at 05:59 AM

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 ·

question