舉報 
會員
IBM Cognos 10 Report Studio Cookbook（Second Edition）
Ahmed Lashin Abhishek Sanghani 著
更新時間：2021-08-06 17:03:57
開會員，本書免費讀 >
最新章節：
Index
ThisCookbookcontainsstep-by-stepinstructionsforReportStudio10.1userstoauthoreffectivereports.Thebookisdesignedinawaythatyoucanrefertoitchapterbychapter,lookatthelistofrecipesandreadtheminnoparticularorder.TheCognos10.1ReportStudioCookbookisforyouifyouareaBusinessIntelligenceDeveloperwhoisworkingonIBMCognos10ReportStudioandwantstoauthorimpressivereportsbyputtingtousewhatthistoolhastooffer.ItisalsoidealyouareaBusinessAnalystorPowerUserwhoauthorshisownreportsandwantstolookbeyondtheconventionalfeaturesofIBMCognos10ReportStudio.ThisbookassumesthatyouarefamiliarwiththearchitectureofIBMCognos10.YoushouldalsohavebasicknowledgeofIBMCognosReportStudioandcandothebasicreportauthoringtasks.
最新章節
- Index
- IBM Cognos Cloud
- IBM Cognos Workspace Advanced
- IBM Cognos Workspace
- IBM Cognos for Microsoft Office
- IBM Cognos Analysis For Excel (CAFE)
品牌：中圖公司
上架時間：2021-08-06 16:20:45
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-08-06 17:03:57
- IBM Cognos Cloud
- IBM Cognos Workspace Advanced
- IBM Cognos Workspace
- IBM Cognos for Microsoft Office
- IBM Cognos Analysis For Excel (CAFE)
- SDK and third-party tools for Cognos
- Cognos Mashup Service
- Recommendations for prompt types
- Version controlling
- Introduction
- Appendix A. Recommendations and References
- Enabling a larger worksheet size for Excel 2007
- Naming data containers (lists crosstabs and charts) for use in Cognos Workspace
- Commenting the code
- Regression testing
- Creating templates
- Customizing classes for report-wide effect
- Controlling JavaScript file execution
- Using relative paths for images
- Highlighting hidden items
- Reducing the number of query items
- Introduction
- Chapter 13. Best Practices
- Freezing column titles
- Dynamically switching between reports using an iFrame
- Setting up conditional drill-throughs
- Overriding data formatting using patterns
- Missing values versus zero values
- Timing report execution
- Introduction
- Chapter 12. More Useful Recipes
- Getting started with scatter charts
- Getting started with bullet charts
- Working with pie charts
- Converting a chart to another chart type
- Chart formatting options
- Introduction
- Chapter 11. Charts and New Chart Features
- Filtering data using Data Check Box Group
- Working with the Data Deck
- Working with Decks
- Building tabbed reports
- Introduction
- Chapter 10. Working with Active Reports
- Using Default Data Formats
- Using the "grab them all" practice
- Picking up and applying styles
- Viewing the page structure
- Browsing values from the data expression window
- Capturing a query
- Handling slow report validation
- Setting the maximum row limit
- Setting the execution timeout
- Upgrading report specifications
- Copying and pasting partial or full reports
- Using Report Studio's environmental options
- Introduction
- Chapter 9. Using Report Studio Efficiently
- Showing a username in the footer
- String operations to get it right
- Showing the prompt values in a report based on security
- Using the prompt() and promptmany() macros in query subjects
- Adding a token using macros
- Making prompts optional
- Using the Prompt macro in native SQL
- Adding data-level security using the CSVIdentityMap macro
- Introduction
- Chapter 8. Working with Macros
- Swapping dimensions using MUN manipulation
- The roleValue() function
- Aggregation versus preaggregated values
- Achieving zero suppression
- Adding a prompt into Slicer and its limitations
- Filtering a whole report
- Filtering rows or columns
- List report or crosstab report
- Introduction
- Chapter 7. Working with Dimensional Models
- Displaying the report name in a footer
- Cautions about HTML items and JavaScript files
- Defining page sets
- Choosing the right colors
- Choosing the output format from a prompt
- Page numbering with horizontal pagination
- Horizontal pagination
- Avoiding page title repetition
- Defining page orientation and size (and overriding them for one page)
- Eliminating orphan rows
- Controlling the container size and rows per page
- Introduction
- Chapter 6. Writing Printable Reports
- A hidden gem in XML – row level formatting
- Removing references to old packages or items
- Copying and pasting drill links
- Changing drill targets quickly
- Introduction
- Chapter 5. Working with XML
- Conditional column titles
- Worksheet name in Excel output
- Merged cells in Excel output
- Showing tooltips on reports
- Alternating drill links
- Dynamic links to an external website (a Google Maps example)
- Handling the missing image issue
- Showing images dynamically (traffic light report)
- Introduction
- Chapter 4. The Report Page – Tips and Tricks
- Creating a variable width bar chart using JavaScript
- Manipulating the Date Time control
- Selecting and submitting values automatically
- Showing/hiding prompt controls at runtime
- Validating textbox prompts
- Changing the title of the value prompt
- Defining dynamic default values for prompts
- Introduction
- Chapter 3. Using JavaScript Files – Tips and Tricks
- Overriding crosstab intersection drill-through definitions
- Defining drill-through from crosstab intersection
- Using conditional blocks – many reports in one
- Playing with conditional styles
- Formatting negative values
- Adding conditional formatting
- Writing back to the database
- Creating a nested report – defining the master-detail relationship
- Adding cascaded prompts
- Introduction
- Chapter 2. Advanced Report Authoring
- Prompts – display value versus use value
- Hiding columns in crosstabs
- Creating sections
- Formatting data – dates numbers and percentages
- Implementing if-then-else in filters
- Aggregation and rollup aggregation
- Sorting grouped values
- Summary filters and detail filters
- Introduction
- Chapter 1. Report Authoring Basic Concepts
- Preface
- www.PacktPub.com
- About the Reviewers
- About the Authors
- Credits
- 版權信息
- 封面
- 封面
- 版權信息
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- Chapter 1. Report Authoring Basic Concepts
- Introduction
- Summary filters and detail filters
- Sorting grouped values
- Aggregation and rollup aggregation
- Implementing if-then-else in filters
- Formatting data – dates numbers and percentages
- Creating sections
- Hiding columns in crosstabs
- Prompts – display value versus use value
- Chapter 2. Advanced Report Authoring
- Introduction
- Adding cascaded prompts
- Creating a nested report – defining the master-detail relationship
- Writing back to the database
- Adding conditional formatting
- Formatting negative values
- Playing with conditional styles
- Using conditional blocks – many reports in one
- Defining drill-through from crosstab intersection
- Overriding crosstab intersection drill-through definitions
- Chapter 3. Using JavaScript Files – Tips and Tricks
- Introduction
- Defining dynamic default values for prompts
- Changing the title of the value prompt
- Validating textbox prompts
- Showing/hiding prompt controls at runtime
- Selecting and submitting values automatically
- Manipulating the Date Time control
- Creating a variable width bar chart using JavaScript
- Chapter 4. The Report Page – Tips and Tricks
- Introduction
- Showing images dynamically (traffic light report)
- Handling the missing image issue
- Dynamic links to an external website (a Google Maps example)
- Alternating drill links
- Showing tooltips on reports
- Merged cells in Excel output
- Worksheet name in Excel output
- Conditional column titles
- Chapter 5. Working with XML
- Introduction
- Changing drill targets quickly
- Copying and pasting drill links
- Removing references to old packages or items
- A hidden gem in XML – row level formatting
- Chapter 6. Writing Printable Reports
- Introduction
- Controlling the container size and rows per page
- Eliminating orphan rows
- Defining page orientation and size (and overriding them for one page)
- Avoiding page title repetition
- Horizontal pagination
- Page numbering with horizontal pagination
- Choosing the output format from a prompt
- Choosing the right colors
- Defining page sets
- Cautions about HTML items and JavaScript files
- Displaying the report name in a footer
- Chapter 7. Working with Dimensional Models
- Introduction
- List report or crosstab report
- Filtering rows or columns
- Filtering a whole report
- Adding a prompt into Slicer and its limitations
- Achieving zero suppression
- Aggregation versus preaggregated values
- The roleValue() function
- Swapping dimensions using MUN manipulation
- Chapter 8. Working with Macros
- Introduction
- Adding data-level security using the CSVIdentityMap macro
- Using the Prompt macro in native SQL
- Making prompts optional
- Adding a token using macros
- Using the prompt() and promptmany() macros in query subjects
- Showing the prompt values in a report based on security
- String operations to get it right
- Showing a username in the footer
- Chapter 9. Using Report Studio Efficiently
- Introduction
- Using Report Studio's environmental options
- Copying and pasting partial or full reports
- Upgrading report specifications
- Setting the execution timeout
- Setting the maximum row limit
- Handling slow report validation
- Capturing a query
- Browsing values from the data expression window
- Viewing the page structure
- Picking up and applying styles
- Using the "grab them all" practice
- Using Default Data Formats
- Chapter 10. Working with Active Reports
- Introduction
- Building tabbed reports
- Working with Decks
- Working with the Data Deck
- Filtering data using Data Check Box Group
- Chapter 11. Charts and New Chart Features
- Introduction
- Chart formatting options
- Converting a chart to another chart type
- Working with pie charts
- Getting started with bullet charts
- Getting started with scatter charts
- Chapter 12. More Useful Recipes
- Introduction
- Timing report execution
- Missing values versus zero values
- Overriding data formatting using patterns
- Setting up conditional drill-throughs
- Dynamically switching between reports using an iFrame
- Freezing column titles
- Chapter 13. Best Practices
- Introduction
- Reducing the number of query items
- Highlighting hidden items
- Using relative paths for images
- Controlling JavaScript file execution
- Customizing classes for report-wide effect
- Creating templates
- Regression testing
- Commenting the code
- Naming data containers (lists crosstabs and charts) for use in Cognos Workspace
- Enabling a larger worksheet size for Excel 2007
- Appendix A. Recommendations and References
- Introduction
- Version controlling
- Recommendations for prompt types
- Cognos Mashup Service
- SDK and third-party tools for Cognos
- IBM Cognos Analysis For Excel (CAFE)
- IBM Cognos for Microsoft Office
- IBM Cognos Workspace
- IBM Cognos Workspace Advanced
- IBM Cognos Cloud
- Index 更新時間：2021-08-06 17:03:57
