I don't know if this is available in Vista 8.03.403x but is availabe
in Vantage 8.03.403x. They are called Executive Queries. I have one
that summarizes all LaborDtl just so I can get at a summary total of
Scrap reported in MES; as there is no other place to get at it
without pulling in 50+ labor transactions for one operation.
The Executive Queries summarizes the details by a two dimension
level. You can have many summary two dimensions built within one
Executive Query. The only downfall is you have to run it as a
Process Set; which can really slow down the system during operations
if the level of summarizing is done against a large dataset (like
LaborDtl) over a large timeframe.
Hope this helps.
Patty Buechler
in Vantage 8.03.403x. They are called Executive Queries. I have one
that summarizes all LaborDtl just so I can get at a summary total of
Scrap reported in MES; as there is no other place to get at it
without pulling in 50+ labor transactions for one operation.
The Executive Queries summarizes the details by a two dimension
level. You can have many summary two dimensions built within one
Executive Query. The only downfall is you have to run it as a
Process Set; which can really slow down the system during operations
if the level of summarizing is done against a large dataset (like
LaborDtl) over a large timeframe.
Hope this helps.
Patty Buechler
--- In vantage@yahoogroups.com, Thomas Rose <t.rose@...> wrote:
>
> Vista 8.03.403D
>
> There are some BAQ's I write that, unavoidably, return huge
recordsets. For example, I am pulling together information from the
order detail table, the order header table, the customer table, the
invoice detail table, the invoice header table, the cash detail
table, the part table, the shipment detail table, the shipment header
table, and the sales rep table. This is to give me a fairly
comprehensive view of order statuses on one report. If the BAQ tool
had been designed by anyone with half a lick of sense, I would have
been able to include BAQ's in a BAQ so I could summarize certain data
before it gets included in my master query (!@#$%&). There are a
couple of alternatives when I go to create my Crystal report:
>
> 1. Use ODBC. This would be great except I have been unable to get
this to function in my environment (I'm going to keep working on it,
though).
> 2. Refer to multiple BAQ's as the source for my Crystal report. It
should be easy enough to add the additional BAQ's to my Crystal
report. The problem, I think, is getting the required BAQ's to all
be regenerated when I run the report.
>
> So, my question is, can I get Vista/Vantage to generate ALL the
BAQ's needed for a report, not just one BAQ that the system thinks is
the source for the report? To follow on to that, apparently there is
a mechanism where Vista/Vantage passes the identity of the newly
generated BAQ (XML?) to Crystal for the report. I don't understand
exactly how that mechanism works, but I assume I would have to also
pass those hooks to Crystal in addition to generating all the
required BAQ's. How would I do that?
>
> Thom Rose
> Controller
> Electric Mirror, LLC
> T 425 776-4946 ext. 1024
> A 11831 Beverly Park Road, Building D, Everett, WA 98204 USA
> www.electricmirror.com<http://www.electricmirror.com/>
>
>
> [Non-text portions of this message have been removed]
>