Baq

Yahoo Archive
1
Thank you!!
2
Ok, so no one uses the ASP page generation in 6.1, I can live with that.
Does anyone use the Business Activity Query in general? I have been
setting up some calculated fields and am looking for pointers on just
what you can do within a calculation. Today I determined that I can use
if...then...else statements within the calculated field, I knew about
column-label from examples that existed before, but I am still trying to
work out the use of format. Any thoughts there?


Aaron Hoyt

Hittite Microwave Corporation




[Non-text portions of this message have been removed]
3
You can do things like:

Part.Character01 + "" format "x(25)" label "Engineer"

Adding the null field (not intuitive) forces it to recognize the format and
label... otherwise you get "character01" as the column heading.

Numeric formats are like ">>>,>>>.99" but there's a bug (SCR 8006) when the
query uses this format on the dashboard. You get ">" instead of the number
in that position.

----- Original Message -----
From: "Aaron Hoyt" <hoyt@...>
To: <vantage@yahoogroups.com>
Sent: Friday, May 21, 2004 10:19 AM
Subject: [Vantage] BAQ


> Ok, so no one uses the ASP page generation in 6.1, I can live with that.
> Does anyone use the Business Activity Query in general? I have been
> setting up some calculated fields and am looking for pointers on just
> what you can do within a calculation. Today I determined that I can use
> if...then...else statements within the calculated field, I knew about
> column-label from examples that existed before, but I am still trying to
> work out the use of format. Any thoughts there?
>
>
> Aaron Hoyt
>
> Hittite Microwave Corporation
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>
4
Thank you Chris,
I will have to add myself to this bug SCR. I thought it was just me
with the number format thing.
Have you tried any programming techniques within the formula like the
if...then...else. I found I could do that little trick by just trying
it. I was wondering if there is any way to get documented just what the
limits are.
Aaron

-----Original Message-----
From: Chris Robisch [mailto:blue.wine@...]
Sent: Friday, May 21, 2004 2:07 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ


You can do things like:

Part.Character01 + "" format "x(25)" label "Engineer"

Adding the null field (not intuitive) forces it to recognize the format
and
label... otherwise you get "character01" as the column heading.

Numeric formats are like ">>>,>>>.99" but there's a bug (SCR 8006) when
the
query uses this format on the dashboard. You get ">" instead of the
number
in that position.

----- Original Message -----
From: "Aaron Hoyt" <hoyt@...>
To: <vantage@yahoogroups.com>
Sent: Friday, May 21, 2004 10:19 AM
Subject: [Vantage] BAQ


> Ok, so no one uses the ASP page generation in 6.1, I can live with
that.
> Does anyone use the Business Activity Query in general? I have been
> setting up some calculated fields and am looking for pointers on just
> what you can do within a calculation. Today I determined that I can
use
> if...then...else statements within the calculated field, I knew about
> column-label from examples that existed before, but I am still trying
to
> work out the use of format. Any thoughts there?
>
>
> Aaron Hoyt
>
> Hittite Microwave Corporation
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
5
You can use Progress documentation... the Business Activity Manager creates
a Progress program to run.

----- Original Message -----
From: "Aaron Hoyt" <hoyt@...>
To: <vantage@yahoogroups.com>
Sent: Friday, May 21, 2004 11:17 AM
Subject: RE: [Vantage] BAQ


