COGNOS ONLINE TRAINING
LTS Trainings: offers the best COGNOS online training with the IT industry specialists as our trainers are experienced certified tutors will share their experience, tips and tricks in the COGNOS Online training course.
COGNOS INTRODUCTION:
Cognos Connection is the Web portal for IBM Cognos 8. It is the beginning point for the browser-based access to all functions provided with the suite. With the help of the portal, content can be searched in the kind of reports, scorecards & agents, it can be managed, structured displayed & published. In addition, the portal is used for example to schedule & distribute reports, for generating tasks, administrating the server & the access permissions to content available to different users.
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
We also provide other Data Warehousing Classes like Informatica
