In this Lab, what we'd like you to do is
use ProcessBook and DataLink, first of all, to search
for PI UnitBatches and PI SubBatches. Now, those
are actually the UnitBatches and SubBatches we created in the previous
exercise. And, we will show both the current
batches and the historical batches. We will compare process
values. And, then we will do this als... -- the same type of thing
using Excel. So, we will do that first in ProcessBook and then
Excel. The first part of this
exercise involves building a ProcessBook display.
You are going to be building a display that shows the
UnitBatches in either Digester1 or 2,
and gives you the ability to search for each of 'em.
We are going to be looking for specific types of
UnitBatches, the ones that have completed in the last hour,
the ones that are less than ten minutes long. And then,
we will take a look at the Align Options which we will see more
later, later on. Also, in our second
exercise, we are going to be looking at DataLink. Within DataLink,
you are going to be building a report. It's in Excel.
DataLink is an add-in to Excel. It's going to take a look at the
last UnitBatches. It's going to show key things about those
UnitBatches: the Start and End Time of each UnitBatch,
and then drill down into the little SubBatch Elements within those
UnitBatches. Here are what the
two different solutions are going to look like. The ProcessBook
solution is a display that has this
BatchView object on it. This is the
add-in to ProcessBook. It shows
Batch Results. We have specify the name
of the Unit and specifics like the hour.
We do a Search and we come up with Search Results.
And then, depending on what we have chose to display, we
can show a Gantt Chart and we can show trends of
some of the Aliases which you see here.
Now the exercise on DataLink
is going to look like this. It's a spreadsheet that's using the DataLink
add-in, the BatchView add-in to DataLink,
to retrieve Batch Records, and then also use the DataLink
add-in to Excel to do
calculations based on the PI Tags
that are Aliased, associated with that Unit.
So, I can search for specific Batches like
in this case, it's Digester2, or I can switch to Digester1.
I am finding just those Batches that match those. I am
finding the Start and End Time, and also, by
knowing what the unit is -- and that's part of the Batch Record --
we can then resolve an Alias
from the Aliases
listed here and the Units
listed right here. That resolves into a PI Tag.
So, as you can see, if I switch to Pressure,
different Alias resolves into a different PI Tag,
and we get a different set of numbers here.
So what we have here is
basically a, a nice little search engine for searching for
Batches, and then producing some interesting statistics
about the PI Tags associated with those BatchUnits.
Now I am going to
start this exercise by closing out of my Solutions here.
And this is a copy of
PI ProcessBook here. We will start by opening this
ProcessBook Dis... this ProcessBook application up. It should
be under Start Menu, All Programs,
PI System. You should find PI ProcessBook.
Now, we are going to start and build a brand new display.
File, New. We will do a ProcessBook PDI File.
And for the name -- the exercise
calls for the name Digesters.
I will press OK. It opens up this window.
Now, I am going to maximize ProcessBook for the rest of this
so that we can see a little bit better.
I am going to switch over into Build Mode. Currently,
I am in Run Mode. I will choose Build Mode, and I am going to be
adding this BatchView object here.
Now, you will also find that within the Draw Menu.
There's an option there called Batch Group. So, either way.
I am going to go ahead and click, and draw
open a Batch Group. It's
going to be as -- about as big as the current work-
space there. Now, once you do that, this Dialog Box
appears, and this is where we are going to specify
things like which Unit, which BatchUnit we are
going to be looking for. In our previous exercise, if you did that before,
you notice that we have something called UnitBatches
and PIBatches. We are going to be use --
dealing with UnitBatches in this case, so we need to find the
Unit Name that we are interested in searching for. This is
the BatchUnit Name that we are -- whose,
whose Batch Records we are trying to find. And, Unit is
typically a piece of equipment where the Batches run.
Do make sure that your Server is
selected properly, so this should be the Server for the Online
Learning Labs. And then, under Unit Name, what we are going to
do is a, a straight String Search. We are going to look for all the
Unit Names that begin with the word Digester.
So, Digester should produce
both Digester1 and Digester2, and there the *
is used as a wildcard character.
Now, I will go ahead and choose Search,
and what we should see is a series of
Batch Records. Now, of course, if you are trying this at home and you do not have any
Batches configured, you are not going to see anything. If that's the case,
go back to the previous Learning Lab about building
a simple Batch, and this will give you some results that you
can work with. But this is the list of
resulting Batch Records. Now, if I were to switch
this easily -- just very simply from
Digester, *, to put a One at the end of it,
you will notice that we limit our Search Results. So, what we are
talking about here is a very simple Search mechanism.
It's using a String Search to find
specific Units. Now, I am going to
restrict this further. Instead of looking for everything,
let's just go back one hour. These are fairly quick Batches. They are only
four or five minutes long, just to facilitate these in a
Learning Lab environment. Now, let me direct your attention
down here to where we see Available Aliases.
We are looking for all those Aliases that are
common among the different Units. As you can see, there are different
Units, Digester1 and Digester2.
And, common to all of them, are these two
Aliases. So, I am going to go ahead and add these. These are going to be the
Aliases we see in our Trends.
Now, if on your test system, you are trying this and you do not see
Common Aliases, it may be because the Units that have
been found do not contain Common Aliases, in which
case you can just choose All, and then you will find
all the Aliases available.
Now, by default, this is only going to result
in showing you a Gantt Chart and a
series of Trends. I, I want to add
the Search Results and the Search Mechanism. As you can see, the
Preview here -- that's the default behavior, Gantt
Chart plus Trends. But, we can add more.
Now, if you take a look at your Preview here,
the Search is showing -- or the Search Results that
we are seeing are showed
Preview Here, and you can configure those by
either double-clicking right here on the Preview itself, which
you get -- in which case you get a, a configuration
screen -- or, you can go up here where it says Results, and just click on
Configure. Either one get you to the same place.
And, of course, this works the same for all of these.
If I want to configure the Gantt Chart, I can double-click here
or just double-click over here where it says
Gantt, or just click on Configure.
What I would like to configure in this instance, though, is the
Search. Now, I would like to add a couple of new Search criteria:
the Duration and just a General
Filter. As you can see in the Preview, those will show up below.
Now, another thing
this exercise calls for is that this Trend
here is actually not just one Trend but multiple Trends.
Now, I can do that for each of these Aliases by choosing
the Split option. You notice by choosing
Split, now we are going to see different Trends. One for the
one Alias, one for the other. And,
as we have seen before, there's also a Configure
option for the Trends. So, if I choose Configure,
I can specify what type of -- what
name I would like for this -- for example, what Trend Title I want for this.
So, for example, in this case, this is going to be Pressure.
So, we will simply label it as such.
I will do that, and then do the same thing for Temperature.
And we will call this Temperature.
[typing]
So, with all that configured, we are ready for the
big finish which is to take a look at our results. When you choose
OK -- ... here's our Search Results.
It's a little bit bigger, does not quite fit on my -- all on my screen.
So, I can choose Fit All in order to make
this fit a little bit better.
And, here's our, here's our, or here are
our, our Search Results. As you can see,
we still have some things on here that we could probably
improve on. For example, this is showing me this one
long Search -- much, much longer than all the
rest of them. So, part of our, our next
task would be to learn how to restrict
this Search Results even further.
These are our first Results,
so let me demonstrate how to make Edits if
you do not like the way this is appearing. First of all,
go into Build Mode. Now, when you initially select
on that Batch Group,
you will get resizing handles that affect the entire Batch
Group. So, for example, I can click and drag,
and this is going to affect everything within that Batch Group.
As you can see, it just did. Now, I can also,
after selecting once, I can double-click to get the --
whoops -- I can select a second time --
not double-click, excuse me -- to get access to the
individual Objects. So, for example, this
individual Trend can be updated like --
just by clicking a second time after
you have clicked, or clicked on the Batch Group itself.
I think I am going to use this here
to make these Search -- this Filter, a little
bit smaller. So, if you notice, it's kind of large.
I have selected my Batch, and now I have
selected my individual Search, so, I will just
pick that up, roll that up a little bit, pick
this and roll this down a little bit.
And, so now, we are seeing something that looks a little bit
better. It's not quite as good as I want it,
so let me move this down some more.
There we go. So now we have room to put our Filter.
We also have room to see our Search Results here.
These are the, the Results of this Search. Now, these
Results should be explained here just briefly. These
are the individual Start and End Times of each of these Batches.
As you can see, we have -- one of these Batches here
is fairly long. Most of these are about three minutes long.
Now this one's about -- this goes from 3:55 to
4:06. It's much longer than the others. If I look at the
Gantt Chart I can see it's probably this one right here.
That's Unit BatchID 1192,
and that is, in fact -- ... that's the one it is, 1192.
I, I can always remove that by just clicking
on the little eyeglasses, and now, it's no longer showing up here.
So, if you notice, we are automatically
resizing what we display,
depending on what's been selected.