Can I use a table twice in a BAQ?

Yahoo Archive
1
> I doubt it will work (I tried modifying the xml in early v8 days - lots
> of exceptions), it is not a progress limitation but as Rob says a
> limitation with the query engine that executes the BAQ.

I once had a BAQ go bad and was able to fix it by exporting the BAQ,
modifying the XML, and importing it again. I had deleted a calculated field
in the UI that was keeping the query from running but I saw it was still in
the XML file. I deleted the lines for the calculated field (making sure it
was still well-formed) and imported it. The BAQ came back to life. But this
wasn't a complicated change. I did try to trick the interpreter once by
giving it a hand-crafted Progress statement but it wouldn't load.

Mark W.
2
I'm creating a custom report and BAQ that involves the InvcHead table.
I'm trying to join the customer table. I want to join the customer
table twice. Once to InvcHead.CustNum and once to
InvcHead.SoldToCustNum. Thus getting customer information for the sold
to customer and customer information for the bill to customer.

I know how I would do this in standard SQL, but we have a progress
database and the only way I know how to change a BAQ is with the Phrase
builder. Unless I'm missing something, it looks like I can only join
the customer table once.

Any help is appreciated.

Thanks in advance!
Scott
3
We have had nothing but trouble and total disapoinment with Epicor's
support for OPEN4. The initial install was botched (by Epicor) and
we worked with support for 2 MONTHS in order to get the base module
running. When we tried to enter a new employee it crashed again and
we had a 5 week delay getting support. Now our LAN admin has worked
with support for 6 WEEKS trying to get OPEN4 ESS loaded. I have never
experienced this level of imcompetence from a support organization in
my 20+ years in business.

I have escalated this to our Epicor project manager and his manager
as well. They escalate it within Epicor as I would expect but the
bottom line is that we still have not succeeded with the install of
ESS. We have consumed hundreds of internal hours trying to get OPEN4
loaded when we have already paid Epicor to do the install in the
first place. I just can't seem to get any satisfaction from this
group. Our entire organization has a terrible taste in our mouths
from this experience and we are not even live yet.

Do any of you use OPEN4? Have you had similar experiences? Who at
Epicor must a customer talk to in order to get this terrible support
issue resolved?
Please share experiences.

Dale Walker
Director, IT
LeSueur Inc.
4
Not possible. This is one of the issues all of us have with BAQ. We would all prefer to be able to write our own SQL statements. True, a statement builder is nice but it generally has too many limitations. Maybe someday.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of scottkreel
Sent: Wednesday, August 27, 2008 7:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Can I use a table twice in a BAQ?


I'm creating a custom report and BAQ that involves the InvcHead table.
I'm trying to join the customer table. I want to join the customer
table twice. Once to InvcHead.CustNum and once to
InvcHead.SoldToCustNum. Thus getting customer information for the sold
to customer and customer information for the bill to customer.

I know how I would do this in standard SQL, but we have a progress
database and the only way I know how to change a BAQ is with the Phrase
builder. Unless I'm missing something, it looks like I can only join
the customer table once.

Any help is appreciated.

Thanks in advance!
Scott


________________________________
DISCLAIMER:
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.


[Non-text portions of this message have been removed]
5
Good Morning Everyone,



I was wondering what everyone was doing with their Epicor Procedures.
Has anyone found a way to include them right in the Epicor program or
maybe an intranet?



Thanks in advance for everyone input!



Dale



[Non-text portions of this message have been removed]
6
We use the Epicor provided SharePoint site centralize and house all our
procedures. It has been working well for us. It saved us from having to
do anything to our Intranet site for the time being.


Dave



[Non-text portions of this message have been removed]
7
We also have Open4. We had similar problems in the beginning. The
best guy at epicor that i found to deal with is John Akins. He has
been able to help us with most of our issues. His direct number is
(858) 352-1594. Try that and see what happens.


