PI & Batch & Datalink (Batch Best Practice ??)

Discussion created by wpurrer on May 25, 2010
Latest reply on May 27, 2010 by wpurrer

We have 8 Production Units without about each 3 Batches per Day.
Each Batches containes about 80 Values.

I have to create a month report about all the values and batches from a month. In this example 3*8 * 80 = 200 Values * 30 Days = 6000 Values.


* First Approach


We created a excel / datalink based on Batchview - XLS add in an DataLink - Calculated Values


:-( Even the daily reports took minutes


* Second Approach


I created an SDK - based solution ( ;-) sorry guys no ace,...) which copys the calucaltion in a new Tag (timestamped with the endtime


:-( a little bit faster, but still .. not userfriendly


* Third Approach


We removed the Batchview and only worked with compressed Data.


:-( fast, but a couple of datalink bugs appear, and we don't have the batchview features anymore:


* Forth Approach


* I copy the data into an SQL - Table. (now working on it)




What's your approach .. with Batch and PI....


Is there a recommended Solution from Osisoft?