Here we will walk through the process of using a PI integrator for business
analytics to export the dryer event frame data into a CSV file.
From the windows taskbar open PI System Explorer and review the dryer's database. We will be using
the PI integrator for business analytics to create an event frame view publication
based on the event frames built upon this asset model. The publication target will be a dot CSV
file posted in the subdirectory C slash PI world. This is also the PI world folder shortcut on the
desktop. The CSV file will provide the data for populating our data set and analyzing in Power BI.
First, open the PI integrator for business analytics from the desktop shortcut.
Next click on create event view on the top menu, name your view
my dryer regenerations and click create view.
On the select data page be sure to select the dryer's database.
Select one of the listed event frames under the source event section on the
left. Drag and drop this event into the search shape area in the middle of
the screen under event shape. On the event frame that was just dragged to the center,
click on the Edit pencil icon to the right and bring up the edit filters option. Adjust the
filter to use the dryer regeneration event frame template rather than just the event frame name.
With the same event frame highlighted on the left section under source events notice the attributes
associated with these event frames just below in the attributes section. Click and drag each of
these attributes to the center of the screen under the dryer regeneration cycle parent that was just
created in the middle of the screen. Your event shape should now look like the one shown here.
With the shape selected and the filter set you should see over a hundred event frames
matching the criteria listed in the matches area on the right. Click on the next button
on the upper right corner to proceed to the modify view page. The modified view
page shows a preview of the first 100 rows of data from the first 100 event frames matching
the event shape. Set the time range to be January 1st 2019 at 5:00 a.m. to December
31st 2019 at 12 a.m. to match the available PI data that we have for the lab. Then click apply.
Highlight the event frame duration column to bring up the column details pane on the right,
adjust the data type to single to get the additional digits for duration. Click Next to
proceed to the publish page. Once on the publish page select CSV file as the target configuration
and click publish. Then confirm to publish the data as a CSV file. The file name will be the
name of the view:my dryer regenerations and it will be in the subdirectory C / PI world.
This is also the PI world folder shortcut on the desktop. This target was previously
configured using the administration pages of the PI integrator for business analytics.