--- In vantage@yahoogroups.com, "dswmaom" <dwalker@...> wrote:
>
> We have had nothing but trouble and total disapoinment with
Epicor's
> support for OPEN4. The initial install was botched (by Epicor) and
> we worked with support for 2 MONTHS in order to get the base module
> running. When we tried to enter a new employee it crashed again and
> we had a 5 week delay getting support. Now our LAN admin has worked
> with support for 6 WEEKS trying to get OPEN4 ESS loaded. I have
never
> experienced this level of imcompetence from a support organization
in
> my 20+ years in business.
>
> I have escalated this to our Epicor project manager and his manager
> as well. They escalate it within Epicor as I would expect but the
> bottom line is that we still have not succeeded with the install of
> ESS. We have consumed hundreds of internal hours trying to get
OPEN4
> loaded when we have already paid Epicor to do the install in the
> first place. I just can't seem to get any satisfaction from this
> group. Our entire organization has a terrible taste in our mouths
> from this experience and we are not even live yet.
>
> Do any of you use OPEN4? Have you had similar experiences? Who at
> Epicor must a customer talk to in order to get this terrible
support
> issue resolved?
> Please share experiences.
>
> Dale Walker
> Director, IT
> LeSueur Inc.
>
8
No. A table can only be added and joined to others once.
Â
I don't know if this is a forced limitation imposed by the lame BAQ development tool or if it is a fundamental Progress limitation. (Whether you are on SQLserver or Progress db, BAQs are still Progress code).
Â
No support for SQL-like UNIONs within BAQs either. You can however mimic the effect of a UNION by creating a multi BAQ dashboard app that then combines the data using .NET code (multi-array processing and manipulation).
Â
Rob


--- On Wed, 8/27/08, scottkreel <skreel@...> wrote:

From: scottkreel <skreel@...>
Subject: [Vantage] Can I use a table twice in a BAQ?
To: vantage@yahoogroups.com
Date: Wednesday, August 27, 2008, 8:27 PM






I'm creating a custom report and BAQ that involves the InvcHead table.
I'm trying to join the customer table. I want to join the customer
table twice. Once to InvcHead.CustNum and once to
InvcHead.SoldToCust Num. Thus getting customer information for the sold
to customer and customer information for the bill to customer.

I know how I would do this in standard SQL, but we have a progress
database and the only way I know how to change a BAQ is with the Phrase
builder. Unless I'm missing something, it looks like I can only join
the customer table once.

Any help is appreciated.

Thanks in advance!
Scott


















[Non-text portions of this message have been removed]
9
No experience with OPEN4 but plenty of empathy for your frustrating experience with Epicor.

If, after all this time, your OPEN4 problems aren't resolved to make it a viable business solution, all the frustration in the world won't change the fact that it probably won't ever be.

Check your contract details. They typically contain opt out clauses that might enable you to recoup some of the costs and move on to another solution.

Also: Don't be deceived into thinking the EULA shields them entirely from legal action. It sounds like also contracted for SERVICES (likely more expensive than the software). If they failed to provide the contracted services, that is legally actionable if needed.

Rob Brown

--- On Wed, 8/27/08, dswmaom <dwalker@...> wrote:

From: dswmaom <dwalker@...>
Subject: [Vantage] OPEN4 Support
To: vantage@yahoogroups.com
Date: Wednesday, August 27, 2008, 9:32 PM






We have had nothing but trouble and total disapoinment with Epicor's
support for OPEN4. The initial install was botched (by Epicor) and
we worked with support for 2 MONTHS in order to get the base module
running. When we tried to enter a new employee it crashed again and
we had a 5 week delay getting support. Now our LAN admin has worked
with support for 6 WEEKS trying to get OPEN4 ESS loaded. I have never
experienced this level of imcompetence from a support organization in
my 20+ years in business.

