Book description
This IBM® Redbooks® publication explains how IBM Cognos® Business Intelligence (BI) administrators, authors, modelers, and power users can use the dynamic query layer effectively. It provides guidance for determining which technology within the dynamic query layer can best satisfy your business requirements. Administrators can learn how to tune the query service effectively and preferred practices for managing their business intelligence content.
This book includes information about metadata modeling of relational data sources with IBM Cognos Framework Manager. It includes considerations that can help you author high-performing applications that satisfy analytical requirements of users.
This book provides guidance for troubleshooting issues related to the dynamic query layer of Cognos BI.
Table of contents
- Front cover
- Notices
- Preface
- Chapter 1. Overview of Cognos Dynamic Query
- Chapter 2. Administration
- Chapter 3. Metadata modeling
- Chapter 4. Macros
- Chapter 5. Report authoring
-
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.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
- Related publications
- Back cover
Product information
- Title: IBM Cognos Dynamic Query
- Author(s):
- Release date: September 2013
- Publisher(s): IBM Redbooks
- ISBN: 9780738438726
You might also like
book
IBM Cognos Business Intelligence 10: The Official Guide
The only authorized guide to IBM Cognos Business Intelligence v10.1 Updated for the latest release of …
book
The Kimball Group Reader
The final edition of the incomparable data warehousing and business intelligence reference, updated and expanded The …
book
IBM Cognos TM1 The Official Guide
The only official guide to building effective business solutions with TM1 from IBM Cognos IBM Cognos …
book
Microsoft Power BI Complete Reference
Design, develop, and master efficient Power BI solutions for impactful business insights Key Features Get to …