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?