Course Details
Course Outline
1 - Create query models
Build a query and connect it to a reportAnswer a business question by referencing data in a separate query
2 - Create reports based on query relationships
Create join relationships between queriesCombine data containers based on relationships from different queriesCreate a report comparing the percentage of change
3 - Introduction to dimensional reporting concepts
Examine data sources and model typesDescribe the dimensional approach to queriesApply report authoring styles
4 - Introduction to dimensional data in reports
Use members to create reportsIdentify sets and tuples in reportsUse query calculations and set definitions
5 - Dimensional report context
Examine dimensional report membersExamine dimensional report measuresUse the default measure to create a summarized column in a report
6 - Focus your dimensional data
Focus your report by excluding members of a defined setCompare the use of the filter() function to a detail filterFilter dimensional data using slicers
7 - Calculations and dimensional functions
Examine dimensional functionsShow totals and exclude membersCreate a percent of base calculation
8 - Create advanced dynamic reports
Use query macrosControl report output using a query macroCreate a dynamic growth reportCreate a report that displays summary data before detailed data and uses singletons to summarize information
9 - Design effective prompts
Create a prompt that allows users to select conditional formatting valuesCreate a prompt that provides users a choice between different filtersCreate a prompt to let users choose a column sort orderCreate a prompt to let users select a display type
10 - Examine the report specification
Examine report specification flowIdentify considerations when modifying report specificationsCustomize reporting objects
11 - Distribute reports
Burst a report to email recipients by using a data itemBurst a list report to the IBM Cognos Analytics portal by using a burst tableBurst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship
12 - Enhance user interaction with HTML
Create interactive reports using HTMLInclude additional information with tooltipsSend emails using links in a report
13 - Introduction to IBM Cognos Active Reports
Examine Active Report controls and variablesCreate a simple Active Report using Static and Data-driven controlsChange filtering and selection behavior in a reportCreate interaction between multiple controls and variables
14 - Active Report charts and decks
Create an Active Report with a DeckCreate an Active Report with 11.0 visualizations
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
Authors
Prerequisites
Other Prerequisites
Knowledge of your business requirements
Previous experience building reports with IBM Cognos Analytics V11.1.x, or you have taken the IBM Cognos Analytics: Author Reports Fundamentals (V11.1.x) course.