IBM Cognos Performance Management IBM Business Analytics Sean Corr

IBM Business Analytics
IBM Cognos
Performance Management
Sean Corr
WW Performance Management & Midmarket Channel Solutions Manager
© 2012 IBM Corporation
Agenda
Business Analytics Overview
• Where does Performance Management fit?
Performance Management and IBM Cognos Solutions
• Planning, Analysis and Forecasting on a single platform - IBM Cognos TM1
• Close, Consolidate, Report, File
• IBM Cognos Controller (with in-built TM1 FAP Cube)
• IBM Cognos FSR
IBM Case Study
Q&A
2
© 2012 IBM Corporation
Better
outcomes
Smarter
decisions
Actionable
insights
Relevant
information
3
© 2012 IBM Corporation
IBM business analytics deliver ...
Time
Drive efficiencies and
scale
• Eliminate intensely
manual efforts
• Structure and automate
dynamic processes
• Scale to large user
communities and data
sets
4
Control
Gain agility and
preparedness
• Link operational and
financial performance
management
• Support advanced
analytic techniques
(e.g., scenario and
predictive analytics)
• Eliminate delays in
coordinating around to
emerging realities
Confidence
Improve effectiveness
and outcomes
• Dramatically reduce risk
of errors
• Cost-effectively address
compliance
• Drive new confidence in
analytics-driven decision
making
© 2012 IBM Corporation
IBM delivers the broadest Business Analytics portfolio to drive better
business outcomes
IBM Business Analytics
Industry
Solutions
Financial
Services
Public Sector
Customer
Functional
Solutions
Customer
Acquisition
Customer
Loyalty
& Retention
REPORT
Core
Capabilities
Finance
Social Media
Analytics
Customer
Lifetime
Value
5
Budgeting &
Forecasting
MODEL
Discover
Mine
Communications
Resource
Optimization
Risk
Asset
Management
Sales Performance
Management
Disclosure
Profitability ModelingProduction Planning Decision
Management
& Optimization
Management
Visualize
Business
Intelligence
Industrial
Operations
Financial
Consolidation
ANALYZE
Forecast
Software
Categories
Distribution
PLAN
Predictive
Analytics
Risk & Control
Assessment
Risk Mitigation
Planning
Risk Aware
Decisioning
COLLABORATE
Simulate
Score
Risk
Identification
PREDICT
Govern
Survey
Performance
Management
Contribute
Decide
Risk
Analytics
© 2012 IBM Corporation
IBM Performance Management
Guide management strategy in the most profitable directions with timely, reliable insights,
scenario modeling and transparent reporting
• Link financial and operational plans through driver-based models.
• Guarantee the quality and accuracy of financial numbers for timely, sustainable
compliance.
• Track performance against strategic objectives.
• Perform ―what-if‖ scenario modeling and create flexible rolling forecasts.
• Replace rigid budgets with continuous planning—daily, weekly, or monthly
Performance reporting and scorecarding
Close, consolidate,
report and file
6
Analyze and
optimize
Plan, forecast
and control
© 2012 IBM Corporation
Performance Management Strategy
Target Audience
KEY
7
SOLUTION AGENDA / PLAY
AUDIENCE TARGETS
KEY INDUSTRIES
Planning Analysis &
Forecasting; Profitability
Modeling & Optimization;
Performance Reporting &
Scorecarding
 Insurance and Banking,
Retail, Industrial, Life
Sciences (including
Performance Blueprints)
Disclosure Management;
Financial Close
Management
 Insurance (Solvency II),
Public Sector (CAFR)
Incentive Compensation
Management; Sales
Performance Management
 Insurance and Banking,