I have escalated this to our Epicor project manager and his manager
as well. They escalate it within Epicor as I would expect but the
bottom line is that we still have not succeeded with the install of
ESS. We have consumed hundreds of internal hours trying to get OPEN4
loaded when we have already paid Epicor to do the install in the
first place. I just can't seem to get any satisfaction from this
group. Our entire organization has a terrible taste in our mouths
from this experience and we are not even live yet.

Do any of you use OPEN4? Have you had similar experiences? Who at
Epicor must a customer talk to in order to get this terrible support
issue resolved?
Please share experiences.

Dale Walker
Director, IT
LeSueur Inc.
10
That is a great point Rob. It is hard to imagine that with such a
mess someone from Epicor would not jump in and get this resolved for
them. Especially considering that Epicor themselves were responsible
for install.......

Brian

--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...>
wrote:
>
> No experience with OPEN4 but plenty of empathy for your frustrating
experience with Epicor.
>
> If, after all this time, your OPEN4 problems aren't resolved to
make it a viable business solution, all the frustration in the world
won't change the fact that it probably won't ever be.
>
> Check your contract details. They typically contain opt out clauses
that might enable you to recoup some of the costs and move on to
another solution.
>
> Also: Don't be deceived into thinking the EULA shields them
entirely from legal action. It sounds like also contracted for
SERVICES (likely more expensive than the software). If they failed to
provide the contracted services, that is legally actionable if
needed.
>
> Rob Brown
>
> --- On Wed, 8/27/08, dswmaom <dwalker@...> wrote:
>
> From: dswmaom <dwalker@...>
> Subject: [Vantage] OPEN4 Support
> To: vantage@yahoogroups.com
> Date: Wednesday, August 27, 2008, 9:32 PM
>
>
>
>
>
>
> We have had nothing but trouble and total disapoinment with
Epicor's
> support for OPEN4. The initial install was botched (by Epicor) and
> we worked with support for 2 MONTHS in order to get the base module
> running. When we tried to enter a new employee it crashed again and
> we had a 5 week delay getting support. Now our LAN admin has worked
> with support for 6 WEEKS trying to get OPEN4 ESS loaded. I have
never
> experienced this level of imcompetence from a support organization
in
> my 20+ years in business.
>
> I have escalated this to our Epicor project manager and his manager
> as well. They escalate it within Epicor as I would expect but the
> bottom line is that we still have not succeeded with the install of
> ESS. We have consumed hundreds of internal hours trying to get
OPEN4
> loaded when we have already paid Epicor to do the install in the
> first place. I just can't seem to get any satisfaction from this
> group. Our entire organization has a terrible taste in our mouths
> from this experience and we are not even live yet.
>
> Do any of you use OPEN4? Have you had similar experiences? Who at
> Epicor must a customer talk to in order to get this terrible
support
> issue resolved?
> Please share experiences.
>
> Dale Walker
> Director, IT
> LeSueur Inc.
>
11
Actually, it is "possible" but you would have to export your BAQ, edit
the xml code, and then re-import the BAQ back in. I have not done this
but I wanted to make sure everyone knows this is possible. You never
know when someone is going to have the free time to figure out the xml
and progress code to accomplish this.

-Matt
Fleetwood Fixtures

--- In vantage@yahoogroups.com, Charles Carden <ccarden@...> wrote:
>
> Not possible. This is one of the issues all of us have with BAQ. We
would all prefer to be able to write our own SQL statements. True, a
statement builder is nice but it generally has too many limitations.
Maybe someday.
12
You will have to use ODBC in Crystal to pull in the table again.  This has performance limitations so use it carefully.

--- On Thu, 8/28/08, Charles Carden <ccarden@...> wrote:

From: Charles Carden <ccarden@...>
Subject: RE: [Vantage] Can I use a table twice in a BAQ?
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Date: Thursday, August 28, 2008, 7:05 AM






