Installing and configuring IBM Cognos Dynamic Cubes

Dynamic cubes are databases optimized to provide high speed query performance over large data sets of metadata for business intelligence reporting and analysis. The dynamic cubes provide high speed query performance by implementing the following features: using targeted caching (reducing how often queries are issued to the database); aggregate tables (providing levels of aggregation at a higher level than a basic fact table); and multi-pass SQL (improving the performance of retrieving data from the database when the cache is not sufficient).

To run the IBM Cognos® Dynamic Cubes software, the IBM® Cognos Analytics with Watson Application Server and IBM Dynamic Query Analyzer must be at version 11.0.0 and installed to the same location as other Cognos Analytics Application Tier components.