6.1 BAQ-Dashboard questions

Yahoo Archive
1
Hi Lydia,



Todd Caughey posted some information, back on September 9, that I believe
may be very useful to you. I've appended it to this message; hope it helps!



Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.531



-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Thursday, October 27, 2005 8:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.1 BAQ-Dashboard questions



Lydia,
The only resource I am aware of for "advanced" features of the BAQ is here
or Progress Help.
Progress help needs to be taken with a grain of salt when it comes to BAQ
(not so with BAM). You will look up functions in progress help and see how
they apply to Progress vs. Report Builder. For instance...
Progress help on "Today Function":

SYNTAX

TODAY

EXAMPLE ....

rptdate = TODAY.

So, you can use it just as is, but not from the wizard as I am sure you have
noticed.
Something like invoicedate >= Today - 30.
invoicedate would need to be the table.field you are comparing to, but I am
in a hurry so I skipped looking that up in the dictionary.
Good luck.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lydia Coffman
Sent: Wednesday, October 26, 2005 6:52 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 6.1 BAQ-Dashboard questions

So, here I am, fresh from Perspectives, newly upgraded to 6.1 and boy, do I
have questions...

Having been a long-time Report Builder user, and facing the reality of its
loss, I'm trying to move some of my more common RBs into BAQ-Dashboard
entries...however, I haven't used the BAQ very much, so rather than bother
you all over and over with my more common problems, is there someplace to
look for info on how to build those BAQ's? The basics of adding the fields
and all I get, it's just the replacements for filters and sorts that I'm
more than a little vague about.

For example, I want to make a query that shows me all the invoices created
this month -- easy with RB filters, how do I find the syntax for that query?
Besides asking the list each time. The "Exporting the System Data: Writing
Queries" offers the most basic items.

Is there a book, or list of the built in functions (like TODAY)? Tech
support has lots of great documents, but I just want to do this stuff.
Report builder has good help -- not so much here. What I found in Progress
help was mostly, well, not helpful.

Hep, please!!!

Thanks,
Lydia

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, September 09, 2005 6:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 6.1 - Business-Activity-Query Question



General linking suggestions - not sure if they will help but you do have a
pretty complicated string of links:
1. Start with smallest table possible and link towards larger tables (so
company first)
2. Try not to have branched links when possible
3. Use every field possible in which ever index you are using - use primary
index when possible
4. Use fields in linking in the order they occur within the index

All of these will help. Another technique is, if you have it, to use Report
Builder and create a simple report in it then the SQL it creates by doing
Ctrl-Alt-P and then F12. Not the same syntax exactly as BAQ but it can give
you a good head start and (when using the rules above) it will do a decent
job of optimizing the SQL part.

-Todd C.

-----Original Message-----
From: Jim Feetterer [mailto:jfeetterer@...]
Sent: Friday, September 09, 2005 4:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 - Business-Activity-Query Question

Help,

I am relatively new to SQL/Business-Activity-Query and need to create a
spreadsheet containing all quotes received on the current day.

I created the following SQL which ran in 2 - 3 minutes but then the user
requested the contact name be added. I added the additional logic
(highlighted in red below) to get the contact-name and now it runs for
45 minutes (ouch).

Does any one have suggestions on how to improve the run time or
streamline this query?

Thanks,
Jim Feetterer
Morgan Bronze





[Non-text portions of this message have been removed]
2
So, here I am, fresh from Perspectives, newly upgraded to 6.1 and boy, do I
have questions...

Having been a long-time Report Builder user, and facing the reality of its
loss, I'm trying to move some of my more common RBs into BAQ-Dashboard
entries...however, I haven't used the BAQ very much, so rather than bother
you all over and over with my more common problems, is there someplace to
look for info on how to build those BAQ's? The basics of adding the fields
and all I get, it's just the replacements for filters and sorts that I'm
more than a little vague about.

For example, I want to make a query that shows me all the invoices created
this month -- easy with RB filters, how do I find the syntax for that query?
Besides asking the list each time. The "Exporting the System Data: Writing
Queries" offers the most basic items.

Is there a book, or list of the built in functions (like TODAY)? Tech
support has lots of great documents, but I just want to do this stuff.
Report builder has good help -- not so much here. What I found in Progress
help was mostly, well, not helpful.

Hep, please!!!

Thanks,
Lydia
3
Lydia,
The only resource I am aware of for "advanced" features of the BAQ is here
or Progress Help.
Progress help needs to be taken with a grain of salt when it comes to BAQ
(not so with BAM). You will look up functions in progress help and see how
they apply to Progress vs. Report Builder. For instance...
Progress help on "Today Function":

SYNTAX

TODAY

EXAMPLE ....

rptdate = TODAY.

So, you can use it just as is, but not from the wizard as I am sure you have
noticed.
Something like invoicedate >= Today - 30.
invoicedate would need to be the table.field you are comparing to, but I am
in a hurry so I skipped looking that up in the dictionary.
Good luck.
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lydia Coffman
Sent: Wednesday, October 26, 2005 6:52 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 6.1 BAQ-Dashboard questions


So, here I am, fresh from Perspectives, newly upgraded to 6.1 and boy, do I
have questions...

Having been a long-time Report Builder user, and facing the reality of its
loss, I'm trying to move some of my more common RBs into BAQ-Dashboard
entries...however, I haven't used the BAQ very much, so rather than bother
you all over and over with my more common problems, is there someplace to
look for info on how to build those BAQ's? The basics of adding the fields
and all I get, it's just the replacements for filters and sorts that I'm
more than a little vague about.

For example, I want to make a query that shows me all the invoices created
this month -- easy with RB filters, how do I find the syntax for that query?
Besides asking the list each time. The "Exporting the System Data: Writing
Queries" offers the most basic items.

Is there a book, or list of the built in functions (like TODAY)? Tech
support has lots of great documents, but I just want to do this stuff.
Report builder has good help -- not so much here. What I found in Progress
help was mostly, well, not helpful.

Hep, please!!!

Thanks,
Lydia





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