IBM Cognos Development

IBM Cognos TM1 (formerly Applix TM1) is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the "leaf" level. Computations on the leaf data are performed in real-time (for example, to aggregate numbers up a dimensional hierarchy). IBM Cognos TM1 includes a data orchestration environment for accessing external data and systems, as well as capabilities designed for common business planning and budgeting requirements (e.g. workflow, top-down adjustments).

Several new features were added to IBM Cognos TM1 9.5, the most visible being TM1 Contributor, which combines an OLAP engine with the enterprise planning capabilities of IBM Cognos Planning in a Web-based client. Other features include an "Undo/Redo" capability that lets users store a collection of data value changes and walk back through the actions to undo them; pick lists for cells to reduce the amount of data entry performed; sandboxes for creating personal modeling scenarios; and data entry shortcuts.

COGNOS TM1
    1.Examine the components of a TM1 model
    2.Create dimensions
    3.Build cubes and views
    4.Load and maintain data
    5.Add business rules
    6.Optimize business rules
    7.Transfer data into the model using scripts
    8.Customize drill paths
    9.Use rules for advanced modeling
    10.Convert currencies
    11.Analyze data in TM1 Web
    12.Contribute Data to Managed Planning Applications
    13.Create and Deploy Managed Planning Applications

INTRODUCTION TO DATAWARE HOUSING (DWH)
    1.Introduction to DWH
    2.Characteristics of DWH
    3.OLTP Vs OLAP Databases
    4.Different Approaches of DWH (Kimball Vs Inmon)
    5.Data mart Vs Data Warehouse
    6.Fact Table Vs Dimension Table
    7.Concepts of Schemas (Star schema & Snowflake schema)
    8.Industry leading ETL and Reporting tools

INTRODUCTION TO COGNOS
    1.About Cognos 8.4
    2.3 – Tier Architecture
    3.Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3) and their differences
    4.Features of Cognos 8.4
    5.Cognos Vs other OLAP tools
    6.Cognos components (Modeling & Reporting)
    7.Different cognos services

COGNOS CONNECTIONS
    1.Personalize cognos connection
    2.Create and manage portals, shortcuts, report views..etc
    3.Working with Cognos configuration, content Store
    4.How to Connect to different Data Sources
    5.Security setup
    6.Import and Export of Package (Deployment)
    7.Running the Report Burn
    8.Scheduling Reports

FRAMEWORK MANAGER
    1.About Framework Manager
    2.Framework Manager, Metadata Modeling
    3.Creation of Interface and Usage
    4.Creating Model & Namespace (Layers)
    5.Importing Metadata
    6.Naming convention for objects in a project
    7.Creating Query Subjects & Query Items
    8.Merging Query Subjects
    9.Creating Relationships & Setting Cardinalities
    10.Creating Parameter Maps & Macros
    11.Creating of Model Filters, Prompts & Calculations
    12.Add Business Rules and Set Governors
    13.Assigning package level security
    14.Improving performance
    15.Publishing Package

QUERY STUDIO
    1.Introduction
    2.About Ad-hoc Reports
    3.Types of Report(List, Cross Tab, Chart Reports & Others)
    4.Applying Filters, Prompts & Calculations
    5.Sorting, Grouping, Sections & Aggregate Functions
    6.Run and Manage reports

REPORT STUDIO
    1.Type of Report Templates
    2.Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
    3.Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
    4.Generating and Creating Prompt Page
    5.Types of Prompts
    6.Query Calculations & Layout Calculations
    7.Filters and Dynamic Filters
    8.Conditional Block
    9.Conditional Formatting
    10.Master Details
    11.Cascading Prompt
    12.HTML Items & Hyperlinks
    13.Set Operators
    14.Setting Burst Options
    15.Drill through
    16.Drill up & Drill down
    17.Setting Variables
    18.Report Functions
    19.Report Validation
    20.Reports Run with Options

ANALYSIS STUDIO
    1.Insert Data
    2.Change the number of Visible Items
    3.Nest Data
    4.Replace Data
    5.Sort Data
    6.Explore Data
    7.Change the measure
    8.Drill down for Details
    9.Hide Items
    10.Insert a calculation
    11.Save a custom set
    12.Define a filter
    13.Compare sets of data
    14.Using Dynamic Context

EVENT STUDIO
    1.Creating Agents
    2.Adding Event conditions
    3.Task and Task execution rules
    4.Scheduling Agents