IBM Cognos Analytics V11.0 Software Data Modeling Guide

The IBM Cognos Analytics V11.0 Data Modeling Guide describes how to create and manage data modules using IBM Cognos Analytics V11.0.


IBM Cognos Analytics V11.0 Software Data Modeling Guide - cover page
Brand
IBM
Category
Other software
Document type
User Manual
Language
English
Pages
67
File format
PDF
File size
661 KB
Published
29 November, 2023
Updated
29 November, 2023
MD5 checksum
33C9A63E59B0A609CBC188CAEE330EBB

About this manual

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.

What's inside

  • Data modeling in Cognos Analytics
  • Creating a data module
  • Refining a data module
  • Relationships
  • Calculations
  • Filtering data
  • Validating data modules
  • Using the expression editor

Specifications

Software version11.0.0
Supported data sourcesRelational databases, Hadoop-based technologies, Microsoft Excel spreadsheets, and text files
Uploaded file formatsMicrosoft Excel (.xlsx and .xls) spreadsheets and comma-, tab-, semicolon-, or pipe-separated text files

Frequently asked questions

What can data modules be used in?

They can be used in dashboards and reports; a dashboard can be assembled from multiple data modules.

Does data modeling in Cognos Analytics replace Framework Manager?

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.

What uploaded file formats are supported?

Microsoft Excel (.xlsx and .xls) spreadsheets and text files with comma-, tab-, semicolon-, or pipe-separated values. Only the first Excel sheet is uploaded.

Where are data modules saved?

In Team content or My content.

Download PDF (661 KB)

More IBM Manuals


View all IBM manuals →