IBM Cognos Analytics is an enterprise business intelligence and performance management platform from IBM that combines AI-powered analytics, automated reporting, and self-service data exploration capabilities. Built on a metadata-driven architecture with Framework Manager for semantic modeling and Data Modules for self-service modeling, it enables organizations to transform data from multiple sources into interactive dashboards, pixel-perfect reports, data stories, and ad-hoc explorations. The platform's key differentiator lies in its dual modeling approach — allowing both IT-governed enterprise models (Framework Manager packages) and agile self-service models (Data Modules) to coexist — alongside native AI assistance for natural language queries, intent-driven modeling, and automated insights, making complex analytics accessible to both technical and business users while maintaining enterprise-grade security and governance.
What This Cheat Sheet Covers
This topic spans 15 focused tables and 93 indexed concepts, 92 flashcards. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
A jump-to index of every table row in this cheat sheet.
An interactive map of every table and concept in this topic.
Table 1: Metadata Modeling Approaches
Everything a report author sees starts here — the semantic layer that maps raw database tables into business-friendly objects. Cognos famously offers two doors into this: the IT-governed Framework Manager and the self-service Data Modules, and the rows below cover both worlds along with the cardinality, query subjects, and SQL plumbing that make either one generate sane queries.
| Approach | Example | Description | |
|---|---|---|---|
Desktop tool Multi-layer model Publish packages | Desktop-based metadata modeling tool for creating enterprise-wide semantic layers with complex business logic, security, and dimensional modeling. | ||
Web-based Drag-and-drop tables Instant modeling | Primary web-based metadata environment for self-service modeling — users combine tables, create relationships, calculations, and filters without IT intervention. | ||
From FM to Content Store Versioned deployment | Process of deploying Framework Manager models as packages to Cognos Content Store, making metadata available to report authors. | ||
Data source query subject Model query subject | Objects in Framework Manager representing data sources (direct DB access) or modeled views (business logic layer) used in query generation. | ||
1:n, 0..1:n Inner/outer joins | Defining how tables connect with minimum-maximum cardinality (1:n, 1:1) and optional cardinality to avoid double-counting and control SQL joins. | ||
Star schema modeling Hierarchies and dimensions | Framework Manager technique for creating OLAP-style dimensional hierarchies on relational data without requiring a cube. | ||
Ask "show sales by region" Auto-build data module | AI-powered feature where users describe their analysis intent in natural language and Cognos automatically creates an appropriate data module. | ||
SELECT ... FROM ...Complex joins | Ability to define tables in Data Modules using custom SQL syntax for complex logic not easily expressed through UI. |