BAQ Calculated Field Syntax

Yahoo Archive
1
Uh, Dale...you assume Epicor has a QA department....



We are Epicor's QA department....









M. Manasa Reddy

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

www.weldcoa.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Walker, Dale
Sent: Thursday, January 21, 2010 4:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Calculated Field Syntax





Dale - thank you for offering the steps to follow when removing a table
from a BAQ. I normally do most of the steps but missed a couple that you
noted.

Linda - I agree on the "flakey" statement. I used another Query product
on another platform for over two decades and never once had a system
malfunction. Seriously; not one time did I encounter a problem.
Just today I have had at least 4-5 problems while developing BAQs. I
don't know how this stuff gets through Epicor QA.
Sad...real sad...
Dale.

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





[Non-text portions of this message have been removed]
2
Can anyone give me a clue as to what is wrong with this BAQ calculated field syntax?
I am pretty new to this and don't have any documentation to refer to.

If (PartTran.TranType) = "MFG-VAR" Or (PartTran.TranType) = "MFG-CUS" Then TOTAL (PartTran.ExtCost) Else 0

Thx,
Dale.




[cid:image001.jpg@01CA99D5.B70C7090]
Dale Walker
Director, Information Technology
Le Sueur Incorporated
1409 Vine Street
Le Sueur, MN 56058
ph.507.665.6204 x277
fx .507.665.8466

www.lesueurinc.com<http://www.lesueurinc.com>




[Non-text portions of this message have been removed]
3
Dale, I'm assuming that's on a Summarized table in the BAQ?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Walker, Dale
Sent: Wednesday, January 20, 2010 2:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated Field Syntax

Can anyone give me a clue as to what is wrong with this BAQ calculated
field syntax?
I am pretty new to this and don't have any documentation to refer to.

If (PartTran.TranType) = "MFG-VAR" Or (PartTran.TranType) = "MFG-CUS"
Then TOTAL (PartTran.ExtCost) Else 0

Thx,
Dale.




[cid:image001.jpg@01CA99D5.B70C7090]
Dale Walker
Director, Information Technology
Le Sueur Incorporated
1409 Vine Street
Le Sueur, MN 56058
ph.507.665.6204 x277
fx .507.665.8466

www.lesueurinc.com<http://www.lesueurinc.com>




