COGNOS COURSE CONTENT
Overview of Cognos 8 BI
- Introduce Cognos 8 BI
- Describe IBM Cognos 8 BI components
- Describe IBM Cognos 8 architecture at a high level
- Components used by Cognos 8
o Server Components
o Modeling Components
- Installing Cognos 8
- Setting up the Environment
- Configuring Cognos 8
- Setting up Samples
- Uninstalling Cognos 8
- Configuration of third party security at Cognos level
- Define IBM Cognos 8 groups and roles
- Assign the Roles to Users or Groups
- Introduction to Framework Manager
o Framework Manager Basics
o User Interface, Navigation, Objects
o Planning the project and data model
o Naming Conventions for objects in a project
- Designing Project
o Create project
o Importing Metadata
o Exporting Metadata
o Multi-user Modeling
o Segmenting and Linking
o Create Model Documentation
- Data Sources
o Working with Data Source Connections
o Create and Modify Data Sources
o Improve Performance by setting Query Processing Type
- Preparing Relational Metadata for use in Reports
o Verifying Relationships
o Working with Dimensions
o Working with Query Subjects
o Working with Query Items
o Supporting Multilingual Metadata
o Adding Business Rules
o Organizing the Model
- Making Metadata Available to Report Authors
o Verify Model
o Set Governors
o Improving Performance
o Create or Modify Package
o Controlling access to Metadata
o Explore Package
o Publish Package
- Guideline for Modeling Metadata
o Scenarios
o New Objects - Determinants, Regular Dimensions, Measure Dimensions, Scope Relationship
o Dimensional Modeling of Relational Data Sources
- Types of Security
o Data Level
o Objective Level
o Package level
- SQL Generated by Cognos 8
o Understanding Dimensional Queries
o Resolving Ambiguously Identified Dimensions and Facts
o Resolving Queries that should not have been split
o Resolving Queries that are split in the wrong placeCognos PowerPlay Transformer
- Transformer Fundamentals
o Discuss the basics of OLAP analysis
o Review Transformer capabilities and its role in IBM Cognos 8 BI
o Discuss Transformer components
o Define categories and members
- Transformer Development Process
- Data Sources in Transformer
- Building a Model
- Define Dimensions, Levels and Measures
- Time Dimensions, Relative Time
- Currency Conversion
- Create PowerCube
- Advanced Dimensional Modeling
- Applying Security
- Drill Through
- Optimizing PowerCubes
- Deployment of PowerCubes to the Cognos Connection
- Examine Cognos Connection
- Run and view reports
- View the run history of a report
- Organize content with folders and shortcuts
- Customize report outputs by using report views
- Schedule single and multiple reports
- Personalize Cognos Connection
- Creation of Portal pages
- Introduction to Query Studio
- Create Reports (List, Grouped List, Crosstab, Charts)
- Changing the Appearance of Reports (Format)
- Sorting and Grouping
- Filters and Prompts
- Subtotals and Calculations
- Run and Manage Reports
- Drill Through reports
- Introduction to Report Studio
o Report Studio User Interface
o Creating, Save and Run Reports
o Report Templates
o Managing Reports
- Formatting a Report
o Report Layout Guidelines
o Fonts, Styles, Header, Footer and Borders
o Insert objects
o Apply Table Styles
o Swap Columns and Rows
- Create Additional Advanced Reports
o create a report that displays summarized data before detailed data
o highlight alternate rows in a list report
o use single data items to summarize report information
o save reports to server file system
o Drill-through Reports
o Drill-up/Drill-down Reports
o Master-Detail Reports
o Scheduling Reports
- Working with Data
o Filters, Parameters and Prompts
o Sorting and Grouping
o Subtotals and Calculations
o Working with Queries
- Create Query Models
o build query models and then connect them to the report layout
o add filters and prompts to a report using the query model
o edit an SQL statement to author custom queries
- Create Advanced Dynamic Reports
o filter reports on session parameter values
o navigate a briefing book using a table of contents
o create dynamic headers and title that reflect report data
o let users navigate to specific locations in reports
o create a customer invoice report
- Design Effective Prompts
o control report displays using prompts
o specify conditional formatting values using prompts
o create a report that formats based on prompts selection
o create a sorted and filtered report based on prompt selectionCognos 8 Analysis Studio
- Introduction to Analysis Studio
- Creating a Basic Analysis
- Working with data in Crosstab
- Exploring Data
- Limiting Data
- Calculating Data
- Sharing Data
No comments:
Post a Comment