Course Content
Introduction to Interactive Reporting Studio
- Overview
- Interactive Reporting Studio Features
- How Interactive Reporting Studio Works
- Relational Databases
- Multidimensional Databases
- About Interactive Reporting Documents
- Data Source Connections
- Data Models
- Queries
- Analysis and Reporting
- Turning Data into Information
Getting started with Reporting Studio
- Starting the Interactive Reporting Studio
- Opening and Saving a Sample File
- Looking at a Simple Query
- Viewing Database Tables
- Adding Topics to a Query
- Viewing Results
- Reordering Columns
- Sorting Columns
- Filtering Data
- Calculating Data
- Pivoting Data
- Calculating Totals and Subtotals
- Drilling Down
- Hiding Data
- Adding Color
- Charting Data
- Sorting Charts
- Inserting Text Labels
- Designing Reports
- Creating Smart Reports
- Sorting Columns
- Setting Up a Report Page
Understanding the Reporting Studio Features
- Using the Interactive Reporting Workspace
- Main Menu
- Toolbars
- Section Title / Status Bar
- Command Lines
- Data Layout
- Section / Catalog / Content Pane
- Managing / Maintaining / Saving Documents
- Working with Data Sources
- Exporting Data
- Custom Formulas
- Formatting Text and Other Elements
- Document Properties
- Interactive Reporting Web Client Co-existence
- Interactive Reporting Web Client Mismatches
- Tools Menu Command Reference
Querying Relational Databases
- Using Data Models in the Query Section
- Building Queries
- Query Processing Order
- Building Subqueries
- Derived Tables Rules and Behavior
- Working with Query Section Data
- Estimating Query Size
- Preaggregating Data Using Functions
- Using Stored Procedures
- Importing Data Files
- Setting Data Type Properties
Working with Query Results
- Results Section
- Understanding Data Types
- Enhancing Your Results Set
- Adding Computed Items to Results
- Grouping Columns
- Working with the Results Table
Working with Tables
- Creating Tables
- Tables as a Data Staging Area
- Adding Computed Items
- Grouping Columns
- Applying Data Functions to Tables
- Working with Table Components
Querying Multidimensional Databases
- OLAPQuery Section
- Building OLAP Queries
- OLAPQuery Member and Level Rules
- Specifying a Slicer
- Using OLAPQuery Functions
- Processing OLAP Queries
- Applying Filters
- Setting Drill-through Options
Analyzing Data with Pivot Tables
- Working with Pivot Tables
- Using Data Calculations in Pivot Tables
- Using Weighted Averages
- Pivot Section Aggregation and Surface Values
Charts
- Working with Two-dimensional Charts
- Working with Three-dimensional Bar Charts
- Customizing Chart Properties
Report Designer
- Creating a Custom Report
- Adding Report Groups
- Working with a Report Page
- Using Grids
- Using Multiple Data Sources in a Report
- Creating Smart Reports
- Converting Detail Reports from Versions Earlier than 6
Using Filters
- Server versus Local Filter Processing
- Filtering Queries
- Filtering Results
- Setting Compound Filters
- Setting Variable Filters
- Multiple Filters and the Meta Topic
- The Two-Tier Strategy
Working with Computed Items
- Computing New Data
- Computed Items and Data Functions
- Pivot Options
- Using Functions
- Positioning of Moving Average Results - Trailing and Centered Averages
Applying Sorts
- Simple Sorts
- Complex Sorting
- Complex Sorting in the Query, Results, and Table Sections
- Complex Sorting in Chart, Pivot, and OLAPQuery Reports