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