we use PI AF 188.8.131.5266 and ran into problems when trying to use Table Lookup references in AF analyses, so I made a simple test template to try to figure out what the problem is.
In the test case below I have one attribute Value SQL, which is fetched from a SQL database using Table Lookup and this works fine and I get the latest value.
I also assign the value of Value SQL to an attribute Value attribute, which also works fine.
Then I try to assign the value of Value attribute to a PI Point tag reference attribute named Value tag, and this last step does not work. The correct values are shown when doing Evaluate, but when the analyses are executed, Value tag will have "Calc Failed".
I guess it all has to do with "references to references", but don't really know how the analytics Engine is working or if this is a bug.