Are there limitations to adding SQL statements to IQA queries? Do any special syntax rules apply? Should we be able to set a field equal or greater to another field, ie. MemberStatusDate > PaidThru?

As part of our IQA training, we would like to offer the students some useful queries they can take back to the office. Please submit any ideas you may have. Provide a brief description and the criteria, such as joins and parameters. Thanks.

Below is the Course Objectives based on a fresh look at the iMIS Analytics tech support issues.

The class will cover:

 Analytics concepts: data cubes, data marts, and OLAPs
 Architecture of iMIS Analytics installation
 Meeting System Requirements
 Installing iMIS Analytics
 Initial loading of iMIS data into the warehouse
 Securing iMIS Analytics
 Examining pre-defined views in the iMIS Analytics Briefing Book

Analytics Training

Introductory training would cover data cube and analytics concepts and provide a high-level exposure to examining data in a pre-defined data cube using ProClarity.

Advanced training would teach how to install and configure iMIS Analytics, how to extract data from the data warehouse, how to use the Briefing Book, ad hoc queries, and how to put user defined data into data cubes (iMIS Customizer).