Not possible. This is one of the issues all of us have with BAQ. We would all prefer to be able to write our own SQL statements. True, a statement builder is nice but it generally has too many limitations. Maybe someday.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of scottkreel
Sent: Wednesday, August 27, 2008 7:27 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Can I use a table twice in a BAQ?

I'm creating a custom report and BAQ that involves the InvcHead table.
I'm trying to join the customer table. I want to join the customer
table twice. Once to InvcHead.CustNum and once to
InvcHead.SoldToCust Num. Thus getting customer information for the sold
to customer and customer information for the bill to customer.

I know how I would do this in standard SQL, but we have a progress
database and the only way I know how to change a BAQ is with the Phrase
builder. Unless I'm missing something, it looks like I can only join
the customer table once.

Any help is appreciated.

Thanks in advance!
Scott

____________ _________ _________ __
DISCLAIMER:
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.

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


















[Non-text portions of this message have been removed]
13
I'll give it a try (on a test db) with a very simple query (to keep the pages and pages of xml to a minimum)... I suspect it isn't that easy.

My sense has been that while Progress may support it, the BAQ interpreter engine in Vantage may not...

I'm no fan of Epicor's software development, but I have a hard time believing they would have purposefully hid such a powerful capability simply to make use of an MS-QUERY Wizard-like table selection control in the Phrase Builder.

The fact that not all Progress keywords are supported in BAQ Calculated fields (and what is supported has definite limits to complexity of formulas) has always made me suspect the base package includes a dumbed down version of the full Progress query engine.

That might have been an Epicor-Progress deal intended to drive customers to buy fully functional tools directly from Progress (if they are needed).

That's not an uncommon strategy in the software biz (and there isn't anything fundamentally deceptive about it)...

Rob Brown

--- On Thu, 8/28/08, matt_rodenbaugh <mattr@...> wrote:

From: matt_rodenbaugh <mattr@...>
Subject: [Vantage] Re: Can I use a table twice in a BAQ?
To: vantage@yahoogroups.com
Date: Thursday, August 28, 2008, 12:21 PM






Actually, it is "possible" but you would have to export your BAQ, edit
the xml code, and then re-import the BAQ back in. I have not done this
but I wanted to make sure everyone knows this is possible. You never
know when someone is going to have the free time to figure out the xml
and progress code to accomplish this.

-Matt
Fleetwood Fixtures

--- In vantage@yahoogroups .com, Charles Carden <ccarden@... > wrote:
>
> Not possible. This is one of the issues all of us have with BAQ. We
would all prefer to be able to write our own SQL statements. True, a
statement builder is nice but it generally has too many limitations.
Maybe someday.
14
I doubt it will work (I tried modifying the xml in early v8 days - lots
of exceptions), it is not a progress limitation but as Rob says a
limitation with the query engine that executes the BAQ.

I had a call logged re this and was told it was planned for v9.



It is not a dumbed down version of the progress query engine. It is the
just the BAQ interpreter desgined to handle the subset development have
chosen.



Regards,

Stephen

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: 29 August 2008 00:09
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Can I use a table twice in a BAQ?



I'll give it a try (on a test db) with a very simple query (to keep the
pages and pages of xml to a minimum)... I suspect it isn't that easy.

My sense has been that while Progress may support it, the BAQ
interpreter engine in Vantage may not...

I'm no fan of Epicor's software development, but I have a hard time
believing they would have purposefully hid such a powerful capability
simply to make use of an MS-QUERY Wizard-like table selection control in
the Phrase Builder.

The fact that not all Progress keywords are supported in BAQ Calculated
fields (and what is supported has definite limits to complexity of
formulas) has always made me suspect the base package includes a dumbed
down version of the full Progress query engine.

That might have been an Epicor-Progress deal intended to drive customers
to buy fully functional tools directly from Progress (if they are
needed).

That's not an uncommon strategy in the software biz (and there isn't
anything fundamentally deceptive about it)...

Rob Brown

