Executive Information Systems and Multi Dimensional Database Basics with SAS/EIS® and SAS/MDDB® Server Software

Duration: 2.0 days CEUs: 1.2

AUDIENCE
This course demonstrates how to use SAS/EIS® and SAS/MDDB® Server oftware for Rapid Application Development. We will teach how to use pre-built objects in SAS/EIS®Software that are designed for multi-dimensional reporting on data, drill down from general to detailed categories, traffic lighting, and critical
success factors. Students will learn how objects in EIS will allow a graph and a table to appear on the same report and how the graph(s) and table(s) automatically update as the data changes.

BENEFITS
Students will be able to:
• Set up multi dimensional databases
• Define Metadata
• Create multi dimensional reports and graphs
• Create an application catalog
• Set up an application in a production environment

PREREQUISITES
Programming I: SAS Essentials course or equivalent understanding.

COURSE TOPICS
Overview
• What is EIS and an MDDB
• Terminology

Setting Up And Registering Metadata
• Setting up the repository
• Adding tables
• Setting up attributes and hierarchies

Defining The Application Database
• What is an application database
• Using existing reporting templates
• Adding items to the database

Creating Multi Dimensional Databases
• Why use the MDDB structure
• How to best summarize data
• Creating the MDDB

Creating MDDB Reports and Graphs
• Multidimensional reports and graphs
• Drill down and expand capabilities
• Subsetting data

Setting Up Menuing and Production Applications
• Linking between applications
• Using configuration and autoexec files
• Using the AF menu builder for password screens and access control
• Setting up desktop shortcuts and shell scripting

The Multidimensional Data Provider Environment
• What is the MDP
• How we set up metadata

Software Used: SAS/EIS®, SAS/GRAPH®Software and the SAS/MDDB® Server.