Retail, Industrial, Life
Sciences (Med Supplies &
Pharma), Communications
Confidential
© 2012 IBM Corporation
FINANCE ISSUES & CHALLENGES
Risk Growth
Volatility Expense
Reporting
Forecasting Cash Flow
Shareholders
Revenues
Regulation
Transparency Uncertainty Working Capital
Capital
8
Profitability
Variability
© 2012 IBM Corporation
As finance evolves, organizations need to understand WHAT
happened, HOW they are doing, and WHAT the future may hold
WHAT WILL HAPPEN NEXT?
• Cash forecasting
HOW ARE WE DOING?
• Customer and product profitability
WHAT HAPPENED?
• Balance sheet, profit and
loss, and cash flow
statements
• Revenue and cost variance
analysis
9
• Spend optimization
• Scenario-based planning and
forecasting
• Strategic investment decision
support
• Working capital analysis
• Volatility and risk-based
• Market, customer, & channel pricing predictive
and behavioral modeling
• Sales and supply chain
effectiveness
© 2012 IBM Corporation
IBM solutions help organizations TRANSFORM financial
PROCESSES and drive improved performance
Finance
Solutions
Report
• Deliver fast, reliable performance reports and analysis
• Automate financial close process
• Meet new disclosure and filing mandates (XBRL)
Plan
Align
Plan
• Improve visibility with driver-based and predictive forecasts
• Rapidly adjust and realign resources
Report
Capabilities
Align
• Define, measure, and adjust strategy with metrics
• Deliver engaging, up-to-the-minute dashboards
10
Reporting & Analysis
Scorecarding &
Dashboarding
Predictive Analytics
Planning, Budgeting &
Forecasting
Financial
Consolidation
Disclosure
Management
Profitability Modeling &
Optimization
© 2012 IBM Corporation
CFOs believe that industry / sector pressures will increase
challenges and opportunities over the next three years
Industry / Sector Changes Over the Next Three Years
Pressure to reduce cost base
78%
Need for faster decision making
74%
Demand for external transparency (e.g.,
Board, shareholders, taxpayers, regulators)
69%
Product / service demand growth
61%
Ability to attract and retain talent
Potential access to short-term liquidity / longterm capital
56%
40%
As a result of these factors, ~60% of Finance
organizations believe that they have to make
major changes to respond.
N = 1,844 to 1,905
Note: Executives asked: In the next 3 years, how will the following conditions change in your industry / sector? Excludes participants that select ―Don’t know‖
Note: Defined as enterprises selecting [5] Increase considerably and [4] on a 5-point scale where [5] Increase considerably and [1] Decrease considerably
Source: IBM Institute for Business Value, The Global CFO Study 2010
11
© 2012 IBM Corporation
The more you infuse
analytics
analytics into all areas of
your business, the more
your business
business can
your
can
outperform its competitors.
outperform
12
© 2012 IBM Corporation
Addressing critical processes in Finance and LOB
Planning, Analysis and
Forecasting
Profitability Modeling and
Optimization
Close, Consolidation, and
Reporting
Performance Reporting and
Scorecarding
Governance, Risk, and
Compliance
13
© 2012 IBM Corporation
IBM Business Analytics: Committed to Finance and Line of Business
14
© 2012 IBM Corporation
Unified FPM System
Solutions
Delivery
Common
User
Experience
Extensible
Program
Interface
Data
Infrastructure
Enterprise
Planning
Web Rich Client
Financial
Analytics
Web Thin Client
Strategy &
Performance
Reporting
Financial
Management &
Control
Excel / Office
Business Intelligence
Business Modeling
Process Management
Universal Capability
• Dimension Management
• Data Orchestration
• Cube Building
• Business Rules
• Delegation & Workflow
• Deployment Controls
• Contribution & Signoff
• Event Management
• Reporting, Analysis & Dashbds
• Portal & Content Mgmt
• Security
• Data & Metadata Access
FPM Open API Services
OLAP Repository – TM1
Relational Repository - RDBMS
•
•
•
•
•
•
•
•
•
Multi-dimensional
Complex business logic
High data scalability
In-memory architecture, realtime calculation and reporting
• Unicode
Deployment Management
Transactional Data
Audit functions
Model & Object persistence
Application Content
Cognos Performance Management Services
15
Product Direction is subject to change. All forward-looking
statements are subject to the IBM Cognos Safe Harbor Statement.
© 2012 IBM Corporation
Delivering on Roadmap - Enabling Full Financial Transformation
Budgeting & Target Setting
Bottom-up, high participation, workflow)
Forecast & Estimate
(Iterative, scenarios, sandboxing)
Group and Country
Financial Planning
Close, Consolidation
& Reporting
“The Last Mile”
External Reporting Process
(Top-down, driver-based,
collaborative)
TM1 OLAP
64-bit in-Memory
High Performance
Analytic & Planning
Server
16
© 2012 IBM Corporation
IBM Cognos Financial Performance & Strategy Management
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
Report, File
• Account Analysis
• Close Analytics
• Financial
Consolidation
• Corporate
Reporting
• Regulatory Filing
(e.g. XBRL)
18
Analyze &
Optimize
• Financial Analytics
• Spend Analytics
• Profitability
Analytics
• Product, Market,
Channel Analysis
• Scenario (what-if)
modelling
• Personal sandboxes
Plan, Forecast,
and Control
• Strategic Finance
• Revenue Planning
and Forecasting
• Expense Planning &
Control
• Workforce Planning
• Capital and
Initiative Planning
© 2012 IBM Corporation
Analyze & Optimize
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
Report, File
“ For our financial analysis and everything
we do, IBM Cognos TM1 is very critical,
and it‟s irreplaceable at this point.”
Anand Saxena, Financial Reporting (FIRE), DHL
Global Forwarding
“Putting IBM Cognos TM1 at the core of the
tariff optimisation service we offer mobile
operators means our clients have access to
the most effective analysis and planning
solution possible.”
Analyze &
Optimize
• Financial Analytics
• Spend Analytics
• Profitability
Analytics
• Product, Market,
Channel Analysis
• Scenario (what-if)
modelling
• Personal sandboxes
Plan, Forecast,
and Control
IBM Strength
Financial analytics and profitability analysis
enabled by:
• Scalable analysis solution, capable
of dealing with high degrees of
complexity
• Providing an interactive user
experience to interact with data and
scenarios
• Easy to use – web or excel interface
• Single platform enabling scope to
cover all attributes of the business
• Real-time modelling
Vital connection to planning for growth
and profitability
David Eurin, Senior
Manager, Analysys Mason
19
© 2012 IBM Corporation
Plan, Forecast, and Control
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
and Report
“We also found that it
allows us to offer an
integrated budgeting
process including what-if
scenarios, forecasting and
automated consolidation”
“…hundreds of TM1 users
across five business sites
within the company”
Garry Cook,
TM1 Development Manager, BAE
(Air Systems)
20
Analyze &
Optimize
Plan, Forecast,
and Control
• Strategic Finance
• Revenue Planning
and Forecasting
• Expense Planning &
Control
• Workforce Planning
• Capital and
Initiative Planning
“The level of expertise to
drive IBM Cognos TM1 is
a lot less than other
planning applications I
have used. I make my
own changes without
having to call IT”
Louise Cooper,
Group Planning Manager, Steinhoff
Asia Pacific
© 2012 IBM Corporation
TM1 Customer Quotes
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
and Report
Analyze &
Optimize
Plan, Forecast,
and Control
―With such a complex, multinational European operational landscape, the sheer
volume of data means that traditional spreadsheet-based approaches are becoming
increasingly difficult to manage. TM1 gives us a platform that we can use to build
better solutions for data management and analysis across many areas of the
business.‖
Gavin O‟Donoghue, Global Process Owner, Pfizer
―We also found that it allows us to offer an integrated budgeting process including
what-if scenarios, forecasting and automated consolidation‖ ―…hundreds of TM1
users across five business sites within the company‖
Garry Cook, TM1 Development Manager, BAE (Air Systems)
―The level of expertise to drive IBM Cognos TM1 is a lot less than other planning
applications I have used. I make my own changes without having to call IT‖
Louise Cooper, Group Planning Manager, Steinhoff Asia Pacific
―The impressive speed with which the database performs calculations remains
consistent, irrespective of the amount of data or the complexity of the data
architecture‖
Andreas Mathner, TM1 Project Leader, Deutsche Bahn (German Railways)
― a game changer. You run into that typical dilemma in finance organizations where
you spend so much time aggregating data that you have very little time to analyze it.
IBM Cognos TM1 went a long way toward solving that issue.‖
Sung Lee, Director, Financial Planning & Analysis, Gilead
21
© 2012 IBM Corporation
Enterprise Planning: A Distinctive IBM Advantage
Financial Performance
and
Strategy Management
Business
Drivers
Close,
Consolidate,
Report, File
IBM Strength
Plan based on business drivers
Easily implement Rolling Forecasts
Connect financial and operational
planning
Connect plans to strategic goals
Address both high participation and
deeply analytic planning
Real-time scenario modelling/
sandboxing
Leverage best practices - over 75
performance blueprints to accelerate
success
22
Analyze &
Optimize
MARKETING
PRODUCTION
AND
DISTRIBUTION
CUSTOMER
SERVICE
Plan, Forecast,
and Control
EXECUTIVE
MANAGEMENT
SALES
FINANCE
PURCHASING
TECHNOLOGY
IT/R&D
HUMAN
RESOURCES
FINANCE
FINANCE
© 2012 IBM Corporation
Performance
Reporting
and Scorecarding
Business
Drivers
IBM Cognos TM1
Close,
Consolidate,
and Report
A patented 64-bit read-write in-memory OLAP
engine that provides compact data storage and
exceptionally fast performance
Analyze &
Optimize
Plan, Forecast,
and Control
Demo –
Contribution
Multi-cube model design and data access that
presents business information in familiar formats
Ease of use, thanks to a development
environment that enables users to create
sophisticated applications with no need for
programming or traditional IT skills
An intuitive, flexible approach, which enables
users to easily express complex, multidimensional business rules
Fuses Analysis & Planning together to provide
greater accuracy
Drill through to transaction systems for greater
detailed analysis
Familiar Excel & Web interfaces
Managed Contribution
Alternate scenarios/ Sandboxing
23
Demo - Scenario
© 2012 IBM Corporation
Planning, Analysis, Profitability Modeling
IBM Cognos Insight
IBM Cognos TM1
• Access to external and corporate-sanctioned data sources
• Boundless freedom to perform on-demand analysis
• ―Write-back‖ for what-if scenarios and planning template development
IBM Cognos TM1 Performance Modeler
• Multi-dimensional modeling tools
• Visual interface for intuitive modeling
• Big time savings, less risk and better visibility
• Driver-based models
• Easier scenarios to address risk
• Easy distribution and aggregation of templates
• Real-time reporting against plan, budgets and forecasts
• High data, user scalability
24
IBM Cognos Insight, Web Excel interface,
Contributor
© 2012 IBM Corporation
Portlets
IE or FF, HTML, JavaScript
Client
Interfaces
TM1 Dev/Admin Client
Microsoft Excel Add-In
TM1 Contributor
LAN
TM1 Web (IIS 5/6)
TM1 Contr Service
BI
CV
SSL
SSL
SSL
LAN/WAN
WS
• Studios
• CAFE
• Events
LAN/WAN
FM Cognos 10.1 Platform CAM
Client
Delivery
LAN
Firewall
TLS
TLS
TLS
TLS
Database
and
Application
Servers
Cognos Repository
Log/Metadata Server
In-Memory Multi-dimensional Cubes
Scheduled or Triggered
Log Files
IBM Cognos TM1
Local <-Authentication -> CAM
CAM Passport
LAN
Data Orchestration
LDAP / AD
Win x86, x64
Sun Solaris
AIX
Cube Files
Firewall
Enterprise
Data Stores
LAN
ODBC
ODBO
ASCII
SAP
Netweaver BI
Active Directory
LDAP
CAM
25
25
© 2012 IBM Corporation
Proven analytics engine
• Distributed Cognos TM1 Server
• Improved WAN performance
• Better user scale
• Built on the high-performance, stable
9.5.2 Server Engine
• First-in-line with parallel interaction
• More tools to accelerate ETL
performance
Distributed Cognos TM1 Server
• Multi-server management console
Delivers quality, scale, and performance
26
© 2012 IBM Corporation
IBM Cognos Insight :
Explore/analyze data and build a plan
User Experience
Perform Analysis on Personal Data
• Prototype situations, plans
• Work with existing or pull in new
data
• Perform what-if scenarios,
associative analysis, write-back
• Customise View and Explore Points
Build A Plan
• Create New Version
• Shortcuts, Multiple Views, charts
• Create or add to dashboards
• Add Instructions
Demo - Profitability
Improved planning involvement across the enterprise
27
© 2012 IBM Corporation
IBM Cognos Insight :
Share or Expand on the Plan
Operations
Product
Development
Human
Resources
Teaming
Promote finds in a tailored
dashboard
Easily publish findings, reports to
TM1 (BI)
Share new planning application on
Web for teams to take action
IT
Customer
Service
Finance
Sales
Marketing
Expand the plan
Move plan to Performance
Modeler for enhancement,
contribution
No dead-end street for individual
analysis and plans
28
Demo – CI Expand on Plan
© 2012 IBM Corporation
Analytic Agility & Innovation
―[Cognos Insight] provides an excellent prototyping tool
for our business analysts. It will allow us to move more
modeling out to the business users.‖
-- Jack Purvis, Senior Manager, BI/PM, DIRECTV
―I particularly like the ability that a reviewer or
contributor, with appropriate access rights, can add
members to an existing dimension while working in
Central Planning [mode].‖
-- Michael Mackie, Product & Practices Manager, Cortell NZ
29
© 2012 IBM Corporation
Performance Modeler….Faster, easier modeling
Lowering the bar for designing TM1 models
Guided modeling steps
define dimensions
build cubes
define rules – improved editor
easy linking interface/paradigm
Easy transfer of applications across
environments – Dev > Test > Prod
Widespread use of drag and drop and
WYSIWYG
New TI process editors
3-pane application
Empowering more users to model, reduced time to value
30
© 2012 IBM Corporation
Faster, easier modeling
Modeling & Solution Design
 Simplifies Design for Performance
