IBM Cognos 10 report studio cookbook /

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Lashin, Ahmed
Otros Autores: Sanghani, Abhishek
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, [2013]
Edición:Second edition.
Temas:
Business report writing > Computer programs.
Database management > Computer programs.
Database Management Systems
Style commercial > Logiciels.
Bases de données > Gestion > Logiciels.
BUSINESS & ECONOMICS > Industrial Management.
BUSINESS & ECONOMICS > Management.
BUSINESS & ECONOMICS > Management Science.
BUSINESS & ECONOMICS > Organizational Behavior.
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Cover
  • Copyright
  • Credits
  • About the Authors
  • About the Reviewers
  • www.PacktPub.com
  • Preface
  • Table of Contents
  • 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: 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.

Ejemplares similares