[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/linksYahoo! Groups Links
4
I've never been able to get total to work in a calcuation of a calcualted field. It seems like total has to be the first thing. Try this, I think I got something like this to work:

TOTAL(If (PartTran.TranType) = "MFG-VAR" Or (PartTran.TranType) = "MFG-CUS" Then PartTran.ExtCost Else 0)




________________________________
From: "Walker, Dale" <dwalker@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wed, January 20, 2010 2:37:31 PM
Subject: [Vantage] BAQ Calculated Field Syntax

Â
Can anyone give me a clue as to what is wrong with this BAQ calculated field syntax?
I am pretty new to this and don't have any documentation to refer to.

If (PartTran.TranType) = "MFG-VAR" Or (PartTran.TranType) = "MFG-CUS" Then TOTAL (PartTran.ExtCost) Else 0

Thx,
Dale.

[cid:image001.jpg@ 01CA99D5. B70C7090]
Dale Walker
Director, Information Technology
Le Sueur Incorporated
1409 Vine Street
Le Sueur, MN 56058
ph.507.665.6204 x277
fx .507.665.8466

www.lesueurinc. com<http://www.lesueurinc.com>

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







[Non-text portions of this message have been removed]
5
Yes - PartTran is summarized.


--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Dale, I'm assuming that's on a Summarized table in the BAQ?
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Walker, Dale
> Sent: Wednesday, January 20, 2010 2:38 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ Calculated Field Syntax
>
> Can anyone give me a clue as to what is wrong with this BAQ calculated
> field syntax?
> I am pretty new to this and don't have any documentation to refer to.
>
> If (PartTran.TranType) = "MFG-VAR" Or (PartTran.TranType) = "MFG-CUS"
> Then TOTAL (PartTran.ExtCost) Else 0
>
> Thx,
> Dale.
>
>
>
>
> [cid:image001.jpg@...]
> Dale Walker
> Director, Information Technology
> Le Sueur Incorporated
> 1409 Vine Street
> Le Sueur, MN 56058
> ph.507.665.6204 x277
> fx .507.665.8466
>
> www.lesueurinc.com<http://www.lesueurinc.com>
>
>
>
>
> [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/linksYahoo! Groups Links
>
6
Steven, you're absolutely correct.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Wednesday, January 20, 2010 2:53 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Calculated Field Syntax

I've never been able to get total to work in a calcuation of a calcualted field. It seems like total has to be the first thing. Try this, I think I got something like this to work:

TOTAL(If (PartTran.TranType) = "MFG-VAR" Or (PartTran.TranType) = "MFG-CUS" Then PartTran.ExtCost Else 0)




________________________________
From: "Walker, Dale" <dwalker@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wed, January 20, 2010 2:37:31 PM
Subject: [Vantage] BAQ Calculated Field Syntax

Â
Can anyone give me a clue as to what is wrong with this BAQ calculated field syntax?
I am pretty new to this and don't have any documentation to refer to.

If (PartTran.TranType) = "MFG-VAR" Or (PartTran.TranType) = "MFG-CUS" Then TOTAL (PartTran.ExtCost) Else 0

Thx,
Dale.

[cid:image001.jpg@ 01CA99D5. B70C7090]
Dale Walker
Director, Information Technology
Le Sueur Incorporated
1409 Vine Street
Le Sueur, MN 56058
ph.507.665.6204 x277
fx .507.665.8466

www.lesueurinc. com<http://www.lesueurinc.com>

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







[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/linksYahoo! Groups Links
7
Steven,
Thank you very much. Your suggestion does work. After I changed the syntax I am getting the results I expect.

In order to finish up the BAQ I joined another table and created a new calculated field. I did it wrong so I deleted the summary field and it no longer shows in the "display" tab but the BAQ fails the audit on that very field. Now it is corrupt and will need to start over. AAARRRGGGGGGHHHHHH !!

How often do any of you experience quirky problems while in BAQ creation?
My client locks periodically, sometimes the BAQ doesn't perform as expected and I simply save, close, and reopen it and it works.
When a calculated field is removed from the display tab it changes the names of ALL calculated fields.
Other times I will check the summarized check box only to find that it is unchecked later.
My list of examples goes on and on...

I like the flexibility of the BAQ front end but I have not personally worked with a development tool that is as flakey as this.
What are your experiences?
Do you have the same issues or not?

Please tell me that it is more stable in v9.
Dale.




[cid:image001.jpg@01CA9A70.37BB31F0]
Dale Walker
Director, Information Technology
Le Sueur Incorporated
1409 Vine Street
Le Sueur, MN 56058
ph.507.665.6204 x277
fx .507.665.8466

www.lesueurinc.com<http://www.lesueurinc.com>




[Non-text portions of this message have been removed]
8
Hi Dale,



Yes it is very flakey when you change anything, but then Vantage is the
flakiest piece of software I've ever used.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Walker, Dale
Sent: Thursday, January 21, 2010 9:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Calculated Field Syntax





Steven,
Thank you very much. Your suggestion does work. After I changed the
syntax I am getting the results I expect.

In order to finish up the BAQ I joined another table and created a new
calculated field. I did it wrong so I deleted the summary field and it
no longer shows in the "display" tab but the BAQ fails the audit on that
very field. Now it is corrupt and will need to start over.
AAARRRGGGGGGHHHHHH !!

How often do any of you experience quirky problems while in BAQ
creation?
My client locks periodically, sometimes the BAQ doesn't perform as
expected and I simply save, close, and reopen it and it works.
When a calculated field is removed from the display tab it changes the
names of ALL calculated fields.
Other times I will check the summarized check box only to find that it
is unchecked later.
My list of examples goes on and on...

I like the flexibility of the BAQ front end but I have not personally
worked with a development tool that is as flakey as this.
What are your experiences?
Do you have the same issues or not?

Please tell me that it is more stable in v9.
Dale.

[cid:image001.jpg@01CA9A70.37BB31F0
<mailto:image001.jpg%4001CA9A70.37BB31F0> ]
Dale Walker
Director, Information Technology
Le Sueur Incorporated
1409 Vine Street
Le Sueur, MN 56058
ph.507.665.6204 x277
fx .507.665.8466

www.lesueurinc.com<http://www.lesueurinc.com>

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





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

I experience the same issues when building BAQs. The BAQ has great
potential but... it is as buggy and at times as frustrating as they come. As
much as Epicor pushs and promotes his tool one would think they would take
extra care and precautions in providing a flawless program.



Regarding V9; from what I've seen Epicor made some much needed improvements
on the front end but my bet is it still contains all of those undocumented
features we experience in 8.



You may already do this but thought I would share some precautions and steps
that work for me when removing a table.

Basically I reverse the process but first I make a copy of the BAQ just in
case it crashes and sooner than later... it will. Depending upon it's
complexity I may have two or three different copies I've made at different
times in the process of building it.



1) Remove all Sorts associated with the table

2) Remove all Calculations associated with the table

3) Remove Displayed Column(s) associated with the table

