Six S Partners Customer Online Classroom Training on Advanced BAQ’s & Dashboards



Interested in learning more? Take a look at the schedule of upcoming events we have planned. If you can’t attend an event in person, we regularly host webinars to share our knowledge and experience with Epicor Kinetic ERP and how together we can help your business. Hope to see you soon!

Loading Events
  • This event has passed.

Six S Partners Customer Online Classroom Training on Advanced BAQ’s & Dashboards « February 7 @ 12:00 pm - 3:30 pm EST

Register Here

Six S Partners is pleased to offer Advanced BAQ’s and Dashboard online classroom training.

Need to get information from your ERP system that you can’t find on any reports?  Would you rather have a view tailored to your role in real time instead of a static report?  Need a way to get this data out for further analysis?

Tap into the most valuable tools that came with your Epicor system – Business Activity Query (BAQ) and Dashboards.

This advanced class is designed for users who have already been exposed to BAQ’s and are ready to use Epicor’s built in tools to data mine those hidden secrets.


Agenda includes:

1. Advanced (compound) Criteria
2. Calculated Fields
3. Grouping / Aggregates
4. Advanced Relationships (casting)
5. SubQueries

  • Basics
  • SubQuery Options (Result Set Rows, Top Clause / Distinct / Ties, Offset / Fetch, Subquery type: toplevel and inner, Unions, CTE
  • SubQuery Criteria (Having clause)
  • Pivots
  1. Updatable Queries
  • Overview
  • Column Mapping
  • BPM update (Selecting Business Object, Selecting Tables)
  • Adding BPM logic
  • Advanced BPM Update
  • Actions
  • Add New Record
  • MultiRow Update
  1. Dashboards
  • Overview
  • Trackers / Filters
  • Grid Displays
  • Pub / Sub Functionality
  • Runtime vs. Assembly vs. Kinetic Dashboards




February 7
12:00 pm - 3:30 pm EST


Darrin McPhail
866-579-7497 x759