Management Solutions
 Provides guided processes (import,
design, deploy)
 Empowers MORE TM1 solution
development, more prototyping
 Wires Cognos Insight “personal
analysis” into enterprise solutions
 Meets the broad range of
enterprise planning, profitability
and analysis solutions
Address Broad Range of Performance Management Challenges
31
Demo
© 2012 IBM Corporation
Modeling & Solution Design
―[Performance Modeler] will allow more people to develop TM1 solutions
as well as speed up the development process.‖
--Jack Purvis, Senior Manager, BI/PM, DIRECTV
―The single product IBM Cognos solution with the personal desktop
component wraps together the full cycle of processes – planning,
analysis, forecasting, and reporting. You can easily create the templates
or models for planning – and then roll them out to the enterprise over
your WAN for rapid turnaround.‖
-- Sherain Messenger, Cognos Competency Centre Manager, Hiscox
32
© 2012 IBM Corporation
Analytic Agility & Innovation
Analytic Agility with Cognos Insight
and Cognos TM1
Standalone user starts an analysis:
• Imported sales results data - no pre-modeling by IT (my data)
• Explored deals & geographies to discover problems & answers:
• sales are low in NA, Europe is high & Asia is flat… why?
• NA team had ineffective sales promotions & less training
• Create a departmental strategy or plan to use European sales
promotions & increase training
Analysis
Workgroup sharing:
•
•
•
•
Discovery
What if?
Small scale (1 to 10 users)
Interact / annotate / edit dashboard
Slice up data relevant to user
Users contribute to plan / strategy
/analysis
Ad hoc plan
Share results
33
33
Enterprise-level plan:
•
•
•
•
•
Plan published to Performance Modeler
Involves multiple departments
Analysts develops model, links to other models
Deploys plans for enterprise contribution
Contributors blend in complex profitability or
predictive analysis
© 2012 IBM Corporation
Close, Consolidate, and Report
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
Report, File
• Account Analysis
• Close Analytics
• Financial
Consolidation
• Corporate
Reporting
• Regulatory Filing
(e.g. XBRL)
34
Analyze &
Optimize
CLOSE
CONSOLIDATE
Plan, Forecast,
and Control
IBM Advantage
REPORT
From fragmented, first
generation consolidation
products to functional
rich, purpose-built
systems
Cementing key financial
process and internal
controls for reporting
with confidence
© 2012 IBM Corporation
Close, Consolidate, Report: Key Requirements
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
Report, File
Analyze &
Optimize
Plan, Forecast,
and Control
• Single controlled environment
• Application configuration
• Audit tracking
• Internal controls
• Finance owned – ease of use
• IT infrastructure compliance
• Out-of-the-box functionality
• Consolidation workflow
IMPACT: Cost efficient and effective compliance and faster cycles of close
process execution. Confidence in consolidating financial results accurately and
sharing with internal and external stakeholders
35
• Security & access control
© 2012 IBM Corporation
Close, Consolidate, Report: Collect & Certify
Performance
Reporting
and Scorecarding
Business
Drivers
Process
quality
process &
control in
data
preparation
Close,
Consolidate,
Report, File
Analyze &
Optimize
Plan, Forecast,
and Control
• Multiple data entry options –
users and systems
• Import from source systems
with data lineage
• Workflow to manage data
collection
• Data reconciliation and
approval
IMPACT: Quality data input, accountability and controls
ensuring effective collection of all financial data for the
close process
36
• Internal controls & audit
checklist
© 2012 IBM Corporation
Close, Consolidate, Report: Consolidate
Performance
Reporting
and Scorecarding
Business
Drivers
Centralized
system for
fast
consolidation
of results
Close,
Consolidate,
Report, File
Analyze &
Optimize
Plan, Forecast,
and Control
• Multiple entity rollups &
structures, multiple versions
• Extended business segments
• Apply automated and manual
adjustments
• Sophisticated currency
accounting
• Intercompany eliminations
IMPACT: Controlled procedures and rules in a auditable
application deliver consolidated financial results for all global
and local demands
37
• Complex ownership
adjustments, joint ventures
• Automate and schedule
© 2012 IBM Corporation
Close, Consolidate, Report: Prepare
Performance
Reporting
and Scorecarding
Business
Drivers
Execute
accounting
and financial
policy
adjustments
for external
stakeholders
Close,
Consolidate,
Report, File
Analyze &
Optimize
Plan, Forecast,
and Control
• Automated and manual
adjustments
• Text commentary
and other supporting
documents
• In-process reporting
to certify financial results
• Deliver multiple GAAP
accounts e.g. IFRS, local
GAAP, in a visible, easy-to-use
environment
IMPACT: Deliver financial results
from a single, controlled data source
38
• Track and audit different report
adjustments
© 2012 IBM Corporation
Close, Consolidate, Report: Report & Analyze
Performance
Reporting
and Scorecarding
Business
Drivers
Finance led
reporting and
analysis for
decision
making
Close,
Consolidate,
Report, File
Analyze &
Optimize
Plan, Forecast,
and Control
• Real-time in-process close
accounting reports
• Complex accounting reports for
inter-company, investments,
journal entries, etc.
• Direct access via Excel
• Leverage financial information for
financial & management reports,
ad-hoc analysis – inbuilt TM1
OLAP (FAP) Cube
IMPACT: Certified financial results supporting office of finance
reporting mandates and providing insight to all business holders
39
• World-class reporting (internal,
external and electronic),
dashboard, scorecard capabilities
© 2012 IBM Corporation
Sharing Information Across the Organization
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
and Report
Analyze &
Optimize
Risk of Errors
Plan, Forecast,
and Control
Risk of Late Filing
Feature
Benefit
Feature
Benefit
Integration to source data
No re-keying of data
User prior report as a template for the next
period
No need to re-apply formatting
Variables in text
Consistency across the report
Automatically load new data
No need to re-key data
Validation Rules
Numbers always tie-out
Start reviewing the final report sooner
One version of the truth
Feature
Benefit
Feature
Benefit
Security to view or edit each object
Users only see the data they are supposed
to see
Compliance Checklists
To ensure that the right steps are being
followed
Workflow controls access throughout
the process
Users only see data when they are allowed
to see it
Audit Trail
To track who did what, and when they did it
Access to information is controlled
40
Risk of Insider Leaks
Increased confidence in the final report
Risk of Non-Compliance
© 2012 IBM Corporation
Close, Consolidate, and Report
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
Report, File
• Account Analysis
• Close Analytics
• Financial
Consolidation
• Corporate
Reporting
• Regulatory Filing
(e.g. XBRL)
Analyze &
Optimize
Plan, Forecast,
and Control
„The IBM Cognos systems has
“We are now able to
allowed us to reduce the monthly
provide more accurate
reporting process – that 20%
data and faster reports to
time saving has been invaluable‟
senior management,” “In
doing so, we can provide
New acquisitions and customers
a more solid basis for
can be integrated into the
decision-making and
system within one month, report
operational
accuracy is 100%, rigid
improvement.”
budgeting has been replaced by
Simon Jefferis, Group Accountant, Imperial
flexible, continuous daily, weekly
Tobacco
or monthly reporting.
Angus McQueen, Group Accountant, Chemring Plc
41
© 2012 IBM Corporation
Manual processes dominate financial close
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
Report, File
Accounting
close
Financial
consolidations
External
reporting
Analyze &
Optimize
Plan, Forecast,
and Control
Output
requirements
Enterprise resource
planning (ERP)
ERP
ERP
Edgar-ready
Risk of errors, late filing, insider leaks, noncompliance
42
© 2012 IBM Corporation
What Customers Struggle With
Broken, manual processes
Performance
Reporting
and Scorecarding
Business
Drivers
Close,
Consolidate,
and Report
Analyze &
Optimize
Plan, Forecast,
and Control
There is no tolerance for mistakes and Finance teams must deliver certified, accurate, and
auditable financial results. These requirements quite often present a company with a
number of challenges:
• Manual processes dominate ―The Last Mile‖
• Extensive use of MS-Word and MS-Excel, shared via e-mail
• Data accuracy issues
• Collaboration is difficult
• No internal controls or workflow management
• No audit trail
• High degree of risk
• Inefficient and repetitive process each reporting period
43
Risk of Errors, Late Filing, Insider Leaks, Non-Compliance
© 2012 IBM Corporation
The Solution: Cognos FSR for Internal Report Process Automation
Collect
Collaborate/Edit/Approve
Report
 Driven fromEfficiency:
