554 Parkside Drive <br>Waterloo, Ontario, Canada<br> N2L 5Z4
+1.866.579.7497
+1.888.240.4866

Six S Partners Online Classroom Training – Advanced BAQ’s and 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 ERP and how together we can help your business. Hope to see you soon!

Loading Events
  • This event has passed.

Six S Partners Online Classroom Training – Advanced BAQ’s and Dashboards « July 9 @ 12:30 pm - 4:30 pm UTC-4

$295
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.

Our BAQ foundations course was a huge sucess and there were many requests to do an ADVANCED course.

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

 

 

 

 

 

Details

Date:
July 9
Time:
12:30 pm - 4:30 pm UTC-4
Cost:
$295

Organizer

Darrin McPhail
Phone:
866-579-7497 x759
Email:
dmcphail@sixspartners.com