> Thank you Chris,
> I will have to add myself to this bug SCR. I thought it was just me
> with the number format thing.
> Have you tried any programming techniques within the formula like the
> if...then...else. I found I could do that little trick by just trying
> it. I was wondering if there is any way to get documented just what the
> limits are.
> Aaron
>
> -----Original Message-----
> From: Chris Robisch [mailto:blue.wine@...]
> Sent: Friday, May 21, 2004 2:07 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BAQ
>
>
> You can do things like:
>
> Part.Character01 + "" format "x(25)" label "Engineer"
>
> Adding the null field (not intuitive) forces it to recognize the format
> and
> label... otherwise you get "character01" as the column heading.
>
> Numeric formats are like ">>>,>>>.99" but there's a bug (SCR 8006) when
> the
> query uses this format on the dashboard. You get ">" instead of the
> number
> in that position.
>
> ----- Original Message -----
> From: "Aaron Hoyt" <hoyt@...>
> To: <vantage@yahoogroups.com>
> Sent: Friday, May 21, 2004 10:19 AM
> Subject: [Vantage] BAQ
>
>
> > Ok, so no one uses the ASP page generation in 6.1, I can live with
> that.
> > Does anyone use the Business Activity Query in general? I have been
> > setting up some calculated fields and am looking for pointers on just
> > what you can do within a calculation. Today I determined that I can
> use
> > if...then...else statements within the calculated field, I knew about
> > column-label from examples that existed before, but I am still trying
> to
> > work out the use of format. Any thoughts there?
> >
> >
> > Aaron Hoyt
> >
> > Hittite Microwave Corporation
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
6
In the business activity query, I am making a calculated field. What
code do I need to write in?

Thanks,
Ben
7
Recently I was creating a new BAQ and my system locket up. When I do a
search for a BAQ the name shows up in the search, but when you select
it no data comes in. I have found that the BAQ data is stored in the
QueryCalcFld, QueryField, QueryLikeRef, QueryRelation,
QueryRelationField, QuearyTable, and QueryWhereItem. Does anyone know
where the system stores the information that the BAQ Search pulls it
information from?

Thanks

Steve
8
Session lock ups during large data set returning BAQ execution is the norm - not the exception. The BAQ is reading the abstract db table views directly. The tables you refer to are simply to hold and store the definition/details of the BAQs themselves.

rmgfelm <vantage@...> wrote: Recently I was creating a new BAQ and my system locket up. When I do a
search for a BAQ the name shows up in the search, but when you select
it no data comes in. I have found that the BAQ data is stored in the
QueryCalcFld, QueryField, QueryLikeRef, QueryRelation,
QueryRelationField, QuearyTable, and QueryWhereItem. Does anyone know
where the system stores the information that the BAQ Search pulls it
information from?

Thanks

Steve






---------------------------------
Never miss a thing. Make Yahoo your homepage.

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



This was a small BAQ. The system has a bug when selecting to view some of
the files in like the repsplit2 in the order detail table it gives an error
message saying that the file can not be found and then disappears from the
selection in the BAQ. This then creates a string of errors and will not let
you save the BAQ. When I tried to delete the BAQ the system locked up and
now when you try to search and select the BAQ it returns the name in the
menu bar, but nothing in the BAQ itself. I removed all the files in the
tables listed below for that BAQ, but you can still see it if you search for
it. There must be one other table with some information the still lists
some information on the BAQ.



I currently have (3) BAQs in this state and was working with one of them to
see if I can clear them out of the system. I am waiting on a patch to fix
the current problem that is reported and listed as fixed in version
8.03.40x, but is still in the 8.03.305 patch level.



Do you know of another table that would go with what I had listed?



Steve



-----Original Message-----
From: Robert Brown [mailto:robertb_versa@...]
Sent: February 26, 2008 3:48 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ



Session lock ups during large data set returning BAQ execution is the norm -
not the exception. The BAQ is reading the abstract db table views directly.
The tables you refer to are simply to hold and store the definition/details
of the BAQs themselves.

rmgfelm <vantage@rmgfelm. <mailto:vantage%40rmgfelm.com> com> wrote:
Recently I was creating a new BAQ and my system locket up. When I do a
search for a BAQ the name shows up in the search, but when you select
it no data comes in. I have found that the BAQ data is stored in the
QueryCalcFld, QueryField, QueryLikeRef, QueryRelation,
QueryRelationField, QuearyTable, and QueryWhereItem. Does anyone know
where the system stores the information that the BAQ Search pulls it
information from?

Thanks

Steve

---------------------------------
Never miss a thing. Make Yahoo your homepage.

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





[Non-text portions of this message have been removed]
10
Can someone tell me what that field "KeyID" is and what does it do on BAQ's
table join screen.

Vantage automatically puts "PartRevAltMethod" in.







