When you are working with this Batch
Group Object in Build Mode, as I have mentioned before,
when you select the first time,
you are selecting the entire Batch Group Object. When you select
the second time, you are going to select the individual
Objects within that Batch Group Object. So, for example, I can pick this
Trend up now and move it. Now, also,
about these different objects -- when you
need to have them aligned, what you will notice
is as you draw them closer together
so that they come close to being aligned,
you will see these little markers above and below
the Objects. That indicates when you do get those
alignment sym... symbols to appear,
that means that when you let go of the mouse, it will
align properly.
Let's look now at the Query that's requested
in this exercise. But we'd like to
change the Query so that we are looking just for Digester1.
We are going to look for any.
Any Batch Records that have been
active within the last hour, which is not really a change from what we saw
before. But, this time, we are going to look for only those Batches
that are shorter than ten minutes, and we are also going to apply
a Filter. The Filter's going to be looking for this
Alias Name, Pressure; looking for Pressures greater
than 3,000 for a period
greater than 45 percent of the time.
Now, we came
up with this Pressure Object
because this is one of the Aliases that is associated with the
Unit that we are working with, Digest -- the Digesters. They --
both Digesters have a Pressure Alias so we can make
use of that Alias in this Filter.
So, here's how we will proceed. I will go into Run Mode.
This is going to be something that we do just in
Run Mode. It will not affect the, the actual
configuration of this Batch Group Object. That configuration
is going to remain stored as it is now.
So, we are not, we are not making permanent changes
here. So, within the Unit Name, I am simply
going to add a One, indicating we only want Digester1.
Now, we are looking for all
Batches in the last hour, so this can stay the way it is. We are looking
for all Active Batches.
And what that means is any
Batch that was Active within the last hour. So you make
it a Batch that started longer than an hour ago, just as
long as it was Active within the last hour. Now,
under Duration, we are going to choose something, or only
Batches that are shorter than ten minutes. You will get a dropdown
here that you can modify. So, for example,
I can choose one minute,
and, chain...change that to ten minutes.
And then finally, in the Filter Expression,
this is where we would put the names of our Aliases,
along with any Expressions.
In this case, I am going to use Pressure,
that's the name of the Alias in here.
And we will say it's been greater than 3,000.
The syntax we are using here is our typical Performance
Equation Syntax. Now, this field down
here called For Period, gives us control of our.
Of what, what matching criteria,
in terms of time, we need to make for this Filter
to become true. So, in this case, we are saying for
a period that's greater than 45 percent of the time.
You can also use app -- or absolute numbers there for
greater than ten minutes, for example, or percentages. I am
using percentage in this case.
And we can, of course, specify between
45 and 75 percent, or
at any time it was greater than, etc.
So,
with these configurations
here, what we should end up with is some
much smaller, much more restricted set of
Search Results. Right now, we are getting
many different Results here,
as you can see. And if I go ahead and choose Search now,
what we are getting is just those Results that
match this criteria. And, of course, if I were to switch this around
to a different Digester, we would see different
Results yet again. Yeah, there we go.
Now,
as I mentioned before, the changes that we made here, these are just
changes in Run Mode, so we are not changing the fundamental
definition. In fact, if you go into Build Mode, and you
double-click on this Object, you will see that all the original
criteria are still there.
And, of course, what that means is if you do update this,
you will notice this
comes back with all the normal criteria without
those -- that extra Filter, etc.
Well, the next part of this exercise is
to do a very similar thing using PI DataLink.
So, I will start that exercise by closing out
a copy of this ProcessBook, and opening up a copy of
Excel.
Of course, Excel, you should be able to find in the Start Menu.
I will find it under All Programs, Microsoft Office,
and Microsoft Office
Excel.
Here's a copy of Excel 2007.
If you have not seen it before, DataLink appears
now in the Ribbon within Office
2007. So, a lot of these things you may have seen before
in, in DataLink are, you know, show up in a slightly different
look and feel with Office 2007.
Now, under Add-Ins, this is where we find the
BatchView Add-In, under PI Menu.
Now, if this Add-In does not appear on your machine,
either you are not licensed for it, of course, or you
may simply not have a reference to that Add-In.
So, if you go into the Windows Option, under Excel
Options -- or, excuse me, that's the Office
Button under Excel Options -- choose Add-Ins.
And then you can click on
this Go Button and go out and browse
for the Add-Ins that you might need for this.
In this case, we are using this PI BatchView for Excel.
Of course,
in the Learning Lab environment, that's already configured, but if
you needed to find this back home, you would just Browse
and you would find it where you have installed this
BatchView Client, which would be under Program Files, PIPC,
Batch, and you will find these
two different Add-Ins.
You will notice that there are two different
Add-Ins listed there. This is the older
BatchView Add-In Version, 2.x.
This is the newer one. Both them
do ship with the same copy of BatchView, and
when making use of them, what you will notice is
the -- well, the, the newer one actually
invokes two, or supports two different
Add-Ins that appear in your --
this BatchView -- or in this
List of Add-Ins here. So,
adding the newer one is going to result in the BatchView
for Excel in this PIBVExcel.Functions.
You do not need to load that older
PIBat32.xla Add-In, but if you have
got older spreadsheets that make use of it, that's what you
would use in order to have those continue to work.
Now, in an, any event,
I should be able to see that we do have a Batch Search that's available,
and this is what we are going to be using
to search for Batches and then end up
showing Results in the spreadsheet.
Now the place to start
is to open up a template that already has
a lot of the configurations done for you
except for the Batch Elements. So,
I am going to go into the Labs Directory, and within
Labs you will find a template.
This is in Section 2 under
Using BatchView under the Template Directory.
This, this right here, does not solve everything.
It just solves the problem of having
to put all these little, you know, whizzbang little
call-outs and what-not, these parameters, these
dropdown lists, etc. All these things are already done
for you. So, what
we like to do is give you a head-start with this so that you can
concentrate on the important things which are just the BatchView stuff.
This other stuff, like being able to choose
drop-downs, those are just, of course, Excel skills so we are not
really going to go into the detail on how to
configure any of these things here. It's just essentially
window-dressing to make the report look prettier and
be a little bit easier for people to make use of.
Well, so, what,
what am I going to ask you to do in this, in this
particular exercise? Well, I am going to ask you to retrieve
some Batch Results using this BatchView Add-In:
PI, BatchView Search here. So,
we are going to put these Results in Cell A12.
As you can say, it is a bit of a setup here because, you know, the
the rest of this, the -- all the different
calculations are already set up for you. But
again, since those have little to do with Batch, we are not really
concerned about that.