cognos online training by real time experts

1
Introduction to Cognos TM1

• RVH TECHNOLOGIES

2
Cognos TM1

• New analysis and business optimization
  capabilities across the Cognos product family
• Unique value propositions such as
• very fast real-time performance
• scalability for large data volumes
• non-technical user-centric design
• an Excel-based approach to application
  development
• Deployable in a stand-alone configuration or
  integrated with dedicated Cognos planning,
  consolidation, analysis and reporting products

3
Cognos TM1

• Key findings from the Butler Group "Technology
  Audit"
• Strong OLAP capabilities and the speed of the TM1
  engine underpin the inherent strength of this
  technology
• Linked multi-dimensional cubes form the heart of
  this Performance Management solution
• Calculations are performed in real-time, so that
  dynamic analysis is possible
• Tight integration to Excel enables users to work
  without stepping outside of traditional comfort
  zones
• Flexible Web delivery includes dashboards and
  scorecards, self-service analytics,
  Excel-authored reports and ad-hoc analysis

4
Cognos TM1 Capabilities in a Nutshell

• Read/write at speed of thought for Planning and
  Budgeting
• What-if scenario modeling for Forecasting
• In-memory multi-dimensional cubes for Analysis
  and Reporting
• Centrally-managed business hierarchies, rules and
  calculations
• Built-in data and metadata integration
• Leverages Excel functionality and skills

5
TM1 Database Components
Feature Benefit
64-bit Model and analyze large data volumes with fast response times
In-Memory Easily create simulations interactively to test new business assumptions
Multi-Cube Model any type of business process natural way to build models
Rules Language Create complex financial applications
Turbo Integrator Easily load large amounts of data quickly (e.g., intraday) from any sources including ERP, DW, etc.
6
TM1 Presentation Components
Cognos TM1 Web
Cognos TM1 Server Explorer
Feature Benefit
TM1 Server Explorer Build, deploy, and maintain application dimensions, cubes, rules, security, etc.
Cognos TM1 Excel Easily create reports and templates deployed via Excel or web
Cognos TM1 Web Simply access Excel generated reports or input templates
Cognos TM1 Executive Viewer Self-service ad-hoc analysis optimized for R/W access to TM1 (also supports Essbase, MSAS, SAP BW)
Cognos TM1 Excel
Cognos TM1 Executive Viewer
7
TM1 Models Extensible Versatile
Finance
Workforce
Consolidation
Project Mgmt
Salary Planning

• An integrated extensible application for all
  users and business functions, with common
• architecture
• fact data
• reference data
• scenarios
• business rules
• workflow
• presentation
• security

Cash Flow
Profit Loss
Resource Planning
Balance Sheet
Sales Commissions
Cognos TM1
Product
Customer
Product Profitability
Customer Profitability
Pipeline Analysis
Production Planning
Inventory Mgmt
Marketing Effectiveness
Churn Analysis
Quality Tracking
8
Cognos TM1 Solution Gallery
9
TM1 Representative SolutionsExecutive Dashboard
10
TM1 Representative Solutions Analyst Dashboard
11
TM1 Representative Solutions Financial Reporting
12
TM1 Representative Solutions Analytical
Transactional Views
13
TM1 Unique Value 1 Deploy Easier

• User-Driven Design
• Maximum leverage of business knowledge
• Minimal coding and IT resources
• Rapid Time to Value
• Point-And-Click Development
• Data Integration Wizards
• Expressive Modeling
• Integrated Workflow
• Graphical Screen/Report Builders
• Simplicity
• One Technology
• One Database
• One Set of Skills

14
TM1 Unique Value 2 Deploy Faster

• Leverage Excel
• Formulas
• Formatting
• Charting
• Leverage the Web
• Reach Every User
• Zero Footprint
• Minimal Training
• Empower All Users
• Interactive Analysis
• Advanced Visualization
• Automated Data Entry

15
TM1 Unique Value 3 React Faster

• Connect Immediately
• SAP Connector
• Data orchestration
• Work Interactively
• In-memory modeling
• Concurrent write then read
• Grow Exponentially
• Extensible solutions
• Mainstream 64-bit hardware

16
A Typical TM1 Deployment Scenario
Application Name Integrated Workforce Planning
Number of Users Administrators 2 Professionals 25 Viewers 100
Geographies UK, US, Canada
Timing Start September 2007 Go-live November 2007
For Example Purposes Only
Current State
Future State
Cognos TM1
HR Systems
Planning
17
TM1 Three Editions For Every Need

• Cognos TM1 Personal Edition
• Personal modeling and what-if analysis
• Single-user license
• Cognos TM1 MidMarket Edition
• Small-Medium Enterprises
• Departmental or Pilot Applications
• Up to 55 users / server
• Cognos TM1 Enterprise Edition
• Integrated with Cognos 8 Platform
• Unlimited scalability

18
TM1 Licensing Model

• Three licensable categories
• Servers (varies by Edition)
• User Roles (Enterprise 4, MM 2, Personal 1)
• Add-On Extensions and Applications

Journaling Module
SAP Connector
Other 3rd-Party