ShowCase™ Warehouse Manager

Audience: Information systems staff and database administrators of the ShowCase™ products

Topics:

• Managing Licenses
• Managing Resources and controlling users by setting limit on interactive and batch processing
• Creating and Managing Aliases for libraries, files and fields as well as row level security
• Creating data views for end user ease and performance efficiency

ShowCase™ Query

Audience: End users

Topics:

• Basic Query building concepts
• Batch Processing
• Database join concepts
• Variable and prompt usage
• Formatting Data
• Using Query with alternate viewers such as Excel, HTML and Adobe Acrobat
• Linking Queries to Excel with Spreadsheet Reporting feature
• Basic SQL functions and operators and creation of new columns

ShowCase™ Report Writer

Audience: Query users only

Topics:

• Intro to Report Writer interface
• Basic of Reports and types
• Columnar Report
• Cross-tab Report
• Form Report
• Label Report
• Basic Derived Fields & Macros