PI Integrators

Welcome to the PI Integrators feedback page!

We created this forum to hear your ideas, feature suggestions and feedback on PI Integrators. Please suggest your most important features and design change ideas on this site, and vote for your favorite ideas.

Please note that your ideas and comments posted here are visible to all other users.

  • For bugs, please open a case with OSIsoft Tech Support through myOSIsoft Customer Portal  (https://my.osisoft.com) instead of sharing them on this site.
  • For documentation feedback and bugs, please report to documentation@osisoft.com instead of sharing them on this site.
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Allow to include open Event Frames

    The integrator only includes EventFrames that are closed (have end time). That is not included in the documentation, so a major issue for me now.
    The reasoning is that an open EF may not have all data or correct data. I would prefer to let the user decide on that and allow to include open eventframes. After all we can filter out the open ones using row filters.

    I planned to use the integrator to get rid of OLEDB Enterprise. Now it turns out i cannot reach all my data. Looking seriously into returning the license.

    The reasoning is

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

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  2. Display more than 100 records (or show the total number of matching records)

    Allow the user to display more than 100 records in Modify View screen or at least show the total number of rows as additional information.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  3. Add ability to export stored Events for Event-based analysis, not only interpolated

    Currently we can export PI data using a given interval, returning evenly-spaced rows of data.

    However, for some uses i need to have the original events stored in PI, not interpolated.

    E.g. i need to create a report that contains every value that the operator has entered (e.g. a catalyst dosing volume) in the duration of an EventFrame.
    For that i would need Archived values like i have in OLEDB Enterprise.

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

    We’ll send you updates on this idea

    6 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  4. Automatically remove data from continuous views

    As an engineer using PI View or SQL writers for a report, I would like option to remove data older than a certain cutoff. For example, a continuous view is used to generate data for a report on the last 8 hours. Data older than that are no longer needed for the report and should be removed to avoid unnecessarily large tables.

    One workaround with Text and Hadoop writers is the Append Timestamp option, but there's no ability to remove data from other targets.

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

    We’ll send you updates on this idea

    4 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    For supporters of this idea, what is the downstream client tool that consumes the data prepared by the PI Integrator? Is the concern about disk space or how to only display data for a specified time range?

    For the former, this seems to be a different type of “rolling” reporting use case that we do not currently have a solution for. In the mean time, as Rory mentioned below, a stored procedure on SQL would work if this idea is intended for SQL writers.

    For the latter, is it possible to create “rolling timespans” for your graphs, reports, tables, etc.? For example, here’s a video on how to create calculated measures for a table based on last day or month of data: youtube.com/watch?v=NevFWL2JoMU

  5. Allow for sampling rate that is faster than one event per seconds

    High frequency data is increasingly common. With examples in manufacturing of events happening entirely within a few 100s of milliseconds.
    The request is to allow the export of interpolated data at a rate higher than the current limit of 1 event per second.

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

    We’ll send you updates on this idea

    1 comment  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  6. BI Integrator preserve Column Configuration on Filter Change

    When you copy a BI Integrator Job ans change some settings in the Filter all attributes are added to the column view.

    We remove Attributes that are not needed e.g. Level1 Attributes when we only Need the Level2 Child Attributes. On a change the Level1 Attributes are always added.

    We rename Attributed and change the export settings e.g. Aggregstion or UOM. On a filter change the original Attributes are added again.

    We would prefer an option/setting in PI BI that no column is added to the column view and you can select them by the Add Column function.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  7. HA/Failover mechanism for the PI Integrator for ESRI

    As a user of the PI Integrator for ESRI, I would like a High Availability/failover mechanism for the integrator (data relay and application server components).

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  8. Keeping AF structure consistent with the Map layer

    There is a new map feature created, while adding a new element based on the same element template in AF.

    However, while deleting one of the existing AF elements does not delete the map feature.

    Customer is monitoring oil wells. They are rebuilding the AF structure (using custom AF SDK script) once a day. They want to display only the active oil wells. The newly added oil wells are displayed alongside the updated ones and the removed ones (features) from the AF structure. They want to remove the map features for the non-existent elements (inactive wells).

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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. …

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  10. Time shifting data to align with plant process flow and tank retention

    This concept would really apply to all integrators except Esri. 
    We are careful to interpolate data in evenly spaced samples for large matrix analytics.  What happens when some of the data is upstream and the rest of the data is downstream and a tank sits in the middle with a 2 hour retention?  The data will not align.  We need to take into account the asset time retention as the process flows from the beginning to the end.  This can easily be calculated by time shift analytics that would shift data on the inlet to match the data on the…

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  General  ·  Flag idea as inappropriate…  ·  Admin →
  11. "Start Time" and "End Time" of a view reflect the data the view contains.

    As someone who uses the UI to get a summary of what my views contain, I would like the view's "Start Time" and "End Time" to reflect the actual data contained within the view in the case that I "Update Data" in the view to be something outside of the original bounds.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →
  12. Remove default columns from text file target

    In the output file for the text file target there are some default columns that get added to the file "ID, PIIntTSTicks, and PIINTShapeID ". It will be good if those columns are not automatically added to the output file.

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

    We’ll send you updates on this idea

    2 comments  ·  PI Integrator for Business Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    Update: One of our colleagues rightfully pointed out that the ID column on the text file target still exists and is non-necessary. The ID column will be removed for the release after PI Integrator for Business Analytics 2018 R2 SP1. Thank you!

  13. Create ArcGIS Feature Services and Layers with More Descriptive Names

    Update the naming convention used to create ArcGIS feature services and layers to use names that more accurately reflect the services and layers stored on the Integrator side. Customer Issue: The current convention is to use numbers instead of the layer names which causes confusion when trying to locate published items in ArcGIS Online or Portal for ArcGIS.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  14. Support ArcGIS Stream Services

    Provide PI System data to ArcGIS stream services in addition to feature services. Customer Issue: Some customers require immediate availability of the data in client applications. Stream services provide a near-instant update rate which feature services cannot.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  15. Make Attributes for PI Coresight Ad-hoc Trend Selectable

    Provide a mechanism to filter out attributes that are not wanted on the PI Coresight ad-hoc trend. Customer Issue: All of the layer's fields (attributes) are included on the ad-hoc trend by default. This makes for a crowded trend that often includes unnecessary attribute data.Ê

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  16. Operations Dashboard Trend Widget: Compare a Single Attribute Across Many Features

    Provide the ability for users to trend only selected attribtues of a layer across multiple features in that layer using a PI Coresight widget. Customer Issue: The existing Trend WidgetÊallows users to view all of the attributes for a single feature. Users want the option to limit the attributes on the display and then select multiple features to include.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  17. Provide SQL Scripts for Creating the SQL Database Prior to Installation

    Provide a way for a user with elevated SQL credentials to complete the SQL part of the installation prior to another user completing the installation of the executable. Customer Issue: Many customers have restricted access to SQL servers that an installing user would need to complete the installation. Providing scripts for the customer to complete the database creation before the installation means they can review the specific tasks that will be carried out before running the scripts, and they can have a user with existing elevated permissions perform this part of the installation.

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

    We’ll send you updates on this idea

    2 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  18. Editing Layer Fields: Sort AF Attribtue Options Alphabetically

    When editing an existing layer's fields (not during layer creation), sort the AF attribute dropdown list aphabetically rather than by category. Customer Issue: When there are a lot of AF attribtues on an element template, viewing that dropdown list of attributes by category makes them difficult to find.

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  19. Create Notifications/Event Frames Triggered by Location

    Provide a mechanism to create notifications and event frames in AF as moving assets approach geotriggers and geofences. Customer Issue: Customers need to be alerted when these events occur and want to have that information stored in the PI System.Ê

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

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  20. Widget Styling: PI Coresight Widgets and their Dialogs do not Uniformly Implement Operations Dashboard Customizable Styles

    Provide widgets to Operations Dashboard for ArcGIS that respect the skinning and style customization that a user wants. Customer Issue: Users want the PI Coresight widgets and their dialogs to respect customization through the dashboard's extensibility model in order to control the look and feel of their environment.

    1 vote
    Sign in Sign in with OSIsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PI Integrator for Esri ArcGIS  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

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