This course is designed for anyone who is going to author reports in PowerPlay. The course agenda includes understanding PowerPlay cubes and structures, as well as working with PowerPlay to create reports and graphs. Topics covered include filtering data, sorting, suppressing data, basic calculations, graphing and formatting for printing.
The only prerequisite is that all individuals must be familiar with Windows 95/NT/2000. Ideally, students should be proficient with the techniques of Ctrl clicking, Shift clicking and dragging and dropping.
› Overview of PowerPlay
› Discussion of key terms including
› Dimension
› Level
› Category
› Measure
› PowerPlay Interface
› Techniques for adding rows and columns
› Moving/Deleting categories
› Drilling up/down
› Swapping
› Filtering
› Next level children
› Lowest level children
› Zero suppression
› Sorting and ranking
› Saving your work
› Basic calculations
› Subtraction and addition
› % growth
› Average
› Multiplication and Division
› Basic graphs
› Graph properties
› Multiple graphs
› Formatting
› Blank rows and columns
› Titles, headers and footers
› Page layout mode
› Printing