Skip navigation
All Places > All Things PI - Ask, Discuss, Connect > Ideas

Expose Values with Duplicate Timestamps in Transpose Function

score 3
You have not voted Submitted
Originally posted on UserVoice

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.

Comments