Always produce output table on publication: if there is no data to export when an asset view is published, produce an empty output table
I build asset views on a schedule with interpolated time points based on a PI Point. I also set these up before any data is added to the PI Point so on first publication there is no data to export. Currently the PI Integrator for Business Analytics does not produce an output table if there is no data to export so any downstream SQL queries will fail since the table does not exist. If the output table was always created on publication, and an empty table was created when there is no data to export, this problem would be fixed.
Also in the past due to other technical issues some asset views I created did not publish, without warning. If in the absence of data an empty table was created on first publication it would provide feedback that the publication was successful.