Emerson Exchange 365

• Not Answered

DeltaV Event Chronicle Question

Is there any way to merge data sets together or view many data sets at the same time? Our system had been set up to do current data set storage daily so we have hundreds of current data sets each for its own day. Therefore, if I want to view anything that is no longer in the active data set I can only view it day by day (using "configure events" in process history view and selecting the individual data set) and am not able to view larger time periods at once.The "Configure Events" window will only let me select one data set at a time. Is there another method of doing this? For the future, I am going to change the settings so that the current data sets will fill to a certain memory limit rather than creating one every day. But for the data sets that have already been created obviously this will not help.  

Steven Estes

• 24 Jun 2014 9:35 PM
• Cancel

4 Replies

• Youssef.El-Bahtimy

  

  • 25 Jun 2014 5:11 AM

  DeltaV event chronicles (past v. 8) are SQL data bases.  You should reasonably be able to merge them, however you may have to engage Emerson advanced services if you want it done right.

  The design consideration for Event chronicle and continuous historian sizing is estimating a consumption rate baseline for your system.  Then size datasets to provide the reasonable amount of segmented data, say the last 6 months, in the active dataset.  Balance this against performance, as a dataset that is too large will be difficult to query.

  I would like to see Process History View developed to seamlessly query the appropriate dataset based on date and time of the query, so that you don't have to select different data sets to find what you are looking for (just like it does for continuous history).

  Sounds like a UDEP request.

  • Cancel
• Steven Estes

  

  • 25 Jun 2014 7:22 PM

  In reply to Youssef.El-Bahtimy:

  Thanks for the reply. If there is no user utility for merging the data sets then I will just gut it out and export them individually and compile the information that is being requested as I do not want to risk anything going wrong or corrupting any of the files.

  I would also like to see Process History View work in such a manner. Maybe that change will be made in a future version.

  • Cancel
• Petrisky

  

  • 16 Oct 2020 9:57 PM

  In reply to Steven Estes:

  Has any progress been made on the merged dataset request? It is very frustrating to export (240) 12hr database files one at a time, and then try to deal with all that data in separate files. I want to use PHV to filter alarms for an area or module etc... over a 3 month period.

  • Cancel
• Markus

  

  • 19 Oct 2020 6:18 AM

  In reply to Petrisky:

  You can use DeltaV Reporter to filter and view all the attached and extended databases at once.

  • Cancel