Cognos Online Training Course
COGNOS INTRODUCTION
INTRODUCTION TO DATAWARE HOUSING (DWH)
● Introduction to DWH
● Characteristics of DWH
● OLTP Vs OLAP Databases
● Different Approaches of DWH (Kimball Vs Inmon)
● Data mart Vs Data Warehouse
● Fact Table Vs Dimension Table
● Concepts of Schemas (Star schema & Snowflake schema)
● Industry leading ETL and Reporting tools
INTRODUCTION TO COGNOS
● About Cognos 8.4
● 3 – Tier Architecture
● Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3) and their differences
● Features of Cognos 8.4
● Cognos Vs other OLAP tools
● Cognos components (Modeling & Reporting)
● Different cognos services
COGNOS CONNECTIONS
● Personalize cognos connection
● Create and manage portals, shortcuts, report views..etc
● Working with Cognos configuration, content Store
● How to Connect to different Data Sources
● Security setup
● Import and Export of Package (Deployment)
● Running the Report Burn
● Scheduling Reports
FRAMEWORK MANAGER
● About Framework Manager
● Framework Manager, Metadata Modeling
● Creation of Interface and Usage
● Creating Model & Namespace (Layers)
● Importing Metadata
● Naming convention for objects in a project
● Creating Query Subjects & Query Items
● Merging Query Subjects
● Creating Relationships & Setting Cardinalities
● Creating Parameter Maps & Macros
● Creating of Model Filters, Prompts & Calculations
● Add Business Rules and Set Governors
● Assigning package level security
● Improving performance
● Publishing Package
QUERY STUDIO
● Introduction
● About Ad-hoc Reports
● Types of Report(List, Cross Tab, Chart Reports & Others)
● Applying Filters, Prompts & Calculations
● Sorting, Grouping, Sections & Aggregate Functions
● Run and Manage reports
REPORT STUDIO
● Type of Report Templates
● Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
● Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
● Generating and Creating Prompt Page
● Types of Prompts
● Query Calculations & Layout Calculations
● Filters and Dynamic Filters
● Conditional Block
● Conditional Formatting
● Master Details
● Cascading Prompt
● HTML Items & Hyperlinks
● Set Operators
● Setting Burst Options
● Drill through
● Drill up & Drill down
● Setting Variables
● Report Functions
● Report Validation
● Reports Run with Options
ANALYSIS STUDIO
● Insert Data
● Change the number of Visible Items
● Nest Data
● Replace Data
● Sort Data
● Explore Data
● Change the measure
● Drill down for Details
● Hide Items
● Insert a calculation
● Save a custom set
● Define a filter
● Compare sets of data
● Using Dynamic Context
EVENT STUDIO
● Creating Agents
● Adding Event conditions
● Task and Task execution rules
● Scheduling Agents