Overview of Cognos 8 BI
·
Introduce Cognos 8 BI
·
Describe IBM Cognos 8 BI components
·
Describe IBM Cognos 8 architecture at a high level
Cognos 8 Installation and
Configuration
·
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
Cognos 8 BI Admin
·
Configuration of third party security at Cognos level
·
Define IBM Cognos 8 groups and roles
·
Assign the Roles to Users or Groups
Cognos 8 Framework Manager
·
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 place
Cognos 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 Power Cube
·
Advanced
Dimensional Modeling
·
Applying Security
·
Drill Through
·
Optimizing
PowerCubes
·
Deployment of
PowerCubes to the Cognos Connection
Cognos 8 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
Cognos 8 Query Studio
·
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
Cognos 8 Report Studio
·
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 selection
Cognos 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