BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Six S Partners - ECPv6.16.4.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Six S Partners
X-ORIGINAL-URL:https://www.sixspartners.com
X-WR-CALDESC:Events for Six S Partners
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Halifax
BEGIN:DAYLIGHT
TZOFFSETFROM:-0400
TZOFFSETTO:-0300
TZNAME:ADT
DTSTART:20190310T060000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0300
TZOFFSETTO:-0400
TZNAME:AST
DTSTART:20191103T050000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0400
TZOFFSETTO:-0300
TZNAME:ADT
DTSTART:20200308T060000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0300
TZOFFSETTO:-0400
TZNAME:AST
DTSTART:20201101T050000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0400
TZOFFSETTO:-0300
TZNAME:ADT
DTSTART:20210314T060000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0300
TZOFFSETTO:-0400
TZNAME:AST
DTSTART:20211107T050000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Halifax:20200709T123000
DTEND;TZID=America/Halifax:20200709T163000
DTSTAMP:20200630T135308Z
CREATED:20200630T135308Z
LAST-MODIFIED:20200630T135308Z
UID:14106-1594297800-1594312200@www.sixspartners.com
SUMMARY:Six S Partners Online Classroom Training - Advanced BAQ's and Dashboards
DESCRIPTION:Six S Partners is pleased to offer Advanced BAQ’s and Dashboard online classroom training. \nNeed 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? \nTap into the most valuable tools that came with your Epicor system – Business Activity Query (BAQ) and Dashboards. \nOur BAQ foundations course was a huge sucess and there were many requests to do an ADVANCED course. \nThis 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. \nAgenda includes: \n1. Advanced (compound) Criteria\n2. Calculated Fields\n3. Grouping / Aggregates\n4. Advanced Relationships (casting)\n5. SubQueries \n\nBasics\nSubQuery Options (Result Set Rows\, Top Clause / Distinct / Ties\, Offset / Fetch\, Subquery type: toplevel and inner\, Unions\, CTE\nSubQuery Criteria (Having clause)\nPivots\n\n\nUpdatable Queries\n\n\nOverview\nColumn Mapping\nBPM update (Selecting Business Object\, Selecting Tables)\nAdding BPM logic\nAdvanced BPM Update\nActions\nAdd New Record\nMultiRow Update\n\n  \n  \n  \n  \n 
URL:https://www.sixspartners.com/event/six-s-partners-online-classroom-training-advanced-baqs-and-dashboards/
ATTACH;FMTTYPE=image/jpeg:https://www.sixspartners.com/wp-content/uploads/2020/04/Classroom-training.jpg
ORGANIZER;CN="Darrin McPhail":MAILTO:dmcphail@sixspartners.com
END:VEVENT
END:VCALENDAR