How can we improve PI Integrators?

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.

2 votes
Sign in Sign in with OSIsoft
Signed in as (Sign out)

We’ll send you updates on this idea

TobyWells shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in Sign in with OSIsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base

Posted ideas will have one of the following statuses.
Full definition of these statuses can be found on the Home Page.
No status
NEEDS MORE DISCUSSION
RESEARCHING/EVALUATING
DECLINED
PLANNED
STARTED/IN DEVELOPMENT
IN BETA
COMPLETED