How can we improve PI Developer Technologies for you?

Expose Values with Duplicate Timestamps in Transpose Function

https://pisquare.osisoft.com/message/116957-pi-sql-commander-and-ssrs-how-to-retrieve-multiple-values-with-the-same-timstamp

In the current implementation of the transpose archive in OLEDBEnt, a user is unable to retrieve data that may exist at the same timestamp as  another piece of data. This is because the time column is treated as the primary key of the transpose table. I would like to be able to retrieve all data using the archive transpose function regardless if timestamps are duplicated.

5 votes
Sign in
Signed in as (Sign out)

We’ll send you updates on this idea

Vincent Kaufmann shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
Signed in as (Sign out)
Submitting...
  • Carlos Sola, AGSolution commented  ·   ·  Flag as inappropriate

    As an example, in our case, we cannot make use of this Transpose Function for retrieving serveral alarm attributes in different columns.
    The function only takes values from the first timestamp duplicated.

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