IBM Cognos Analytics – Author Reports Fundamentals (V11.1.x)

IBM Cognos Analytics – Author Reports Fundamentals (V11.1.x) is intended for report authors.

• Knowledge of your business requirements
• Experience using IBM Cognos Analytics as a consumer

What is IBM Cognos Analytics – Reporting?
• The Welcome page
• Consume report content
• Interactive filtering
• Working with reports

Dimensionally modeled relational data

Use personal data sources and data modules
• Upload personal data
• Upload custom images
• Using navigation paths in a data module

Examine list reports
• Group data
• Format columns
• Include headers and footers

Aggregate fact data
• Identify differences in aggregation

Multiple facts and repeated information
• Use shared dimensions to create multi-fact queries
• Present repeated information

Add repeated information to reports
• Create a mailing list report

Create crosstab reports
• Add measures to a crosstab
• Data sources for a crosstab

Create complex crosstab reports
• Add items as peers
• Create crosstab nodes and crosstab members

Work with crosstab data
• Format, sort, and aggregate a crosstab

Create discontinuous crosstab reports

Create visualization reports
• Visualization categories
• Customize visualizations
• Client side visualizations
• Enhanced map visualizations

Focus reports using filters
• Create filters to narrow the focus
• Use advanced detail filters
• Apply a filter with aggregation
• Use summary filters

Focus reports using prompts
• Examine parameters and prompts
• Create a parameter for a report item
• Add a prompt page
• Add a prompt item to a report
• Identify a prompt type
• Create a cascading prompt

Use calculations
• What are calculations?
• Add Date and Time functions
• Add string functions
• Display prompt selections in report titles

Customise reports with conditional formatting
• Three steps for conditional formatting
• Create a variable
• Assign the variable to a report object
• Format based on the conditional value
• Conditionally render report objects

Drill-through definitions
• Navigate to related data

Enhance report layout
• View the structure of a report
• Use Guided report layout
• Force page breaks
• Create horizontal pagination
• Modify the report structure
• Format objects across reports

Use additional report-building techniques
• Enhance a report design
• Add objects to reports
• Convert a list to a crosstab
• Explore reuse