BAQ's in Vista or Vantage

If you want to run it regularly, you may want to just assign it to a simple
dashboard. Then you can view the data there or easily copy/paste to excel.

On Mon, May 23, 2011 at 12:52 PM, Karen Schoenung <
kschoenung@...> wrote:

>
>
> In Vantage (8.03.409C)
> You can run the query in the BAQ - go to analyze tab, click analyze button
> to check for errors in formulas, then Test button to see results right in
> BAQ - can right click in left of grid to copy all or copy selection to paste
> into Excel...
>
> Or Under Utilities, there is a Business Activity Query Export Process. You
> enter the BAQ name for the Query ID, then CSV for the output format, name
> the file as you wish, put in a text delimiter if you want and check output
> labels...The report will then go to your reports folder for the user running
> the export (mfgsysdata/reports/username).
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of gordon
> Sent: Monday, May 23, 2011 11:46 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ's in Vista or Vantage
>
>
> Does Anybody know how to execute a BAQ in Vista. I can access the phrase
> builder and generate the sql. I can save the query but do not know where to
> go to run the query. Also, how do you export this info into excel?
>
> Thanks
>
> Gordon
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Does Anybody know how to execute a BAQ in Vista. I can access the phrase builder and generate the sql. I can save the query but do not know where to go to run the query. Also, how do you export this info into excel?

Thanks

Gordon
In Vantage (8.03.409C)
You can run the query in the BAQ - go to analyze tab, click analyze button to check for errors in formulas, then Test button to see results right in BAQ - can right click in left of grid to copy all or copy selection to paste into Excel...

Or Under Utilities, there is a Business Activity Query Export Process. You enter the BAQ name for the Query ID, then CSV for the output format, name the file as you wish, put in a text delimiter if you want and check output labels...The report will then go to your reports folder for the user running the export (mfgsysdata/reports/username).

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of gordon
Sent: Monday, May 23, 2011 11:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ's in Vista or Vantage



Does Anybody know how to execute a BAQ in Vista. I can access the phrase builder and generate the sql. I can save the query but do not know where to go to run the query. Also, how do you export this info into excel?

Thanks

Gordon



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