OSIsoft Cloud Services
Welcome to the OSIsoft Cloud Services feedback page!
We created this forum to hear your ideas, feature suggestions and feedback around our cloud offerings. For more information on OSIsoft Cloud Services, please refer to: https://cloud.osisoft.com/
Please note that your ideas and comments posted here are visible to all other users.
- For PI Cloud Connect, please enter your ideas here: https://feedback.osisoft.com/forums/598033-pi-cloud-connect
-
Filter Data in a Data View
Ability to filter data coming back in a Data View. For example, grab all data when the RPM > 9000.
4 votes -
Bulk creation of data views for similar sets of assets (e.g.: for a site)
Customer has several sites and requires reports for each site. Looking for a way to simplify Data View creation for multiple sites
2 votes -
Event-based total (non-weighted Total) Summary Type
As a Data View creator, I want an event based total Summary Type data field so that I can see a calculated sum of values that is not weighted by time (or any index)
2 votes -
Provide a trending experience for data views
Including trend in the data view configuration tool will make it easier to explore and validate your data view configuration, and underlying data set
2 votes -
Add support for monthly, yearly, or other irregular interval Data View queries
I am using Data Views to produce reports containing data queried with a Monthly or Yearly interval. Currently, I have to make a separate query for each month or year and then append the results together as the query intervals are not constant (ex: months can range from 29-31 days). An easier way to query data with these common intervals using a single query would make generating these reports much easier. Additionally, I am using the Power BI Connector to create the reports so it would also need to be able to handle any added query options.
1 vote -
Allow compound index streams in data views
As someone with data across multiple types and streams, all sharing the same compound index structure (such as an integer + timestamp), we would like to be able to query shaped data for these streams using the data views stored value retrieval where each row is a unique combination of the multiple indexes.
1 vote -
Allow different Interpolation Modes for Data Views
When querying data through the PI Connector for PowerBI using Data Views, you are only able to use the default Interpolation Mode which is Continuous.
The Continuous Interpolation Mode returns interpolated data using previous and next index values. If either of the previous or next index values are null, then the returned value will be null as well. This means that if you are querying a timestamp that is later than the latest archived value in OCS, the return value will be null.
There are multiple Interpolation Modes available for read stream data, please make them available for the Data…
1 vote -
Add an Aligned data retrieval mode for data views
It would be beneficial to have a data retrieval mode that creates one row per recorded value for one property, and interpolates values at those timestamps for the rest of the properties. This is a hybrid of interpolated and stored, where a single property can dictate the timestamps of each row, and the entire grid is filled in with data.
1 vote -
Select which fields to return for a Data Views Data API Call
As a Data Scientist, I want to select which fields in a Data View should be returned in a Data Views Data API call so that I do not need to modify the Data View configuration and can return only the data I am interested in for my current analysis.
1 vote -
Data View query definition with data access request
I would like the ability to define stream queries associated with a Data View as part of the request to GET data vs. requiring this as a separate configuration step in the workflow.
1 vote -
Have the Form Parameter for Data Views Data Calls Accept form=json
Currently, to receive the output in json form, the form parameter either needs to be left off the URL or set to form=default. Specifying form=json results in a 400 error, which can be confusing since it's a valid form. Having the parameter accept either form=json or form=default for the json response format would be beneficial.
1 vote -
Data view refresh preview option
In the portal I would like to have the Refresh Preview button as an option at all times on the screen. This button currently appears if you have Auto Refresh off and you make a change to what would be in the table. In my case I knew they were updates to my data over the time range and I wanted to see these updates in the preview and had to refresh the whole page.
1 vote -
Improve user experience for building queries in Data Views
As a Data View creator, I want an improved user experience for creating asset and stream queries in Data Views so that I do not need to understand stream search syntax or asset search syntax to create queries for my Data Views
1 vote -
Display stream Description, TypeId when managing Data Views queries
When running queries in Data Views, the query checks stream Description and TypeIds, but those values are not displayed in the UI. When these fields are the only match for a stream, it can be unclear why the streams were returned at all. Suggest displaying the stream Description and TypeId somewhere in that view to make this clear. This would also allow the user to use stream's Description.
1 vote -
OCS Data Views to offer Last Recorded Value retrieval mode
*** Analog to the PI Integrator for BA feature ***
Using Data Views when retrieving sampled interpolated values we cannot make use of a linear interpolation between two archived values since the result is not representative of the reality of the process.
Say I have a value of 0 at 12h and a value of 10 at 13h. I don't want to interpolate every 10min with a slope of results between 0 and 10 for this 1h publication. I want to make use of the Last Recorded Value of 0 and keep this 0 throughout the intermediate interpolations until the…
1 vote -
Enable the inclusion of a Stream or Asset's Description in a column header
We would like to add the Stream's description to the data view column label so that it is present in the dataset.
1 vote -
Allow multiple identifying fields in column labels
It is sometimes desired to select more than one of the options for the 'Identifying Field' for the column label, particularly when using PI to OCS streams so that 'Name' and 'EngUnits' can both be displayed.
1 vote -
Add querying of Data Views to Data View API
There is currently no way to search for Data Views apart from retrieving them all and then searching. Other APIs such as the Assets API and the Streams API support querying so it would make sense for the Data Views API to as well.
1 vote -
When changing the startIndex, allow it to override the endIndex if you are changing it to a time ahead of the endIndex
Currently, in order to change your date range to a later date, you have to first change the endIndex, and then the startIndex. If you change the startIndex to a date later than the endIndex, it would be easier if it simply cleared the endIndex field for you
1 vote -
Enable conditional substitution between fields in a Data View
As a Data Scientist exploring or analyzing my dataset, I want to have the ability to configure a Data View to conditionally substitute the value from one field into another field (for instance if a field has a null value at one interval, fill that interval with the value from a different field)
An example of a common use case would be regarding PI tags sent to OCS via the PI to OCS Agent. Consider a scenario where a numeric PI tag (eg. of type Float) had a period where it stored system Digital State values (eg. Bad Input) instead…
1 vote
- Don't see your idea?