IBM Cognos 10 Report Studio

About the Authors xvi Foreword by Erin Pyka xvii

Preface xviii



Chapter 1 Creating Consumer-Friendly Reports 1

Highlight Selected Text 1

Design 2

Step-by-Step 2

Avoiding Query Macros 10

Design 12

Step-by-Step 13

Complex Crosstab Calculations 20

Design 20

Step-by-Step 21

Summary 24



Chapter 2 Matching the Report to the Analysis 27

The Dashboard 28

Design 28

Step-by-Step 29

Prompting from an Entire Hierarchy 45

Design 45

Step-by-Step 45

Additional Dimensional Functions 58

Design 58

Step-by-Step 59

Master-Detail Report from Two Separate Lists 70

Design 70

Step-by-Step 70

Configuring the Interactive Dashboard 82

Scenario 82

Design 82

Step-by-Step 82

Summary 89



Chapter 3 Understanding the Report Hierarchy 91

Layout Library 91

Design 92

Step-by-Step 92

Using the Layout Library 100

Design 100

Step-by-Step 101

Inheriting Formatting 109

Design 109

Step-by-Step 110

Inheriting Structure 120

Design 120

Step-by-Step 120

Creating the Briefing Book 127

Design 127

Step-by-Step 127

Summary 140



Chapter 4 Overriding the Data Model 141

Creating a Union 142

Design 142

Step-by-Step 143

Joining SQL and Model Queries 156

Design 156

Step-by-Step 157

Summary 172



Chapter 5 Additional Examples 175

Using HTML to Enhance Functionality 176

Final Product 176

Design 176

Step-by-Step 177

Integrating Multiple Queries into a Complex Report 187

Final Product 188

Design 188

Step-by-Step 189

Summary 199



Chapter 6 New Techniques in Version 10 201

Using Active Reports to Replace HTML Code 202

Design 203

Step-by-Step 203

Adding Local Data Sources to Reports 207

Design 207

Step-by-Step 208

New Charting Options and Active Reports 220

Design 220

Step-by-Step 221

Statistical Analysis 247

Design 247

Step-by-Step 249

Summary 268



Index 271