Home Page Icon
Home Page
Table of Contents for
Front cover
Close
Front cover
by Jason Tavoularis, Glen Seeds, Martin Petitclerc, Robert Hatfield, Henk Cazemier,
IBM Cognos Dynamic Query
Front cover
Notices
Trademarks
Preface
Authors
Now you can become a published author, too!
Comments welcome
Stay connected to IBM Redbooks
Chapter 1. Overview of Cognos Dynamic Query
1.1 Introduction
1.2 Background
1.3 Architecture
1.3.1 Planning and executing the query
1.4 Technology selection guidance
1.4.1 Pure relational analytics
1.4.2 OLAP analytics
Chapter 2. Administration
2.1 Configuring the query service
2.1.1 Memory sizing
2.1.2 Throughput sizing
2.1.3 Multi-server environments
2.2 Data source administration
2.2.1 Connection command blocks
2.2.2 JDBC drivers
2.2.3 OLAP connections
2.2.4 ERP and CRM data sources
2.3 Cache management
2.3.1 Priming the cache
2.3.2 Clearing the cache
2.3.3 Automating cache operations
Chapter 3. Metadata modeling
3.1 Cognos Framework Manager
3.2 Goals of metadata modeling relational data sources
3.2.1 Modeling for self-service analysis
3.3 Framework Manager architecture
3.4 Key objects of a relational model
3.4.1 Query subjects
3.4.2 Dimensions
3.4.3 Determinants
3.4.4 Relationships
3.5 Organizing relational models
3.5.1 Data view
3.5.2 Business logic view
3.5.3 Presentation view
3.6 Relational modeling for performance
3.6.1 As view versus minimized SQL generation
3.6.2 Security-aware caching
Chapter 4. Macros
4.1 Macros explained
4.2 Macro language
4.2.1 Operator
4.2.2 List separator character
4.2.3 Functions
4.2.4 Comments
4.2.5 Simple case construct
4.3 Parameter maps
4.4 Session parameters
4.5 Advanced examples
4.5.1 Member unique name for next year
4.5.2 Turning promptmany result into a rowset
4.5.3 Dynamic column drill
4.5.4 Filtering for internal and external customers
Chapter 5. Report authoring
5.1 Authoring interfaces
5.1.1 Cognos Workspace Advanced
5.1.2 Cognos Report Studio
5.2 Processing report executions
5.2.1 Local and database processing
5.3 Database functions
5.4 Dimensional and relational reporting styles
5.5 Suppression
5.6 Dimensional summaries
5.7 Advanced features in Report Studio’s Query Explorer
5.7.1 Reference queries
5.7.2 Union, intersect, and except queries
5.7.3 Join relationships
5.7.4 Master detail relationships
Chapter 6. Optimizing SQL for performance
6.1 Remember that less is faster
6.2 Make use of enforced and non-enforced constraints
6.3 Use indexes and table organization features
6.4 Review column group statistics
6.5 Avoid complex join and filter expressions
6.5.1 Temporal expressions
6.5.2 Expressions on table columns in predicates
6.6 Reduce explicit or implicit conversions
6.7 Minimize complexity of conditional query items
6.8 Review the order of conjunctions and disjunctions
6.9 Avoid performance pitfalls in sub-queries
6.10 Avoid unnecessary outer joins
6.11 Avoid using SQL expression to transpose values
6.12 Apply predicates before groupings
6.13 Trace SQL statements back to reports
Chapter 7. Troubleshooting
7.1 Problem solving strategy
7.1.1 The half-split method
7.2 Error messages
7.3 Log files and tracing
7.3.1 Query planning trace
7.3.2 Query execution trace
7.4 Dynamic Query Analyzer
7.4.1 Graph nodes
7.4.2 Views
7.5 IBM technical support
7.5.1 IBM Support Portal
7.5.2 Service requests and PMRs
7.5.3 IBM Fix Central
Related publications
IBM Redbooks
Online resources
Help from IBM
Back cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Note: Before using this information and the product it supports, read the information in “Notices” on page vii.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset