Calculated Table joins not updating

Question

question

martin.j asked Oct 17, '18 Jordan Johnson answered Nov 16, '18

Calculated Table joins not updating

I have a model with multiple calculated tables that draw data from one another in a hierarchy, but when I switch them all to update automatic something goes wrong. The tables at the top of the hierarchy are updated by being on a dashboard, but the lower tables dont seem to be updated first. As the top tables attempt to query data from the lower ones that are not updated and therefore empty, I get a bunch of meaningless errors.

The only thing that makes sense is this:

Reference to Blending Time Total could not be resolved to a valid column. Parsing halted.

After this error none of the tables will work until the model has been reset. If I update the tables manually in the correct order it seem to work but that is no good for charts.

I have also attempted to run experiments, and draw data from the Calculated Tables using the 'Experiment.CalculatedTable' reference, but there does not appear to be any data in the tables. Are calculated tables that are set to update always not updated during an experimenter run?

Software Version:

FlexSim 18.2.2

experimenter calculated table update

· 2

Sam Stubbs ♦ commented · Nov 15, 2018 at 12:56 PM

Hi I'm sorry your question seems to have slipped between the cracks. Did you still require assistance? @martin.jensen

0 ·

Sebastian Hemmann Sam Stubbs ♦ commented · Nov 16, 2018 at 09:37 AM

Hi @Sam Stubbs, maybe you have to add the author @martin.jensen to your question. So he would be notified about something happened in his question.

0 ·

Answer 1 · 2018-11-16T19:36:34Z

Jordan Johnson answered Nov 16, '18

As far as the experiment data, Calculated tables don't save their data like Statistics Collectors do (although that has been changed for version 2019) during an experiment.

As far as the update sequence, that should be working correctly. I was able to chain several Calculated Tables together, and the top level one seems to update correctly, even if the intermediate tables are not visible anywhere. However, I don't have any joins. If you could post the model (you can make it private if you need to), we could see what is happening more clearly.

As a workaround, consider using nested queries. If the intermediate Calculated Tables don't need to be separate, then you can write all the queries as a single nested query:

SELECT ColA, ColB FROM (SELECT Col1 AS ColA, Col2 AS ColB FROM SomeTable)

question