Patrick,
You are right on most accounts.
I am not saying that this is the end all of reporting, but many of the
day to day reports that we have are able to be generated as a query.
Using the ASP page, you get filtering and sorting, and then most of my
users that want the reports are very handy in excel and "wish they could
just use excel instead" anyway.
For most of the additional functions, that is what I use Crystal for now
anyway...well except displaying the photo, but I am told that will
change.
My thought was just to turn on some others to the BAQ improvements and
expose some of the more useful features.
I am really starting to like editing the sql statement and the
calculated fields. No totals, but you can do a bunch with just those.
Using the ASP page and office 2002+ the export to excel is a right click
away.
There are also some needed enhancements to allow for scheduling each
export to XML individually instead of having to set a schedule that
refreshes all queries at once, but as a whole, just from 6.0 to 6.1 they
have made some quantum leaps with BAQ.
Aaron
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Thursday, May 27, 2004 9:26 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] BAQ and ASP pages - Email found in
subject
Aaron,
I know epicor is working on improving the BAQ features to aid in
replacing
report builder type stuff. But I'm concerted about doing more than just
sorting data.
The features of Report Builder are below which BAQ can't do:
prepass sorting of calculated fields like percentages for exception
reports
alias table joins
totals on columns
Subtotals
just adding in a calculated field as a new column
running cums
reading the previous() field data
summary reports not displaying record data
conditional printing of band lines
Linking and displaying employee photo's on a report
Calculating Dates used in other calculated fields for sales reports
showing
columns last month, two month ago, etc...
I'm not trying to be all negative here: I would like to move as much as
possible into BAQ so users can eventually in Vantage 8, right click and
move
to a Tracker or even edit data. How nice would that be to tell someone
it's
the same as the report builder report you ran giving you your exception
list
to work on but now we are paperless because you can just right click on
the
entry and lookup or edit information.
On the other hand:
It will be hard for the end user to swallow if I have to say here use
BAQ,
pull it into Excel and work the data yourself.
Patrick Winter
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, May 27, 2004 6:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ and ASP pages
With some help from a list member off line, I was able to learn some
vital
keys that makes this work.
1. Find the two files filterdata.xsl and exports.css in the Vantage
directory (mine were in the UD folder) 2. Copy them to the web where
your
ASP pages reside.
3. If you use formulas to generate numbers inside a BAQ, you will need
to
edit the (filename).xsl file to use a ###,###....format instead of the
x(30)
format (notepad works great for this).
Other than that, this is very useful.
I am finding you can generate basic reports that everyone can use to
slice
the data the way they want with filters and sorting. If you have office
XP
or above, you can rightclick on the grid that is generated in Explorer
and
export it to excel, filtered and sorted. If you are dealing with static
data (last years shipments for example), you can run the query once and
then
users can slice and dice as they like. If the data is dynamic, you can
turn
on the BAQ Process server and have this refresh the queries at preset
intervals.
And the top three reasons I like this:
3. Users don't have to know Report Builder to filter and sort.
2. No Vantage license is used to look at the data (not even ODBC).
1. It's Vantage 8 (Sonoma code name is being dropped) compatible.
So, for anyone that was stressing out about the death of Report Builder,
I
highly encourage you to check out the Business Activity Query in Vantage
6.1.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Aaron Hoyt
Sent: Thursday, May 20, 2004 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ and ASP pages
Is anyone else out there using the Business Activity Query to Generate
XML files and ASP pages to access them?
I have been trying to get this functionality to work as a side project
for the last few days. I can get the XML to generate (in fact the new
process server for automatically generating the XML files is slick).
The ASP file seems to have some rather large faults though. With a
little self taught ASP programming I have managed to get the ASP to
display and sort the data as it should. My major problem is that it
does not filter the data. Is it just me, or are there others having
this problem?
I appreciate any response related to this.
Thank you all,
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 Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=1298mthfs/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085148940/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=447076079>
_____
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/> .
************************************************************************
****
****************************************
This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail
in
error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.
************************************************************************
****
****************************************
[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 Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129eh3u5p/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085750774/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=539936306>
_____
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/> .
********************************************************************************************************************
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.
********************************************************************************************************************
[Non-text portions of this message have been removed]
You are right on most accounts.
I am not saying that this is the end all of reporting, but many of the
day to day reports that we have are able to be generated as a query.
Using the ASP page, you get filtering and sorting, and then most of my
users that want the reports are very handy in excel and "wish they could
just use excel instead" anyway.
For most of the additional functions, that is what I use Crystal for now
anyway...well except displaying the photo, but I am told that will
change.
My thought was just to turn on some others to the BAQ improvements and
expose some of the more useful features.
I am really starting to like editing the sql statement and the
calculated fields. No totals, but you can do a bunch with just those.
Using the ASP page and office 2002+ the export to excel is a right click
away.
There are also some needed enhancements to allow for scheduling each
export to XML individually instead of having to set a schedule that
refreshes all queries at once, but as a whole, just from 6.0 to 6.1 they
have made some quantum leaps with BAQ.
Aaron
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Thursday, May 27, 2004 9:26 AM
To: vantage@yahoogroups.com
Subject: [SPAM] - RE: [Vantage] BAQ and ASP pages - Email found in
subject
Aaron,
I know epicor is working on improving the BAQ features to aid in
replacing
report builder type stuff. But I'm concerted about doing more than just
sorting data.
The features of Report Builder are below which BAQ can't do:
prepass sorting of calculated fields like percentages for exception
reports
alias table joins
totals on columns
Subtotals
just adding in a calculated field as a new column
running cums
reading the previous() field data
summary reports not displaying record data
conditional printing of band lines
Linking and displaying employee photo's on a report
Calculating Dates used in other calculated fields for sales reports
showing
columns last month, two month ago, etc...
I'm not trying to be all negative here: I would like to move as much as
possible into BAQ so users can eventually in Vantage 8, right click and
move
to a Tracker or even edit data. How nice would that be to tell someone
it's
the same as the report builder report you ran giving you your exception
list
to work on but now we are paperless because you can just right click on
the
entry and lookup or edit information.
On the other hand:
It will be hard for the end user to swallow if I have to say here use
BAQ,
pull it into Excel and work the data yourself.
Patrick Winter
-----Original Message-----
From: Aaron Hoyt [mailto:hoyt@...]
Sent: Thursday, May 27, 2004 6:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ and ASP pages
With some help from a list member off line, I was able to learn some
vital
keys that makes this work.
1. Find the two files filterdata.xsl and exports.css in the Vantage
directory (mine were in the UD folder) 2. Copy them to the web where
your
ASP pages reside.
3. If you use formulas to generate numbers inside a BAQ, you will need
to
edit the (filename).xsl file to use a ###,###....format instead of the
x(30)
format (notepad works great for this).
Other than that, this is very useful.
I am finding you can generate basic reports that everyone can use to
slice
the data the way they want with filters and sorting. If you have office
XP
or above, you can rightclick on the grid that is generated in Explorer
and
export it to excel, filtered and sorted. If you are dealing with static
data (last years shipments for example), you can run the query once and
then
users can slice and dice as they like. If the data is dynamic, you can
turn
on the BAQ Process server and have this refresh the queries at preset
intervals.
And the top three reasons I like this:
3. Users don't have to know Report Builder to filter and sort.
2. No Vantage license is used to look at the data (not even ODBC).
1. It's Vantage 8 (Sonoma code name is being dropped) compatible.
So, for anyone that was stressing out about the death of Report Builder,
I
highly encourage you to check out the Business Activity Query in Vantage
6.1.
Aaron Hoyt
Hittite Microwave
-----Original Message-----
From: Aaron Hoyt
Sent: Thursday, May 20, 2004 10:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ and ASP pages
Is anyone else out there using the Business Activity Query to Generate
XML files and ASP pages to access them?
I have been trying to get this functionality to work as a side project
for the last few days. I can get the XML to generate (in fact the new
process server for automatically generating the XML files is slick).
The ASP file seems to have some rather large faults though. With a
little self taught ASP programming I have managed to get the ASP to
display and sort the data as it should. My major problem is that it
does not filter the data. Is it just me, or are there others having
this problem?
I appreciate any response related to this.
Thank you all,
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 Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=1298mthfs/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085148940/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=447076079>
_____
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/> .
************************************************************************
****
****************************************
This e-mail and any files transmitted with it are confidential and
intended
solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail
in
error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC
network
and is subject to archival and review
by someone other than the recipient.
************************************************************************
****
****************************************
[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 Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129eh3u5p/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705007183:HM/EXP=1085750774/A=2128215/R=0/SIG=10se96mf6/*http://
companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=539936306>
_____
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/> .
********************************************************************************************************************
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.
This e-mail message has been swept for the presence of computer viruses.
WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review
by someone other than the recipient.
********************************************************************************************************************
[Non-text portions of this message have been removed]