a central, secure database
Consolidations
Compliance
Checklists
Cognos FSR
Report

ERP
Report
Consumers
Business
Rules
OLAP
Data
Warehouse
Security
44 Reviewers
44
Contributors
Document
Managers
Business Insight:
 Leverages
the tools already
in use:
Use web templates
to automate
 Increase
time
for
analysis
through
Microsoft
Word and
Excel
data collection
from
anywhere in
reduced
data
collection
cycle times
the world
 Direct access to source data
 Harness
team insights
a multiCreate/update
contentthrough
once and
 author
Changes
dynamically updated in reports
environment
automatically
update that content
across multiple
reportsenvironment
 Guarantee
Powerful,
collaborative
consistency
of data through
integration
with
atask
single
source of the
Workflow
and
management
 truth
Workflow
and
task
management
tools provide greater visibility into

Embedded
security & validation
every step
of
the process
 Deliver
thecontrols,
latest
information
through
data updates
 real-time
Multiple output
formats
© 2012 IBM Corporation
45
© 2012 IBM Corporation
Operational Reporting
Dynamic Self Service Reports
/ Alerts / Metrics / Go Office
Cognos BI
Planning,
Analytics &
Forecasting
In Design
IBM Cognos
Controller
FSR
TM1 Turbo Integrator ETL
Virtual View Manager
(Integration to SAP R3
Source
Systems
TM1 Reporting Set / Calculation
Engine
Financial Reporting
Consolidation
Lineage
46
© 2012 IBM Corporation
IBM Case Studies
47
© 2012 IBM Corporation
IBM’s BI and FPM Legacy
IBM has invested heavily in Business Intelligence and Performance
Management
• Over 200,000 users
• Dependencies on hundreds of OLAP cubes
Brands and Geographies having developed independent solution
• Many different tools being used across organization
• Large Desktop Deployment (creating silos of BI & custom views of
data not shared with others)
• Inconsistent data usage and processes
Significant costs pressures due to
• High maintenance costs
• Supporting infrastructure dependent on desktop installs at a world
wide level
• Tools needed to front end OLAP
48
© 2012 IBM Corporation
Application: WW Spend
Adding consistency while reducing costs
Transform end to end expense management and reporting for over 400,000
departments across IBM
Enables better control of spending with consistent worldwide standards.
Common source to facilitates job movement creating more enriching career
paths for our globally across finance professionals.
600 Global Users, expanded to over 1000 in 1H2010
Business Challenge
With Cognos
•Different geographies and brands used
their own data sources and processes
supporting expense management
•Single worldwide application for Spend
Analysis and tracking on two TM1 Cubes
(Eliminating 16 Essbase Cubes)
•No standards meant systems were not tied
to key management systems.
•Increased visibility across geographies and
brands allowed for cost control optimizations
•Users were not easily moved from one
system to another
•Common processes increase career options
of financial analysts across IBM
49
© 2012 IBM Corporation
Application: WW Spend
Adding consistency while reducing costs
Consistent data and meta data standards
Data and metadata owned by line of business
users freeing IT resources
Flexible modern SOA architecture allowing for
easy expansion across geographies
"The ability to reduce from 16 disparate
Essbase cubes to just a few TM1
cubes has meant a dramatic reduction
in costs and provide more timely
access to information"
James Correa
Manager - Cognos Integration Project
Management Office
Business Challenge
With Cognos
•16 separate Essbase Cubes supporting
expense management at the geography and
brand levels.
•Single application to support common set of
skills required to use and maintain
•Lack consistent standards, and in some
cases did not tie to our key CHQ
management system
•Delays in being able to access information
due to long load times of Cubes
50
•Reduced cube load times by 80%
•Reduced calculation times from 45 minutes
to near real time
© 2012 IBM Corporation
IBM Finance Benchmark Example:
Essbase to TM1
•
1 Months Data Load
•
Calc Time Average
•
Monthly Restructure Average
―'With TM1, we were able to accelerate
our pursuit of globally integrated
processes and systems thru data/model
scalability not previously available to us―
4000
3500
60 M in
Director, Performance Management, IBM
3000
45 M in
2500
100
2000
80
1500
60
1000
40
1.6 Min
20
500
10 M in
0
TM1
Essbase
Data Load
51
0
0
0
Calc Time
Restructure
© 2012 IBM Corporation
Performance Management Strategy
Providing deployment choices to address a breadth of needs
Enabling cost effective, flexible deployment options
that align to your organization‟s needs
Desktop
Mobile
Individual
independence
Analytics on
location
Line of
Business
Workgroup
enablement
52 52
Hosted
Enterprise
Centralized and
performant
Workload
Optimized System
Shared software on
demand
Pre-integrated and
optimized
© 2012 IBM Corporation
Call to Action
Learn more about TM1
• IBM Cognos TM1 Deep Dive – Best Practices for Performance and
Scale Using TM1 10.1
Learn more about FSR
• Maximizing Opportunities with FSR Sales Plays
Learn more about Cognos Disclosure Management
• In the Labs: Transforming Finance Operations and Disclosure
Management with Cognos Solutions
Learn more about Sales Performance Management
• Introduction to Sales Performance Management - Varicent
These presentations and many more are here in the Business Analytics
area of PartnerWorld https://www.ibm.com/partnerworld/page/pw_com_sfw_bp_summit_2012
53
© 2012 IBM Corporation
Call to Action
Midmarket and Departmental Resources and links
Public on PartnerWorld
ALL Cognos Products on PW
IBM Cognos Insight Community Home Page
www.analyticszone.com
Be sure to select member sign in
• Partner Win Flashes
• Competitive Resources
• Co-Marketing
• Cognos Express Overview
• Sales and Marketing Kit
• Cognos Express Enablement
• Demand Gen Programs
• Cognos Express Demo Content
• Cognos Express Software Download
• Competitive Landscape
54
For IBM Customers
IBM Cognos Customer Support offering page
Cognos Insight customer download
IBM Cognos Insight customer announcement
letter (RFA)
IBM Cognos Insight Software License Agreement
IBM Cognos Insight Data Sheet
Cognos Training Paths and Curriculum Fact
Sheets
IBM Innovations in Business Analytics micro site
© 2012 IBM Corporation
© Copyright IBM Corporation 2008 All rights reserved. The information contained in these materials is provided for informational purposes only, and is provided AS IS without warranty of any
kind, express or implied. IBM shall not be responsible for any damages arising out of the use of, or otherwise related to, these materials. Nothing contained in these materials is intended to, nor
shall have the effect of, creating any warranties or representations from IBM or its suppliers or licensors, or altering the terms and conditions of the applicable license agreement governing the use
of IBM software. References in these materials to IBM products, programs, or services do not imply that they will be available in all countries in which IBM operates. Product release dates and/or
capabilities referenced in these materials may change at any time at IBM’s sole discretion based on market opportunities or other factors, and are not intended to be a commitment to future product
or feature availability in any way. IBM, the IBM logo, Cognos, the Cognos logo, and other IBM products and services are trademarks of the International Business Machines Corporation, in the
United States, other countries or both. Other company, product, or service names may be trademarks or service marks of others.
55
© 2012 IBM Corporation
Appendices
56
© 2012 IBM Corporation