During this instructor-led two-part course, you'll learn to summarize data in your views, in Host Tables, and dynamic Client Tables. Learn how to use the SQL UNION operator to combine the results of two or more SELECT clauses. Get more out of your dates values with alternatives to standard aging. Discover the Excel Add-in, a secure and powerful way to deliver data. Learn how to create dashboards, a great way to present information.
Topics covered include:
- Creating and controlling summary levels using Group By
- Building result columns using Aggregate Functions
- Controlling summary record selection with Having
- Analyzing supporting data with Dynamic Regroup & Show Details
- Compare dates with the DURATION function and aging in years, months and days
- Delivering cross-tab summary information with Sequel Host Tables
- Dynamically deliver summary results with Client Tables (pivot, drill-down, and more)
- Viewpoint MS Excel add-in
- Merging file data with UNION
- Information delivery in a dashboard
Who Should Attend
The class is designed for Sequel Viewpoint users who need more than the basics of view building.
Prerequisites
- A high-speed Internet connection
- A screen resolution of 1024 x 768 or higher
- Current version of Sequel installed on your IBM i
- Current version of Sequel Viewpoint installed on your PC
- Viewpoint design authority
- Access to Viewpoint during class for hands-on exercises
- Authority to create class objects during class for hands-on experience
- An IBM i user library where class objects can be saved
- Access to the all objects in the SEQUELEX library from Viewpoint
Environment Prerequisites:
- A high-speed Internet connection
- A screen resolution of 1024 x 768 or higher
- Current version of Sequel installed on your IBM i
- Current version of Sequel Viewpoint installed on your PC
- Viewpoint design authority
- Access to Viewpoint during class for hands-on exercises
- Authority to create class objects during class for hands-on experience
- An IBM i user library where class objects can be saved
- Access to all objects in the SEQUELEX library from Viewpoint
Knowledge/Experience Prerequisites:
- Sequel Viewpoint Level 1: Getting Started course (formerly Basic Sequel Viewpoint)
- Comfortable building views in the Viewpoint View Designer’s Files & Fields tab
- A clear grasp of the basic Sequel clauses (SELECT, FROM, ORDER BY, WHERE & JOIN)
- Knowledge of field conversion (number to date) with the CVTDATE function
This class follows a blended approach to learning that includes:
- Presentation and live demonstrations
- Hands-on activities on your own system
- Participant interaction with trainers during sessions
Registration is required at least 72 hours before the class. You can cancel your registration up to 72 hours before the class without penalty. No-shows will be billed.
Instructors
Brandy Lulling, Associate Support Manager: Brandy is responsible for Sequel, Esend, Sequel Web Interface, Abstract, Anydate, Sequel Data Warehouse, or Showcase. She has held several roles in support, providing training, and assisting prospective customers while being at Fortra for over 18 years.
Rich Galeba, Sr. Support Analyst: Rich is responsible for Sequel, Esend, Sequel Web Interface, Abstract, Sequel Data Warehouse or Showcase. He has been a support analyst, product training specialist, and project management consultant at Fortra for over 20 years.
Jackie Daugherty, Sr. Support Analyst: Jackie has been offering exceptional customer service and attention to detail for over 12 years at Fortra. Her passion is turning frustrated or anxious customers into calm and informed users of our products.