The IBM Cognos Analytics V11.0 Data Modeling Guide describes how to create and manage data modules using IBM Cognos Analytics V11.0.
This IBM Cognos Analytics Version 11.0 Data Modeling Guide explains how to fuse relational databases, Hadoop-based technologies, Microsoft Excel spreadsheets, text files, and other sources into a data module for reporting and dashboarding.
The guide covers creating data modules from data modules, data servers, uploaded files, data sets, and packages; refining them with relationships, calculations, grouping, cleaning, navigation paths, filters, and validation; and using the expression editor's operators, summaries, statistical, business date/time, common, and trigonometric functions. It notes that data modeling in Cognos Analytics does not replace Framework Manager, Cube Designer, or Transformer.
| Software version | 11.0.0 |
|---|---|
| Supported data sources | Relational databases, Hadoop-based technologies, Microsoft Excel spreadsheets, and text files |
| Uploaded file formats | Microsoft Excel (.xlsx and .xls) spreadsheets and comma-, tab-, semicolon-, or pipe-separated text files |
They can be used in dashboards and reports; a dashboard can be assembled from multiple data modules.
No. The guide says it does not replace IBM Cognos Framework Manager, IBM Cognos Cube Designer, or IBM Cognos Transformer, which remain available for more complex modeling.
Microsoft Excel (.xlsx and .xls) spreadsheets and text files with comma-, tab-, semicolon-, or pipe-separated values. Only the first Excel sheet is uploaded.
In Team content or My content.