Curriculum
- 1 Section
- 11 Lessons
- 16 Hours
Expand all sectionsCollapse all sections
- Topics11
- 1.1Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query
- 1.2Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles
- 1.3Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions
- 1.4Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report
- 1.5Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report
- 1.6Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation
- 1.7Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information
- 1.8Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type
- 1.9Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects
- 1.10Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship
- 1.11Enhance user interaction Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Deck Create an Active Report with 11.0 visualizations