Dashboard woes

Epicor ERP 10
,
1

Hey

I have created a new dashboard (like many others) but this one isnt playing…

The BAQ doesnt have a filter as i need to set between 2 dates. The BAQ is based on the LaborHed & LaborDtl looking at all rows by payroll date. I want to filter at dashboard level to select 2 dates and see only that data but…

When i load the dashboard, its trying to retrieve ALL of the data first and thats taking about 5-10 mins depending on network traffic because there are 1000’s of rows. I dont want it to do that, im happy for the dashboard to load blank, allowing me to set the dates to retrieve what i want but i cant find how to do that…

In the BAQ i created 2 calculated fields of the date so i can use them for the From / To which seems to work after the initial massive data dump.

Is there way to either stop the initial data retrieval or use the tracker dates on load instead?

Thanks

2

Set up a tracker for your two date fields. Set the tracker as criteria required.

3

Or, in Kinetic(?), change the trigger on erp-baq event to blank.

Create new button control and then set its on-click event to call the erp-baq event via event-next. That way it won’t make the baq call until after you’ve set your date range fields.

You can also add a condition in the event to make sure the date range fields are populated prior to allowing the erp-baq to fire.

2 Likes
4

thanks for replying

i did that and it still went through the complete data retrieval ending in an error Execution Timeout Expired…

By using the Criteria Required, do i also need to add back the parameters in the BAQ?

Thanks

1 Like