Can anyone who has upgraded to 8.0 tell me it was worth it?
Did you do it yourself?
Was the support from Epicor helpful?
Did you do it yourself?
Was the support from Epicor helpful?
I have created a dashboard that is accessing the Orderhed table and the
PCinvalue table. I have a configured part that has a top, middle and
bottom color so I want to be able to display those colors on a
dashboard. I have been able to do that but it seems to take about 20
minutes for all the information to display. Does anyone know what I can
do to speed up this process?
Thanks
Dan Ernst
Correct Craft, Inc.
PCinvalue table. I have a configured part that has a top, middle and
bottom color so I want to be able to display those colors on a
dashboard. I have been able to do that but it seems to take about 20
minutes for all the information to display. Does anyone know what I can
do to speed up this process?
Thanks
Dan Ernst
Correct Craft, Inc.
My best suggestion would be to check how you are linking the tables. As a simple example;
Looking for all parts with current open orders
Assumptions: Orderhed as 100 records, Orderdtl has 500 records, 25 open orders.
If you setup Orderdtl as the main table, you will look at all records in Orderdtl, and all records in Orderhed only picking those where Orderhed is open. Therefore, you would have to look at 500 x 100 records.
If you setup Orderhed as the main table, it would first look to see if it was an open order, and, if so, pull the required records. At the very most you would only have to look at 25 x 500 records cutting your search time by ¼. Most likely of those 500 Orderdtl records some would not have to be extracted as they belong to closed orders.
I know this is rudimentary, but is one that still catches me every now and then.
Bruce Butler
IT Manager
Knappe & Koester, Inc.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dan Ernst
Sent: Tuesday, December 12, 2006 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Dashboards - Vantage 8.0
I have created a dashboard that is accessing the Orderhed table and the
PCinvalue table. I have a configured part that has a top, middle and
bottom color so I want to be able to display those colors on a
dashboard. I have been able to do that but it seems to take about 20
minutes for all the information to display. Does anyone know what I can
do to speed up this process?
Thanks
Dan Ernst
Correct Craft, Inc.
[Non-text portions of this message have been removed]
Looking for all parts with current open orders
Assumptions: Orderhed as 100 records, Orderdtl has 500 records, 25 open orders.
If you setup Orderdtl as the main table, you will look at all records in Orderdtl, and all records in Orderhed only picking those where Orderhed is open. Therefore, you would have to look at 500 x 100 records.
If you setup Orderhed as the main table, it would first look to see if it was an open order, and, if so, pull the required records. At the very most you would only have to look at 25 x 500 records cutting your search time by ¼. Most likely of those 500 Orderdtl records some would not have to be extracted as they belong to closed orders.
I know this is rudimentary, but is one that still catches me every now and then.
Bruce Butler
IT Manager
Knappe & Koester, Inc.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dan Ernst
Sent: Tuesday, December 12, 2006 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Dashboards - Vantage 8.0
I have created a dashboard that is accessing the Orderhed table and the
PCinvalue table. I have a configured part that has a top, middle and
bottom color so I want to be able to display those colors on a
dashboard. I have been able to do that but it seems to take about 20
minutes for all the information to display. Does anyone know what I can
do to speed up this process?
Thanks
Dan Ernst
Correct Craft, Inc.
[Non-text portions of this message have been removed]
Can anyone who has upgraded to 8.0 tell me it was worth it?
Did you do it yourself?
Was the support from Epicor helpful?
Did you do it yourself?
Was the support from Epicor helpful?
I am using OrderHed.ordernum to link to PcInValue.ordernum
I have created 3 BAQ for the PcInValue table. Each one is filtered by
the PcInValue.InputName. I have one filtered for topStripe,
MiddleStripe and BottomStripe. It all works but was hoping to have a
faster display of information. Like I said it is taking at least 20
minutes for the information to display.
Thanks
Dan Ernst
Correct Craft, Inc.
I have created 3 BAQ for the PcInValue table. Each one is filtered by
the PcInValue.InputName. I have one filtered for topStripe,
MiddleStripe and BottomStripe. It all works but was hoping to have a
faster display of information. Like I said it is taking at least 20
minutes for the information to display.
Thanks
Dan Ernst
Correct Craft, Inc.
--- In vantage@yahoogroups.com, "Bruce Butler" <bbutler@...> wrote:
>
> My best suggestion would be to check how you are linking the
tables. As a simple example;
>
>
>
> Looking for all parts with current open orders
>
>
>
> Assumptions: Orderhed as 100 records, Orderdtl has 500 records, 25
open orders.
>
>
>
> If you setup Orderdtl as the main table, you will look at all
records in Orderdtl, and all records in Orderhed only picking those
where Orderhed is open. Therefore, you would have to look at 500 x
100 records.
>
>
>
> If you setup Orderhed as the main table, it would first look to see
if it was an open order, and, if so, pull the required records. At
the very most you would only have to look at 25 x 500 records cutting
your search time by ¼. Most likely of those 500 Orderdtl records
some would not have to be extracted as they belong to closed orders.
>
>
>
> I know this is rudimentary, but is one that still catches me every
now and then.
>
>
>
>
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Dan Ernst
> Sent: Tuesday, December 12, 2006 10:19 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Dashboards - Vantage 8.0
>
>
>
> I have created a dashboard that is accessing the Orderhed table and
the
> PCinvalue table. I have a configured part that has a top, middle
and
> bottom color so I want to be able to display those colors on a
> dashboard. I have been able to do that but it seems to take about
20
> minutes for all the information to display. Does anyone know what I
can
> do to speed up this process?
>
> Thanks
>
> Dan Ernst
> Correct Craft, Inc.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Since you are filtering on PcInValue.InputName, you will most likely gain faster results by flipping your link so PcInValue.ordernum is the main table.
Bruce Butler
IT Manager
Knappe & Koester, Inc.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dan Ernst
Sent: Wednesday, December 13, 2006 8:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboards - Vantage 8.0
I am using OrderHed.ordernum to link to PcInValue.ordernum
I have created 3 BAQ for the PcInValue table. Each one is filtered by
the PcInValue.InputName. I have one filtered for topStripe,
MiddleStripe and BottomStripe. It all works but was hoping to have a
faster display of information. Like I said it is taking at least 20
minutes for the information to display.
Thanks
Dan Ernst
Correct Craft, Inc.
Bruce Butler
IT Manager
Knappe & Koester, Inc.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Dan Ernst
Sent: Wednesday, December 13, 2006 8:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Dashboards - Vantage 8.0
I am using OrderHed.ordernum to link to PcInValue.ordernum
I have created 3 BAQ for the PcInValue table. Each one is filtered by
the PcInValue.InputName. I have one filtered for topStripe,
MiddleStripe and BottomStripe. It all works but was hoping to have a
faster display of information. Like I said it is taking at least 20
minutes for the information to display.
Thanks
Dan Ernst
Correct Craft, Inc.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bruce Butler" <bbutler@...> wrote:
>
> My best suggestion would be to check how you are linking the
tables. As a simple example;
>
>
>
> Looking for all parts with current open orders
>
>
>
> Assumptions: Orderhed as 100 records, Orderdtl has 500 records, 25
open orders.
>
>
>
> If you setup Orderdtl as the main table, you will look at all
records in Orderdtl, and all records in Orderhed only picking those
where Orderhed is open. Therefore, you would have to look at 500 x
100 records.
>
>
>
> If you setup Orderhed as the main table, it would first look to see
if it was an open order, and, if so, pull the required records. At
the very most you would only have to look at 25 x 500 records cutting
your search time by ¼. Most likely of those 500 Orderdtl records
some would not have to be extracted as they belong to closed orders.
>
>
>
> I know this is rudimentary, but is one that still catches me every
now and then.
>
>
>
>
>
> Bruce Butler
>
> IT Manager
>
> Knappe & Koester, Inc.
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Dan Ernst
> Sent: Tuesday, December 12, 2006 10:19 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Dashboards - Vantage 8.0
>
>
>
> I have created a dashboard that is accessing the Orderhed table and
the
> PCinvalue table. I have a configured part that has a top, middle
and
> bottom color so I want to be able to display those colors on a
> dashboard. I have been able to do that but it seems to take about
20
> minutes for all the information to display. Does anyone know what I
can
> do to speed up this process?
>
> Thanks
>
> Dan Ernst
> Correct Craft, Inc.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]