I find it difficult to understand the details of your model and your problem. Could you provide some more detail on your setup, error messages in which client, etc.
Thanks for getting back to me. Weirdly overnight it started working.
The goal was to create a system which can output a variable describing whether a value is LoLo, Lo, Normal, Hi or HiHi. Depending on the location in the structure each of these states may have a different degree of criticality.
In the Element there is a unique identity number.
The current value (from a PI point) is contained in a root level attribute
Within this there are sub attributes describing the limits, there is also a unique identity term. this is made up of the identity number of the element along with the name of the parent attribute.
The values of the LoLo, through to HiHi, along with their states are drawn out of a lookup table, where the lookup term is the identity described above.
A nested if statement will return a value, which corresponds to the criticality of that state.
|Unique Identity String Builder |Unique Number;_;%|Attribute%
|LoLo..HiHi Table lookup using Unique Identity
|Current State Val If statement nest using formula functions
The problem I was having was the final return of that value from the nested if statement. Yesterday it was saying that the unique number in the Element could not be time determined, it is a fixed value that never changes and entered directly into AF. This seemed to be interfering with the performance of both compressed data and calculated data queries using datalink. Today both these functions are working as intended, I'm very certain nothing has changed in the interim.
AF client is 2016 SP1, and the server is 2.7.0
Datalink version is 2015, 5.2.0
I'm unclear what has changed to make it work, but am glad it has.
1 of 1 people found this helpful
Thanks for the details. Glad it works, as the setup appears to be valid.
Note that from AF Server 2.8 you have attribute traits available that can be used instead of the child attributes: https://livelibrary.osisoft.com/LiveLibrary/content/en/server-v7/GUID-0D32012F-7520-4555-8086-FBC6286FC50A