Loading…
2018 Ross SIG Conference has ended
This annual customer conference offers sessions across Ross Special Interest Groups, including the Chemicals, Metals & Natural Products, Food & Beverage, Life Sciences and Services industries. Special Focus Groups revolve around Finance, Technology and Operations. Attendees have the opportunity to meet with Ross product experts, as well as their peers from other customer companies.
Back To Schedule
Thursday, October 18 • 9:45am - 10:35am
Ross & Excel Queries

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

This session will look into how to help your Excel users get their data from the Ross system faster using tools to help optimize their efficiency.

We will be looking at how most basic user defined queries built in Excel MS Query editor are very inefficient. With some basic SQL knowledge, Views/Stored Procedures can be used to create better retrieval for frequently used reports and files. We will also look at some basic tips to help users create their own queries more efficient on their own.

Lastly we will take a quick look at AdHoc Server settings to see if this can help with server memory management for those companies that run a larger amount of external queries.

Speakers
avatar for Alan Katz

Alan Katz

Aptean
KY

Ken Yannitell

Programming Supervisor, Sadler's Smokehouse


Thursday October 18, 2018 9:45am - 10:35am EDT
Ellington Salon C