question

martin.j avatar image
0 Likes"
martin.j asked Jordan Johnson answered

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?

FlexSim 18.2.2
experimentercalculated table update
· 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.

Sam Stubbs avatar image Sam Stubbs ♦ commented ·

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

0 Likes 0 ·
Sebastian Hemmann avatar image Sebastian Hemmann Sam Stubbs ♦ commented ·

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 Likes 0 ·

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered

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