report studio cookbook
正在加载中...
资料简介：
英文版本。。很专业的
目录：
Table of Contents
Preface 1
Chapter 1: Report Authoring Basic Concepts 7
Introduction 7
Summary filter and detail filter 9
Sorting grouped values 12
Aggregation and rollup aggregation 14
Implementing IF THEN ELSE in filters 16
Data formatting options: Dates, numbers, and percentages 18
Creating sections 21
Hiding column in crosstab 23
Prompts: Display value versus use value 26
Chapter 2: Advanced Report Authoring 31
Introduction 31
Adding a cascaded prompt 32
Creating nested report: Defining master detail relationship 35
Writing back to the database 39
Adding conditional formatting 43
Running difference: Negative values in brackets and red 47
New conditional styling with v8.3 onwards 50
Conditional block: Many reports in one 53
Drill-through from crosstab intersection 57
Overriding crosstab intersection drill-through definition 59
Chapter 3: Tips and Tricks: JavaScripts 61
Introduction 61
Dynamic default value for prompt 62
Changing title of the dropdown box 65
Listbox: Applying Deselect All on rerun 67
ii
Table of Contents
Validating textbox prompts 68
Show/Hide prompt controls at runtime 70
Automatic selection and submission of values 73
Manipulating Date Time control 76
Variable width bar chart using JavaScript 79
Chapter 4: Tips and Tricks: Report Page 83
Introduction 83
Showing images dynamically (Traffic Light report) 84
Handling missing image issue 87
Dynamic links to external website (Google Map example) 90
Alternating drill link 92
Showing tool tip on reports 95
Achieving minimum column width 98
Merged cells in Excel output 100
Worksheet name in Excel output 102
Conditional column titles 104
Chapter 5: XML Editing 107
Introduction 107
Quickly changing drill targets 108
Copy-pasting drill link 113
Removing references to old package and namespaces 117
A hidden gem in XML—row level formatting 119
Chapter 6: Writing Printable Reports 123
Introduction 123
Container size and rows per page 124
Eliminating orphan rows 127
Defining page orientation and size (also override for one page) 128
Avoiding page title repetition 131
Horizontal pagination 134
Choosing output format from prompt 136
Choosing right colors 138
Defining page set 139
Caution about HTML items and JavaScript 141
Chapter 7: Working with Dimensional Models 143
Introduction 143
List report or crosstab report 144
Filtering rows or columns 145
Filtering whole report 148
Adding prompt into slicer and its limitation 150
New feature for zero suppression 152
iii
Table of Contents
Level independent MUN for parent child hierarchy 154
Aggregation versus pre-aggregated values 157
RoleValue() function 159
Swapping dimensions using string manipulation 161
Chapter 8: Macros 165
Introduction 165
Add data level security using CSVIdentityMap macro 166
Using prompt macro in native SQL 168
Making prompt optional 170
Adding token using macro 172
Using prompt and promptmany macros in query subject 174
Showing the prompt values in report based on security 175
String operations to get it right 177
Showing user name in footer 179
Chapter 9: Using Report Studio Better 181
Introduction 181
Report Studio environmental options 182
Copy-pasting partial or full report 187
Copy-pasting whole reports—8.2 to 8.4 possible 189
Setting execution time out 190
Setting maximum rows limit 192
Handle slow report validation 193
Capturing query 195
Browsing values from data expression window 198
Page structure view 201
Pick-up and apply style 202
Grab them all practice 204
Chapter 10: Some More Useful Recipes 207
Introduction 207
Timing report execution 207
Missing value versus zero value 210
Over-riding data formatting defined in database 213
Conditional drill-through 215
Dynamically switching reports using iFrame 217
Chapter 11: Best Practices 223
Introduction 223
Reducing number of query items 223
Highlighting hidden items 228
Relative path for images 229
Taming the JavaScripts 232
iv
Table of Contents
Customize classes for report-wide effect 235
Creating templates 237
Regression testing 239
Code comments 241
Appendix: Recommendations and References 245
Introduction 245
Version controlling 245
Recommendation for prompt types 246
Cognos Mashup Service 247
Third-party tools for Cognos 247
Express Authoring Mode 249
CAFE 249
Cognos Go Office 250
Index 251
目录：
Table of Contents
Preface 1
Chapter 1: Report Authoring Basic Concepts 7
Introduction 7
Summary filter and detail filter 9
Sorting grouped values 12
Aggregation and rollup aggregation 14
Implementing IF THEN ELSE in filters 16
Data formatting options: Dates, numbers, and percentages 18
Creating sections 21
Hiding column in crosstab 23
Prompts: Display value versus use value 26
Chapter 2: Advanced Report Authoring 31
Introduction 31
Adding a cascaded prompt 32
Creating nested report: Defining master detail relationship 35
Writing back to the database 39
Adding conditional formatting 43
Running difference: Negative values in brackets and red 47
New conditional styling with v8.3 onwards 50
Conditional block: Many reports in one 53
Drill-through from crosstab intersection 57
Overriding crosstab intersection drill-through definition 59
Chapter 3: Tips and Tricks: JavaScripts 61
Introduction 61
Dynamic default value for prompt 62
Changing title of the dropdown box 65
Listbox: Applying Deselect All on rerun 67
ii
Table of Contents
Validating textbox prompts 68
Show/Hide prompt controls at runtime 70
Automatic selection and submission of values 73
Manipulating Date Time control 76
Variable width bar chart using JavaScript 79
Chapter 4: Tips and Tricks: Report Page 83
Introduction 83
Showing images dynamically (Traffic Light report) 84
Handling missing image issue 87
Dynamic links to external website (Google Map example) 90
Alternating drill link 92
Showing tool tip on reports 95
Achieving minimum column width 98
Merged cells in Excel output 100
Worksheet name in Excel output 102
Conditional column titles 104
Chapter 5: XML Editing 107
Introduction 107
Quickly changing drill targets 108
Copy-pasting drill link 113
Removing references to old package and namespaces 117
A hidden gem in XML—row level formatting 119
Chapter 6: Writing Printable Reports 123
Introduction 123
Container size and rows per page 124
Eliminating orphan rows 127
Defining page orientation and size (also override for one page) 128
Avoiding page title repetition 131
Horizontal pagination 134
Choosing output format from prompt 136
Choosing right colors 138
Defining page set 139
Caution about HTML items and JavaScript 141
Chapter 7: Working with Dimensional Models 143
Introduction 143
List report or crosstab report 144
Filtering rows or columns 145
Filtering whole report 148
Adding prompt into slicer and its limitation 150
New feature for zero suppression 152
iii
Table of Contents
Level independent MUN for parent child hierarchy 154
Aggregation versus pre-aggregated values 157
RoleValue() function 159
Swapping dimensions using string manipulation 161
Chapter 8: Macros 165
Introduction 165
Add data level security using CSVIdentityMap macro 166
Using prompt macro in native SQL 168
Making prompt optional 170
Adding token using macro 172
Using prompt and promptmany macros in query subject 174
Showing the prompt values in report based on security 175
String operations to get it right 177
Showing user name in footer 179
Chapter 9: Using Report Studio Better 181
Introduction 181
Report Studio environmental options 182
Copy-pasting partial or full report 187
Copy-pasting whole reports—8.2 to 8.4 possible 189
Setting execution time out 190
Setting maximum rows limit 192
Handle slow report validation 193
Capturing query 195
Browsing values from data expression window 198
Page structure view 201
Pick-up and apply style 202
Grab them all practice 204
Chapter 10: Some More Useful Recipes 207
Introduction 207
Timing report execution 207
Missing value versus zero value 210
Over-riding data formatting defined in database 213
Conditional drill-through 215
Dynamically switching reports using iFrame 217
Chapter 11: Best Practices 223
Introduction 223
Reducing number of query items 223
Highlighting hidden items 228
Relative path for images 229
Taming the JavaScripts 232
iv
Table of Contents
Customize classes for report-wide effect 235
Creating templates 237
Regression testing 239
Code comments 241
Appendix: Recommendations and References 245
Introduction 245
Version controlling 245
Recommendation for prompt types 246
Cognos Mashup Service 247
Third-party tools for Cognos 247
Express Authoring Mode 249
CAFE 249
Cognos Go Office 250
Index 251
2010-07-04
页数272
浏览5332
下载98