[Non-text portions of this message have been removed]
11
The KeyID is what tells the BAQ how different tables coordinate with
each other. For example, if I want to link OrderHed & OrderDtl, the
KeyID field will list something related to OrderNum and in the window
right below you'll see it links Company & OrderNum between both tables.
Thus when a BAQ result from OrderHed for order #1234 shows, the OrderDtl
for that same order comes along.

99% of the time the system will automatically put the proper links in
and you don't have to do anything on this screen (such as you listed
below with it putting PartRevAltMethod). I've created more than a
hundred BAQ's and I can think of only one time I had to manually define
my links.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bill Wu
Sent: Friday, April 25, 2008 7:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ



Can someone tell me what that field "KeyID" is and what does it do on
BAQ's
table join screen.

Vantage automatically puts "PartRevAltMethod" in.

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






[Non-text portions of this message have been removed]
12
Thank you Ken for the answer, let me make sure I understand this correctly.
this KeyID is the key for this specific join that BAQ uses for itself. I do
not need to do anything with it. However, as far as what this key means, I
need to use the field relationship to define the join detail, such as
PartNum from one table equals the partNum in another table, Correct? Because
in a normal SQL join, you don't have this KeyID, that's why I'm confused.



Thanks



Bill



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ken Williams
Sent: Friday, April 25, 2008 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ



The KeyID is what tells the BAQ how different tables coordinate with
each other. For example, if I want to link OrderHed & OrderDtl, the
KeyID field will list something related to OrderNum and in the window
right below you'll see it links Company & OrderNum between both tables.
Thus when a BAQ result from OrderHed for order #1234 shows, the OrderDtl
for that same order comes along.

99% of the time the system will automatically put the proper links in
and you don't have to do anything on this screen (such as you listed
below with it putting PartRevAltMethod). I've created more than a
hundred BAQ's and I can think of only one time I had to manually define
my links.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Bill Wu
Sent: Friday, April 25, 2008 7:06 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BAQ

Can someone tell me what that field "KeyID" is and what does it do on
BAQ's
table join screen.

Vantage automatically puts "PartRevAltMethod" in.

[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]
13
The key is the same as the index fields common to both tables. They are
very important for how the query selects the records and how efficient the
query runs.


Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com <http://www.maxsonautomatic.com/>



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Bill Wu
Sent: Friday, April 25, 2008 11:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ



Thank you Ken for the answer, let me make sure I understand this correctly.
this KeyID is the key for this specific join that BAQ uses for itself. I do
not need to do anything with it. However, as far as what this key means, I
need to use the field relationship to define the join detail, such as
PartNum from one table equals the partNum in another table, Correct? Because
in a normal SQL join, you don't have this KeyID, that's why I'm confused.

Thanks

Bill

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Ken Williams
Sent: Friday, April 25, 2008 9:25 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] BAQ

The KeyID is what tells the BAQ how different tables coordinate with
each other. For example, if I want to link OrderHed & OrderDtl, the
KeyID field will list something related to OrderNum and in the window
right below you'll see it links Company & OrderNum between both tables.
Thus when a BAQ result from OrderHed for order #1234 shows, the OrderDtl
for that same order comes along.

99% of the time the system will automatically put the proper links in
and you don't have to do anything on this screen (such as you listed
below with it putting PartRevAltMethod). I've created more than a
hundred BAQ's and I can think of only one time I had to manually define
my links.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Bill Wu
Sent: Friday, April 25, 2008 7:06 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BAQ

Can someone tell me what that field "KeyID" is and what does it do on
BAQ's
table join screen.

Vantage automatically puts "PartRevAltMethod" in.

[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]






[Non-text portions of this message have been removed]
14
The KeyID, I believe, is a shortcut to a predefined join. Check the
Dataset Relationships entry (I think I created a shortcut to it directly
under System Management, I can't remember where it was by default).

So think of it as a shortcut to the normal joins you're used to.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bill Wu
Sent: Friday, April 25, 2008 9:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ



Thank you Ken for the answer, let me make sure I understand this
correctly.
this KeyID is the key for this specific join that BAQ uses for itself. I
do
not need to do anything with it. However, as far as what this key means,
I
need to use the field relationship to define the join detail, such as
PartNum from one table equals the partNum in another table, Correct?
Because
in a normal SQL join, you don't have this KeyID, that's why I'm
confused.

Thanks

Bill

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ken Williams
Sent: Friday, April 25, 2008 9:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] BAQ

