Getting Started
• Identify the purpose of IBM Cognos Data Manager
• Define data warehousing and its key underlying concepts
• Identify how Data Manager creates data warehouses
• Examine the Data Manager architecture and user interface
Create a Catalog
• Examine the purpose and contents of Data Manager catalogs
• Create a catalog
• Define connections to source and target data
• Access data using SQLTerm
• Configure flat data source files using SQLTXT
Create Hierarchies
• Examine the role of the dimensional framework in Data Manager
• Examine hierarchies and their data sources
• Identify how to create hierarchies from the columns of one table, the rows of one table, and from multiple tables
• Test and view hierarchies
• Create a hierarchy of static date values
• Handle weeks in a date hierarchy
Create Basic Builds
• Examine Data Manager builds and build-related terminology
• Create a dimension build using the Dimension Build wizard
• Create a fact build using the Fact Build wizard
• Test and execute a fact build
• Document a catalog
• Create catalog schema
Create Derivations
• Examine derivations
• Apply operators and functions to derivations
• Examine the derivation timing model
• Add derivations to a fact build
Create Conformed Dimensions
• Examine conformed dimensions and their advantages
• Design conformed dimensions
• Create conformed dimensions
• Create data integrity lookups that use conformed dimensions
Customize Reference Structures
• Create hierarchies manually using different approaches
• Examine the features of a hierarchy
• Examine literals
• Set data access for hierarchy levels
• Examine static and dynamic members
• Examine fostering
• Use derivations in a hierarchy
Process Dimensional History and Late Arriving Facts
• Examine slowly changing dimensions (SCDs)
• Use surrogate keys in SCDs
• Manage type 1 and type 2 changes to dimensional data
• Load historical data for a dimension
• Examine late arriving facts
• Process late arriving facts in a fact build
Transform Data Using Lookups and Derived Dimensions
• Identify when to use lookups
• Identify the requirements for a lookup
• Create a translation lookup
• Create an optional lookup
• Add derived dimensions to fact builds
Customize Data Delivery
• Configure fact and dimension delivery modules
• Create indexes on fact and dimension tables
• Update fact data using keys
Customize Fact Data Processing
• Filter fact data
• Merge duplicate fact data
• Examine fact data integrity checking
• Reject fact data
Aggregate, Filter, and Partition Fact Data
• Aggregate fact data
• Examine aggregate rules
• Vertically restrict fact data
• Horizontally restrict fact data
• Partition fact data
Implement Job Control
• Examine where job control fits into the data warehouse lifecycle
• Create a JobStream
• Add, link, and reposition nodes
• Execute a JobStream and view the results
Automate Functionality Using Commands
• Differentiate between the Command Line Interface (CLI) and Data Manager Designer
• Identify common commands
• Use commands in a batch file
• Examine variables
Customize Functionality with User-Defined Functions and Variables
• Examine user defined functions (UDFs)
• Create an internal UDF
• Create a user-defined variable
Process Unbalanced Hierarchical Data
• Examine balanced, unbalanced, and ragged hierarchies
• Add a recursive level to a hierarchy
• Identify ways to balance a hierarchy and delivered flattened data
• Examine circular references
Pivot Fact Data
• Examine pivoting
• Use the single pivot technique
• Use the advanced pivot technique
• Examine reverse pivoting
Resolve Data Quality Issues
• Identify data quality and cleansing issues
• Handle fostered and unmatched members
• Perform debugging using SQLTerm and functions
• Assess the quality of output data
Troubleshoot and Tune the Data Manager Environment
• Use build logging to ensure that data marts are being loaded properly
• Perform dimension breaking
• Manage memory and resources
• Export DDL statements
Organize and Package Data Manager Components
• Export and import components using packages
• Search for components in a catalog using Navigator
Integrate with IBM Cognos BI
• Examine IBM Cognos BI
• Identify the role of metadata dimensions, metadata collections, and metadata stars
• Export Data Manager metadata to XML
• Import Data Manager XML into Framework Manager
• Use Data Manager metadata with IBM Cognos BI
• Publish a data movement task to IBM Cognos Connection
End-to-End Workshop
Entity-Relationship Model of the GO_Demo Database (Optional)
Work in a Multi-Developer Environment (Optional)
• Examine collaborative development support
• Examine the source code repository
• Examine the component dependency model
• Identify planning considerations
Standardizing Dimensions and Facts Exercise (Optional)
Review of Data Manager Essentials (Optional)
• Data warehouse design
• The purpose of Data Manager components
• Development steps in Data Manager to create data marts
• Track dimensional changes and late arriving facts
Work with SAP R/3 Data (Optional)
• Identify how to access SAP R/3 data sources using the IBM Cognos Data Manager Connector for SAP R/3 tool