AnsweredAssumed Answered

PI Integrator for BA: reporting bad values?

Question asked by Roger Palmen on Oct 21, 2020
Latest reply on Oct 27, 2020 by Roger Palmen

Hi all,

Now i've used a nice EventFrame analytics to assemble all data for my report. I use a double datatype for my numeric columns, calculated using an Output at close expression. All works fine, also a Digital State (No Value / No Results) is nicely shown in the EventFrame attribute. The reason to use these System Digital states is of course because datatypes are not nullable in PI.

 

However if i now export this data using the PI Integrator for BA, i get the numeric value of the Digital State, e.g. 214 for "No Data" where i expected a null value (columns are nullable in my SQLserver table target).

Of course now it's difficult to differentiate between a valid value of 214 and the digital state value of 214. Also i would not want to export the status column for all columns in my view... that's quite cumbersome.

 

How to best deal with this?

Outcomes