# Business Entelligence Queries
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-01-17 10:26 UTC
**Views:** 478
**Replies:** 7
**URL:** https://www.epiusers.help/t/business-entelligence-queries/1956
---
## Post #1 by @system
Keith, this is the all the code and still no luck with the spaces.
The last line is the code that is giving the error message
Bob Scrimsher
ymd(LaborDtl.PayrollDate) format "x(10)" column-label "Dimension
Payroll Date"
fiscal(LaborDtl.PayrollDate) format "x(7)" column-label "Dimension
Fiscal Payroll Date"
LaborDtl.WCCode column-label "Dimension Workcenter"
WrkCenter.Plant column-label "Dimension Plant"
LaborDtl.LaborType column-label "Dimension Labor Type"
LaborDtl.ExpenseCode column-label "Dimension Expense Code"
WrkCenter.JCDept column-label "Dimension Department"
LaborHed.Shift column-label "Dimension Shift"
EmpBasic.SupervisorId column-label "Dimension Supervisor"
LaborDtl.EarnedHrs format "->>,>>9.99" column-label "Fact Earned
Hours"
LaborDtl.BurdenHrs format "->>,>>9.99" column-label "Fact Total Burden
Hours"
LaborDtl.LaborHrs format "->>,>>9.99" column-label "Fact Total Labor
Hours"
WrkCenter.ProdBurRate format "$->>>,>>>,>>>,>>9.99" column-label "Fact
Burden Rate"
(if not LaborDtl.Rework and not LaborDtl.AddedOper then
LaborDtl.BurdenHrs else 0) format "->>,>>9.99" column-label "Fact
Burden Hours"
(if LaborDtl.Rework then LaborDtl.BurdenHrs else 0) format
"->>,>>9.99" column-label "Fact Rework Hours"
(if LaborDtl.AddedOper then LaborDtl.BurdenHrs else 0) format
"->>,>>9.99" column-label "Fact Added Operation Hours"
(if LaborDtl.LaborType <> 'I':U then LaborDtl.LaborHrs else 0) format
"->>,>>9.99" column-label "Fact Direct Hours"
(if LaborDtl.LaborType = 'I':U then LaborDtl.LaborHrs else 0) format
"->>,>>9.99" column-label "Fact Indirect Hours"
0 format "->>9.99%" column-label "Calculation Efficiency % (Earned
Hours/Burden Hours)"
0 format "->>9.99%" column-label "Calculation Performance % (Earned
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Coverage % (Burden
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Rework % (Rework
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Added Operation % (Added
Operation Hours/Total Burden Hours)"
0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
(Burden Rate * Total Burden Hours)"
--- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> You need a space before and after the math symbol
>
> Keith E. Taylor
> Vice President
> LBSi
> Business Systems Consultants (Progress based ERP packages)
> 216/476-1416 ext 26
> keith@l...
>
> -----Original Message-----
> From: scrimsher_robert_b@c...
[mailto:scrimsher_robert_b@c...]
> Sent: Tuesday, January 16, 2001 11:16 AM
> To: vantage@egroups.com
> Subject: [Vantage] Re: Business Entelligence Queries
>
> 0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
> (Burden Rate*Total Burden Hours)"
>
>
> --- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> > What is your exact formula calculation?
> >
> > Keith E. Taylor
> > Vice President
> > LBSi
> > Business Systems Consultants (Progress based ERP packages)
> > 216/476-1416 ext 26
> > keith@l...
> >
> > -----Original Message-----
> > From: scrimsher_robert_b@c...
> [mailto:scrimsher_robert_b@c...]
> > Sent: Tuesday, January 16, 2001 8:54 AM
> > To: vantage@egroups.com
> > Subject: [Vantage] Re: Business Entelligence Queries
> >
> > Keith, thanks for the reply, when I try to refresh the data set I
> get
> > an error the format of the calulated field is invalid. using the
> > asterisk.
> >
> > Bob Scrimsher
> >
> >
> >
> > --- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> > > You hit it on the head...multiple is the * symbol (asterisk). If
> > you
> > are
> > > referring to Report builder help (Progress) it is on line
> > www.progress.com
> > > or available by CD that I think Epicor provides with the
software.
> > >
> > > Keith E. Taylor
> > > Vice President
> > > LBSi
> > > Business Systems Consultants (Progress based ERP packages)
> > > 216/476-1416 ext 26
> > > keith@l...
> > >
> > > -----Original Message-----
> > > From: scrimsher_robert_b@c...
> > [mailto:scrimsher_robert_b@c...]
> > > Sent: Tuesday, January 16, 2001 8:06 AM
> > > To: vantage@egroups.com
> > > Subject: [Vantage] Business Entelligence Queries
> > >
> > > Hi all, We have just started working with the enterprise
business
> > > system and the help available on the canned help screens is not
> much
> > > help. I am seeking information on how to write the queries. Is
> the
> > > any external information that's available? I have written
several
> > > queries and can not seem to mulitply using * x or any other
letter
> > or
> > > number or symbol. has anyone had this problem.
> > >
> > > Bob Scrimsher
> > > "CAT"
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > vantage-unsubscribe@egroups.com
> >
> >
> > To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@egroups.com
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
Hi all, We have just started working with the enterprise business
system and the help available on the canned help screens is not much
help. I am seeking information on how to write the queries. Is the
any external information that's available? I have written several
queries and can not seem to mulitply using * x or any other letter or
number or symbol. has anyone had this problem.
Bob Scrimsher
"CAT"
---
## Post #3 by @system
You hit it on the head...multiple is the * symbol (asterisk). If you are
referring to Report builder help (Progress) it is on line www.progress.com
or available by CD that I think Epicor provides with the software.
Keith E. Taylor
Vice President
LBSi
Business Systems Consultants (Progress based ERP packages)
216/476-1416 ext 26
keith@...
-----Original Message-----
From:
scrimsher_robert_b@... [mailto:
scrimsher_robert_b@...]
Sent: Tuesday, January 16, 2001 8:06 AM
To:
vantage@egroups.com
Subject: [Vantage] Business Entelligence Queries
Hi all, We have just started working with the enterprise business
system and the help available on the canned help screens is not much
help. I am seeking information on how to write the queries. Is the
any external information that's available? I have written several
queries and can not seem to mulitply using * x or any other letter or
number or symbol. has anyone had this problem.
Bob Scrimsher
"CAT"
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.comKeith, thanks for the reply, when I try to refresh the data set I get
an error the format of the calulated field is invalid. using the
asterisk.
Bob Scrimsher
--- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> You hit it on the head...multiple is the * symbol (asterisk). If
you
are
> referring to Report builder help (Progress) it is on line
www.progress.com
> or available by CD that I think Epicor provides with the software.
>
> Keith E. Taylor
> Vice President
> LBSi
> Business Systems Consultants (Progress based ERP packages)
> 216/476-1416 ext 26
> keith@l...
>
> -----Original Message-----
> From: scrimsher_robert_b@c...
[mailto:scrimsher_robert_b@c...]
> Sent: Tuesday, January 16, 2001 8:06 AM
> To: vantage@egroups.com
> Subject: [Vantage] Business Entelligence Queries
>
> Hi all, We have just started working with the enterprise business
> system and the help available on the canned help screens is not much
> help. I am seeking information on how to write the queries. Is the
> any external information that's available? I have written several
> queries and can not seem to mulitply using * x or any other letter
or
> number or symbol. has anyone had this problem.
>
> Bob Scrimsher
> "CAT"
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
What is your exact formula calculation?
Keith E. Taylor
Vice President
LBSi
Business Systems Consultants (Progress based ERP packages)
216/476-1416 ext 26
keith@...
-----Original Message-----
From:
scrimsher_robert_b@... [mailto:
scrimsher_robert_b@...]
Sent: Tuesday, January 16, 2001 8:54 AM
To:
vantage@egroups.com
Subject: [Vantage] Re: Business Entelligence Queries
Keith, thanks for the reply, when I try to refresh the data set I get
an error the format of the calulated field is invalid. using the
asterisk.
Bob Scrimsher
--- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> You hit it on the head...multiple is the * symbol (asterisk). If
you
are
> referring to Report builder help (Progress) it is on line
www.progress.com
> or available by CD that I think Epicor provides with the software.
>
> Keith E. Taylor
> Vice President
> LBSi
> Business Systems Consultants (Progress based ERP packages)
> 216/476-1416 ext 26
> keith@l...
>
> -----Original Message-----
> From: scrimsher_robert_b@c...
[mailto:scrimsher_robert_b@c...]
> Sent: Tuesday, January 16, 2001 8:06 AM
> To: vantage@egroups.com
> Subject: [Vantage] Business Entelligence Queries
>
> Hi all, We have just started working with the enterprise business
> system and the help available on the canned help screens is not much
> help. I am seeking information on how to write the queries. Is the
> any external information that's available? I have written several
> queries and can not seem to mulitply using * x or any other letter
or
> number or symbol. has anyone had this problem.
>
> Bob Scrimsher
> "CAT"
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
(Burden Rate*Total Burden Hours)"
--- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> What is your exact formula calculation?
>
> Keith E. Taylor
> Vice President
> LBSi
> Business Systems Consultants (Progress based ERP packages)
> 216/476-1416 ext 26
> keith@l...
>
> -----Original Message-----
> From: scrimsher_robert_b@c...
[mailto:scrimsher_robert_b@c...]
> Sent: Tuesday, January 16, 2001 8:54 AM
> To: vantage@egroups.com
> Subject: [Vantage] Re: Business Entelligence Queries
>
> Keith, thanks for the reply, when I try to refresh the data set I
get
> an error the format of the calulated field is invalid. using the
> asterisk.
>
> Bob Scrimsher
>
>
>
> --- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> > You hit it on the head...multiple is the * symbol (asterisk). If
> you
> are
> > referring to Report builder help (Progress) it is on line
> www.progress.com
> > or available by CD that I think Epicor provides with the software.
> >
> > Keith E. Taylor
> > Vice President
> > LBSi
> > Business Systems Consultants (Progress based ERP packages)
> > 216/476-1416 ext 26
> > keith@l...
> >
> > -----Original Message-----
> > From: scrimsher_robert_b@c...
> [mailto:scrimsher_robert_b@c...]
> > Sent: Tuesday, January 16, 2001 8:06 AM
> > To: vantage@egroups.com
> > Subject: [Vantage] Business Entelligence Queries
> >
> > Hi all, We have just started working with the enterprise business
> > system and the help available on the canned help screens is not
much
> > help. I am seeking information on how to write the queries. Is
the
> > any external information that's available? I have written several
> > queries and can not seem to mulitply using * x or any other letter
> or
> > number or symbol. has anyone had this problem.
> >
> > Bob Scrimsher
> > "CAT"
> >
> >
> > To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@egroups.com
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
Haven't worked with EBI yet (just turned it on). Can't tell from the
formula below but if EBI is as picky as Report Builder a space on each side
of the * might help. RB crabs regularly if I don't put spaces in formulas.
-Todd C.
-----Original Message-----
From:
scrimsher_robert_b@... [mailto:
scrimsher_robert_b@...]
Sent: Tuesday, January 16, 2001 10:16 AM
To:
vantage@egroups.com
Subject: [Vantage] Re: Business Entelligence Queries
0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
(Burden Rate*Total Burden Hours)"
--- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> What is your exact formula calculation?
>
> Keith E. Taylor
> Vice President
> LBSi
> Business Systems Consultants (Progress based ERP packages)
> 216/476-1416 ext 26
> keith@l...
>
> -----Original Message-----
> From: scrimsher_robert_b@c...
[mailto:scrimsher_robert_b@c...]
> Sent: Tuesday, January 16, 2001 8:54 AM
> To: vantage@egroups.com
> Subject: [Vantage] Re: Business Entelligence Queries
>
> Keith, thanks for the reply, when I try to refresh the data set I
get
> an error the format of the calulated field is invalid. using the
> asterisk.
>
> Bob Scrimsher
>
>
>
> --- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> > You hit it on the head...multiple is the * symbol (asterisk). If
> you
> are
> > referring to Report builder help (Progress) it is on line
> www.progress.com
> > or available by CD that I think Epicor provides with the software.
> >
> > Keith E. Taylor
> > Vice President
> > LBSi
> > Business Systems Consultants (Progress based ERP packages)
> > 216/476-1416 ext 26
> > keith@l...
> >
> > -----Original Message-----
> > From: scrimsher_robert_b@c...
> [mailto:scrimsher_robert_b@c...]
> > Sent: Tuesday, January 16, 2001 8:06 AM
> > To: vantage@egroups.com
> > Subject: [Vantage] Business Entelligence Queries
> >
> > Hi all, We have just started working with the enterprise business
> > system and the help available on the canned help screens is not
much
> > help. I am seeking information on how to write the queries. Is
the
> > any external information that's available? I have written several
> > queries and can not seem to mulitply using * x or any other letter
> or
> > number or symbol. has anyone had this problem.
> >
> > Bob Scrimsher
> > "CAT"
> >
> >
> > To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@egroups.com
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
eGroups Sponsor
<http://rd.yahoo.com/M=169066.1281467.2883016.2/D=egroupmail/S=1700007183:N/
A=560404/*http://cgi.timeinc.net/cgi-bin/magsubs/cc/subs/ecompanynowcc1?EFFO
RTKEY=ECAAQP3> Click Here!
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com
[Non-text portions of this message have been removed]
You need a space before and after the math symbol
Keith E. Taylor
Vice President
LBSi
Business Systems Consultants (Progress based ERP packages)
216/476-1416 ext 26
keith@...
-----Original Message-----
From:
scrimsher_robert_b@... [mailto:
scrimsher_robert_b@...]
Sent: Tuesday, January 16, 2001 11:16 AM
To:
vantage@egroups.com
Subject: [Vantage] Re: Business Entelligence Queries
0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
(Burden Rate*Total Burden Hours)"
--- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> What is your exact formula calculation?
>
> Keith E. Taylor
> Vice President
> LBSi
> Business Systems Consultants (Progress based ERP packages)
> 216/476-1416 ext 26
> keith@l...
>
> -----Original Message-----
> From: scrimsher_robert_b@c...
[mailto:scrimsher_robert_b@c...]
> Sent: Tuesday, January 16, 2001 8:54 AM
> To: vantage@egroups.com
> Subject: [Vantage] Re: Business Entelligence Queries
>
> Keith, thanks for the reply, when I try to refresh the data set I
get
> an error the format of the calulated field is invalid. using the
> asterisk.
>
> Bob Scrimsher
>
>
>
> --- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> > You hit it on the head...multiple is the * symbol (asterisk). If
> you
> are
> > referring to Report builder help (Progress) it is on line
> www.progress.com
> > or available by CD that I think Epicor provides with the software.
> >
> > Keith E. Taylor
> > Vice President
> > LBSi
> > Business Systems Consultants (Progress based ERP packages)
> > 216/476-1416 ext 26
> > keith@l...
> >
> > -----Original Message-----
> > From: scrimsher_robert_b@c...
> [mailto:scrimsher_robert_b@c...]
> > Sent: Tuesday, January 16, 2001 8:06 AM
> > To: vantage@egroups.com
> > Subject: [Vantage] Business Entelligence Queries
> >
> > Hi all, We have just started working with the enterprise business
> > system and the help available on the canned help screens is not
much
> > help. I am seeking information on how to write the queries. Is
the
> > any external information that's available? I have written several
> > queries and can not seem to mulitply using * x or any other letter
> or
> > number or symbol. has anyone had this problem.
> >
> > Bob Scrimsher
> > "CAT"
> >
> >
> > To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@egroups.com
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com