The KeyID is what tells the BAQ how different tables coordinate with
each other. For example, if I want to link OrderHed & OrderDtl, the
KeyID field will list something related to OrderNum and in the window
right below you'll see it links Company & OrderNum between both tables.
Thus when a BAQ result from OrderHed for order #1234 shows, the OrderDtl
for that same order comes along.

99% of the time the system will automatically put the proper links in
and you don't have to do anything on this screen (such as you listed
below with it putting PartRevAltMethod). I've created more than a
hundred BAQ's and I can think of only one time I had to manually define
my links.

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Bill Wu
Sent: Friday, April 25, 2008 7:06 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BAQ

Can someone tell me what that field "KeyID" is and what does it do on
BAQ's
table join screen.

Vantage automatically puts "PartRevAltMethod" in.

[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]






[Non-text portions of this message have been removed]
15
I can not see ECOMtl.MtlPartNumPartDescription, ECOMtl.OpDesc fields
on BAQ that I created, however I am able to see those in Customization
mode in Engineering Workbench application. Other fields seems to be
alright yet I can retrieve information I needed. Anyone encountered
this before?


TIA
16
BAQ's work on the actual tables.



Customization land / UI work on datasets which are in effect views of
the tables.

i.e. they contain descriptions auxiliary related information and
calculated fields generated from the business layer accessing the
tables, it's a level of abstraction.



You need to create the required relationships and calculations to
recreate the required items in your baq.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of empedole
Sent: 04 September 2008 21:32
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ



I can not see ECOMtl.MtlPartNumPartDescription, ECOMtl.OpDesc fields
on BAQ that I created, however I am able to see those in Customization
mode in Engineering Workbench application. Other fields seems to be
alright yet I can retrieve information I needed. Anyone encountered
this before?

TIA





[Non-text portions of this message have been removed]
17
The views you see in applications in developer mode are just that: views (not necessarily the 'real' tables accessible via BAQs).

Check you application view fields using data tools to see what it is "like"... That might give you a hint as to where the data really resides (and where you can get to it from a BAQ).

Rob

--- On Thu, 9/4/08, empedole <empedole@...> wrote:

From: empedole <empedole@...>
Subject: [Vantage] BAQ
To: vantage@yahoogroups.com
Date: Thursday, September 4, 2008, 4:32 PM






I can not see ECOMtl.MtlPartNumPa rtDescription, ECOMtl.OpDesc fields
on BAQ that I created, however I am able to see those in Customization
mode in Engineering Workbench application. Other fields seems to be
alright yet I can retrieve information I needed. Anyone encountered
this before?

TIA
18
Hi,

I created a BAQ to mimic Time Phase The reason is customer service wanted a
Dashboard to view price breaks and availability of parts and PO promise
date.



I got everything to work except when you add a second PO for the same part
it shows the second line but does not give the running total of all PO to
that part number.

Code I used is :

(PartWhse.OnHandQty - PartWhse.AllocQty + PODetail.OrderQty)



Best regards,

Ennio Verderese





[Non-text portions of this message have been removed]
19
I created a BAQ to mimic Time Phase The reason is customer service wanted a
Dashboard to view price breaks and availability of parts and PO promise
date.

I got everything to work except when you add a second PO for the same part
it shows the second line but does not give the running total of all PO to
that part number.

Code I used is :

(PartWhse.OnHandQty - PartWhse.AllocQty + PODetail.OrderQty)

Best regards,

Ennio Verderese





[Non-text portions of this message have been removed]
20
I am trying to create a BAQ that adds all the cost of a part and then
multiplies that total by the on hand qty. The formula below is not working,
what am I doing wrong, thanks in advance.

Part.AvgMaterialCost + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost * PartBin.OnhandQty
Paul Smith
Inventory Management
233 Ballston Ave
Saratoga Springs NY, 12866
518-245-4358



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