Selecting records in BAQ and/or Dashboard

system · February 15, 2013, 3:07pm

Call in and reference my Call Number: 3079448ESC

I think this is the same issue you are referring to. They provided a patch to fix the issue. I got the patch back on 11/30/2012.

________________________________
From: brad_boes <bboes@...>
To: vantage@yahoogroups.com
Sent: Friday, February 15, 2013 11:23 AM
Subject: [Vantage] Re: Selecting records in BAQ and/or Dashboard

I will agree with Jose, but be careful. We are on 9.05.700C and a display filter with a calculated field in it will give us erroneous results. We upgraded several weeks ago from 9.05.603 to 9.05.700C and are having to remove these filters to make BAQ's work.

We have a support call in on this and it is a known bug for this level.

We then move the filter to the dashboard or report level as a work around.

FYI

Brad Boes
Metalworks

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Just add a Filter on your Dashboard to look at the Calc Field..
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Fri, Feb 15, 2013 at 11:10 AM, stanchmura <schmura@...> wrote:
>
> > **
> >
> >
> > Hi:
> > Is there a way either in a BAQ or resulting dashboard to select records
> > from a calculated field? e.g. I need to monitor parts on hand that have no
> > associated cost. The calculatd field then is from the part table: Avg labor
> > + Burden + materials + subcontract=Total part cost. I need the
> > BAQ/Dashboard to siplay only those parts with the Total Calculated part
> > cost at 0.
> >
> >Â
> >
>
>
> [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/.%c2%a0
(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/linksYahoo! Groups Links

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

system · February 15, 2013, 11:10am

Hi:
Is there a way either in a BAQ or resulting dashboard to select records from a calculated field? e.g. I need to monitor parts on hand that have no associated cost. The calculatd field then is from the part table: Avg labor + Burden + materials + subcontract=Total part cost. I need the BAQ/Dashboard to siplay only those parts with the Total Calculated part cost at 0.

system · February 15, 2013, 11:12am

Just add a Filter on your Dashboard to look at the Calc Field..

*Jose C Gomez*
*Software Engineer*
*
*
*
*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 Fri, Feb 15, 2013 at 11:10 AM, stanchmura <schmura@...> wrote:

> **
>
>
> Hi:
> Is there a way either in a BAQ or resulting dashboard to select records
> from a calculated field? e.g. I need to monitor parts on hand that have no
> associated cost. The calculatd field then is from the part table: Avg labor
> + Burden + materials + subcontract=Total part cost. I need the
> BAQ/Dashboard to siplay only those parts with the Total Calculated part
> cost at 0.
>
>
>

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

system · February 15, 2013, 11:23am

I will agree with Jose, but be careful. We are on 9.05.700C and a display filter with a calculated field in it will give us erroneous results. We upgraded several weeks ago from 9.05.603 to 9.05.700C and are having to remove these filters to make BAQ's work.

We have a support call in on this and it is a known bug for this level.

We then move the filter to the dashboard or report level as a work around.

FYI

Brad Boes
Metalworks

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Just add a Filter on your Dashboard to look at the Calc Field..
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Fri, Feb 15, 2013 at 11:10 AM, stanchmura <schmura@...> wrote:
>
> > **
> >
> >
> > Hi:
> > Is there a way either in a BAQ or resulting dashboard to select records
> > from a calculated field? e.g. I need to monitor parts on hand that have no
> > associated cost. The calculatd field then is from the part table: Avg labor
> > + Burden + materials + subcontract=Total part cost. I need the
> > BAQ/Dashboard to siplay only those parts with the Total Calculated part
> > cost at 0.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

system · February 15, 2013, 2:57pm

Thanks for the input!

I did attempt that and believe I got the erroneous results Brad mentions.
Without the filter, I could see some of the $0 cost items I was looking for
simply by sorting the column. But when I added the filter to remove the
items with cost > $0, the grid went blank.

Stan

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
brad_boes
Sent: Friday, February 15, 2013 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Selecting records in BAQ and/or Dashboard

I will agree with Jose, but be careful. We are on 9.05.700C and a display
filter with a calculated field in it will give us erroneous results. We
upgraded several weeks ago from 9.05.603 to 9.05.700C and are having to
remove these filters to make BAQ's work.

We have a support call in on this and it is a known bug for this level.

We then move the filter to the dashboard or report level as a work around.

FYI

Brad Boes
Metalworks

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
Gomez wrote:

>
> Just add a Filter on your Dashboard to look at the Calc Field..
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *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 Fri, Feb 15, 2013 at 11:10 AM, stanchmura wrote:
>
> > **
> >
> >
> > Hi:
> > Is there a way either in a BAQ or resulting dashboard to select records
> > from a calculated field? e.g. I need to monitor parts on hand that have

no

> > associated cost. The calculatd field then is from the part table: Avg

labor

> > + Burden + materials + subcontract=Total part cost. I need the
> > BAQ/Dashboard to siplay only those parts with the Total Calculated part
> > cost at 0.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

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