4) Open Phase Builder

5) Remove associated filtering criteria

6) Remove associated Field relations

7) Remove associated Table relations

8) Remove the table

9) Click the Finish Button (for some reason on certain days of the
week it does not like the RED X)

10) Save your work. Close and reopen BAQ. (I know this sounds weird but if
the BAQ is acting particularly flakey that day I will close and reopen it
after saving. I don't get it and maybe it's just me but seems to make a
difference)





Good Luck and May the Force be with you



Dale Dalton

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Walker, Dale
Sent: Thursday, January 21, 2010 8:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Calculated Field Syntax





Steven,
Thank you very much. Your suggestion does work. After I changed the syntax I
am getting the results I expect.

In order to finish up the BAQ I joined another table and created a new
calculated field. I did it wrong so I deleted the summary field and it no
longer shows in the "display" tab but the BAQ fails the audit on that very
field. Now it is corrupt and will need to start over. AAARRRGGGGGGHHHHHH !!

How often do any of you experience quirky problems while in BAQ creation?
My client locks periodically, sometimes the BAQ doesn't perform as expected
and I simply save, close, and reopen it and it works.
When a calculated field is removed from the display tab it changes the names
of ALL calculated fields.
Other times I will check the summarized check box only to find that it is
unchecked later.
My list of examples goes on and on...

I like the flexibility of the BAQ front end but I have not personally worked
with a development tool that is as flakey as this.
What are your experiences?
Do you have the same issues or not?

Please tell me that it is more stable in v9.
Dale.

[cid:image001.jpg@ <mailto:image001.jpg%4001CA9A70.37BB31F0>
01CA9A70.37BB31F0]
Dale Walker
Director, Information Technology
Le Sueur Incorporated
1409 Vine Street
Le Sueur, MN 56058
ph.507.665.6204 x277
fx .507.665.8466

www.lesueurinc.com<http://www.lesueuri <http://www.lesueurinc.com> nc.com>

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





[Non-text portions of this message have been removed]
10
Dale - thank you for offering the steps to follow when removing a table from a BAQ. I normally do most of the steps but missed a couple that you noted.

Linda - I agree on the "flakey" statement. I used another Query product on another platform for over two decades and never once had a system malfunction. Seriously; not one time did I encounter a problem.
Just today I have had at least 4-5 problems while developing BAQs. I don't know how this stuff gets through Epicor QA.
Sad...real sad...
Dale.








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