Help with a dashboard

Yahoo Archive
1
Do a BAQ with the main table being Part, then link the part rev table... with an outer join...
Add the criteria to the PartRev table to only show you approved revisions.

Add a filter to the BAQ to only show records where the PartRev.Approved <> true.


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mike Numbers
Sent: Wednesday, December 19, 2012 1:08 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Help with a dashboard



The approved field exists in the PartRev table. So when I link the Part
table to the PartRev table I get a match for each record. In the situation
where I have 5 revisions and 1 is approved, I will get 4 records showing the
part is not approved, when in fact there is an approved revision for the
part. In this situation I don't want to see any records for this part.

Mike

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Marco Vissuet
Sent: Wednesday, December 19, 2012 2:42 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Help with a dashboard

Use the filters, either in the BAQ or Dashboard, to only show parts where
the approved revision doesn't exist.

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
mvissuet@...<mailto:mvissuet%40pacificcontours.com> <mailto:mvissuet%40pacificcontours.com>
<mailto:marcov@...<mailto:marcov%40pacificcontours.com> <mailto:marcov%40pacificcontours.com> >
http://www.pacificcontours.com/

"The information contained herein may be subject to the International
Traffic in Arms Regulations (ITAR) Warning: - This document contains data
whose export is restricted by the Arms Export Control Act (Title 22, U.S.C.,
Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50,
U.S.C., App 2401 et seq.) as amended. Violations of these export laws are
subject to severe criminal and civil penalties. Disseminate in accordance
with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of mike.numbers
Sent: Wednesday, December 19, 2012 11:39 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Help with a dashboard

9.04.507A
I am trying to create a dashboard showing parts on open orders that do not
have an approved revision. For instance, we have revision levels 0 - 4 with
hopefully one of the 5 being approved, or none of the 5 being approved. I
can't figure out a way of showing only the parts where none of the revisions
are approved. I looked to see if there was anything in the BAQ that could
help as well as in the dashboard. All I am coming up with is showing the
item 5 times with maybe one of the lines having the approved checkbox
checked. Anyone have any ideas on how to do this.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
9.04.507A
I am trying to create a dashboard showing parts on open orders that do not have an approved revision. For instance, we have revision levels 0 - 4 with hopefully one of the 5 being approved, or none of the 5 being approved. I can't figure out a way of showing only the parts where none of the revisions are approved. I looked to see if there was anything in the BAQ that could help as well as in the dashboard. All I am coming up with is showing the item 5 times with maybe one of the lines having the approved checkbox checked. Anyone have any ideas on how to do this.
3
Use the filters, either in the BAQ or Dashboard, to only show parts where the approved revision doesn't exist.


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mike.numbers
Sent: Wednesday, December 19, 2012 11:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Help with a dashboard



9.04.507A
I am trying to create a dashboard showing parts on open orders that do not have an approved revision. For instance, we have revision levels 0 - 4 with hopefully one of the 5 being approved, or none of the 5 being approved. I can't figure out a way of showing only the parts where none of the revisions are approved. I looked to see if there was anything in the BAQ that could help as well as in the dashboard. All I am coming up with is showing the item 5 times with maybe one of the lines having the approved checkbox checked. Anyone have any ideas on how to do this.



[Non-text portions of this message have been removed]
4
The approved field exists in the PartRev table. So when I link the Part
table to the PartRev table I get a match for each record. In the situation
where I have 5 revisions and 1 is approved, I will get 4 records showing the
part is not approved, when in fact there is an approved revision for the
part. In this situation I don't want to see any records for this part.



Mike



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Marco Vissuet
Sent: Wednesday, December 19, 2012 2:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Help with a dashboard





Use the filters, either in the BAQ or Dashboard, to only show parts where
the approved revision doesn't exist.

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
mvissuet@... <mailto:mvissuet%40pacificcontours.com>
<mailto:marcov@... <mailto:marcov%40pacificcontours.com> >
http://www.pacificcontours.com/

"The information contained herein may be subject to the International
Traffic in Arms Regulations (ITAR) Warning: - This document contains data
whose export is restricted by the Arms Export Control Act (Title 22, U.S.C.,
Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50,
U.S.C., App 2401 et seq.) as amended. Violations of these export laws are
subject to severe criminal and civil penalties. Disseminate in accordance
with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of mike.numbers
Sent: Wednesday, December 19, 2012 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Help with a dashboard

9.04.507A
I am trying to create a dashboard showing parts on open orders that do not
have an approved revision. For instance, we have revision levels 0 - 4 with
hopefully one of the 5 being approved, or none of the 5 being approved. I
can't figure out a way of showing only the parts where none of the revisions
are approved. I looked to see if there was anything in the BAQ that could
help as well as in the dashboard. All I am coming up with is showing the
item 5 times with maybe one of the lines having the approved checkbox
checked. Anyone have any ideas on how to do this.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]