Nick,
I do not believe it is possible to bring non epicor tables into a BAQ since
it all runs as progress code. If you had another progress DB you may be able
to but otherwise you are out of luck.
For all the grouping and such you'd want to write a straight forward BAQ and
then use a Dashboard or Crystal Report to do further drill down / grouping.
Although some grouping can be done directly on the BAQ
*Jose C Gomez*
*Software Engineer*
*
*
*CHECK OUT MY NEW BLOG <http://www.usdoingstuff.com> OR CONTACT ME DIRECTLY*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
I do not believe it is possible to bring non epicor tables into a BAQ since
it all runs as progress code. If you had another progress DB you may be able
to but otherwise you are out of luck.
For all the grouping and such you'd want to write a straight forward BAQ and
then use a Dashboard or Crystal Report to do further drill down / grouping.
Although some grouping can be done directly on the BAQ
*Jose C Gomez*
*Software Engineer*
*
*
*CHECK OUT MY NEW BLOG <http://www.usdoingstuff.com> OR CONTACT ME DIRECTLY*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Wed, Jun 1, 2011 at 2:36 PM, Nick <nick@...> wrote:
>
>
> Below is a few questions about BAQs that we have. Any insite would be
> helpful
>
> 1. Can you add new (non-Epicor) tables or views to a BAQ?
> 2. If we want to create something like the table below, how would you go
> about creating the BAQ in terms of getting the aggregates to function
> correctly?
> a. We need to group it by the year in which it was sold and by the
> customer it was sold to and we cannot figure out how to group it both by
> the
> calculated column: year(needbydate) and by the customer number (just doing
> it by customer number is easy of course but when you add the other
> criteria�).
> b. This is a slight oversimplification but it addresses two critical
> questions for us:
> i. How do we use other columns to control groupings?
> ii. How can/Can we use calculated columns to control groupings?
>
> Customer # Customer Name 2009 2010 2011
> 1234 Company A $152,822.56 $346,041.21 $45.41
> 4567 Company B $6,486.13 $12,315.25 $1,216.00
> 9173 Company C $96,413.15 $41,251.01 $7,850.15
>
>
[Non-text portions of this message have been removed]