--- On Thu, 8/28/08, matt_rodenbaugh <mattr@...
<mailto:mattr%40fleetwoodfixtures.com> > wrote:

From: matt_rodenbaugh <mattr@...
<mailto:mattr%40fleetwoodfixtures.com> >
Subject: [Vantage] Re: Can I use a table twice in a BAQ?
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Date: Thursday, August 28, 2008, 12:21 PM

Actually, it is "possible" but you would have to export your BAQ, edit
the xml code, and then re-import the BAQ back in. I have not done this
but I wanted to make sure everyone knows this is possible. You never
know when someone is going to have the free time to figure out the xml
and progress code to accomplish this.

-Matt
Fleetwood Fixtures

--- In vantage@yahoogroups .com, Charles Carden <ccarden@... > wrote:
>
> Not possible. This is one of the issues all of us have with BAQ. We
would all prefer to be able to write our own SQL statements. True, a
statement builder is nice but it generally has too many limitations.
Maybe someday.





[Non-text portions of this message have been removed]
15
Stephen
Thanks for 'saving me from myself' (wasting even a small amount of precious time on trying an xml edited multi table instance BAQ).
Much appreciated.
Rob


--- On Thu, 8/28/08, Stephen Edginton <stephene@...> wrote:
From: Stephen Edginton <stephene@...>
Subject: RE: [Vantage] Re: Can I use a table twice in a BAQ?
To: vantage@yahoogroups.com
Date: Thursday, August 28, 2008, 7:46 PM











I doubt it will work (I tried modifying the xml in early v8 days - lots

of exceptions), it is not a progress limitation but as Rob says a

limitation with the query engine that executes the BAQ.



I had a call logged re this and was told it was planned for v9.



It is not a dumbed down version of the progress query engine. It is the

just the BAQ interpreter desgined to handle the subset development have

chosen.



Regards,



Stephen



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf

Of Robert Brown

Sent: 29 August 2008 00:09

To: vantage@yahoogroups .com

Subject: Re: [Vantage] Re: Can I use a table twice in a BAQ?



I'll give it a try (on a test db) with a very simple query (to keep the

pages and pages of xml to a minimum)... I suspect it isn't that easy.



My sense has been that while Progress may support it, the BAQ

interpreter engine in Vantage may not...



I'm no fan of Epicor's software development, but I have a hard time

believing they would have purposefully hid such a powerful capability

simply to make use of an MS-QUERY Wizard-like table selection control in

the Phrase Builder.



The fact that not all Progress keywords are supported in BAQ Calculated

fields (and what is supported has definite limits to complexity of

formulas) has always made me suspect the base package includes a dumbed

down version of the full Progress query engine.



That might have been an Epicor-Progress deal intended to drive customers

to buy fully functional tools directly from Progress (if they are

needed).



That's not an uncommon strategy in the software biz (and there isn't

anything fundamentally deceptive about it)...



Rob Brown



--- On Thu, 8/28/08, matt_rodenbaugh <mattr@fleetwoodfixt ures.com

<mailto:mattr% 40fleetwoodfixtu res.com> > wrote:



From: matt_rodenbaugh <mattr@fleetwoodfixt ures.com

<mailto:mattr% 40fleetwoodfixtu res.com> >

Subject: [Vantage] Re: Can I use a table twice in a BAQ?

To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>

Date: Thursday, August 28, 2008, 12:21 PM



Actually, it is "possible" but you would have to export your BAQ, edit

the xml code, and then re-import the BAQ back in. I have not done this

but I wanted to make sure everyone knows this is possible. You never

know when someone is going to have the free time to figure out the xml

and progress code to accomplish this.



-Matt

Fleetwood Fixtures



--- In vantage@yahoogroups .com, Charles Carden <ccarden@... > wrote:

>

> Not possible. This is one of the issues all of us have with BAQ. We

would all prefer to be able to write our own SQL statements. True, a

statement builder is nice but it generally has too many limitations.

Maybe someday.



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