ibm cognos tm1 v10.1 demonstration and planning best practices …€¦ · 1 helping companies...
TRANSCRIPT
![Page 1: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/1.jpg)
1
Helping Companies Learn From the Past, Manage the Present and Shape the Future
IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices Overview
www.senturus.com
![Page 2: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/2.jpg)
2
Today’s Agenda
• Welcome and Introduction
• Senturus Overview
• IBM Cognos TM1 v 10.1 Demonstration
• Financial Planning Best Practices Overview
• Q & A
![Page 3: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/3.jpg)
3
GoToWebinar Control Panel
Submit questions here
Click arrow to restore full control panel
![Page 5: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/5.jpg)
5
Welcome and Introduction
• Senturus – Greg Herrera, Co-Founder, CEO
– Steve Chapman, Management
Consultant
– Chris Fargo, Office of Finance Account Manager
• IBM Cognos
– Michael Mackevicius, Technical Manager
![Page 6: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/6.jpg)
6
Who is Senturus?
• Consulting firm specializing in Corporate Performance Management
– Office of Finance
• Close, consolidate, report and file (CCRF)
• Enterprise planning & budgeting
– Business Intelligence
– San Francisco Business Times Hall of Fame -- Four consecutive years in Fast 100 list of fastest-growing private companies in the Bay Area
• Experience
– 12-year focus on performance management
– More than 1,200 projects for 500+ clients
• People
– Business depth combined with technical expertise. Former CFOs, CIOs, Controllers, Directors...
– DBAs with MBAs
![Page 7: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/7.jpg)
7
A few of our 500+ Clients
![Page 8: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/8.jpg)
8
IBM Cognos TM1 v10.1
Demonstration
Helping Companies Learn From the Past, Manage the Present and Shape the Future
![Page 9: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/9.jpg)
9
• Financial Planning Best Practices Summary • New Components in IBM Cognos TM1 v10.1
Helping Companies Learn From the Past, Manage the Present and Shape the Future
![Page 10: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/10.jpg)
10
What do companies known for best results and best practices do differently?
Streamlined information delivery
Value Integrators
Percent Adopted
100% 80% 60% 20% 40%
Constrained Advisors
Disciplined Operators
Electronic data capture at the source
Systematic data cleansing and auditing
Business Risks in Performance Reporting
Employed Functional Best Practices
Utilized automated workflow tools
Measurement & monitoring of processes
Common reporting platform
Common planning platform
% More 32%
35%
31%
22%
31%
25%
41%
31%
22%
0%
Data and Analytics
Process
Technology
Source: IBM Institute for Business Value, The Global CFO Study 2010
Scorekeepers
![Page 12: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/12.jpg)
12
Summary of FP&A Best Practices (“Do’s”)
1. Use one planning process . . . and reforecast frequently
2. Provide bottoms-up and top-down capabilities in planning models
3. Use a central planning data base for instant consolidation
4. Leverage and integrate planning across business areas
5. Distribute pre-close and final BvA reports within hours of completion
6. Automatically link account, department and product structure changes to planning models (via ERP’s, SOR’s or DW’s)
7. Support the end-users use of all appropriate business dimensions in their planning and analysis models
![Page 13: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/13.jpg)
13
TM1 v10.1 Features vs. Best Practices 1. Use one planning process . . . and
reforecast frequently (enterprise)
2. Provide bottoms-up and top-down capabilities in planning models
3. Use a central planning data base for instant consolidation (enterprise)
4. Leverage and integrate planning across business areas (dept’al)
5. Distribute pre-close and final BvA reports
6. Automatically link account, department and product structure changes to planning models (via ERP’s, SOR’s or DW/DM’s)
7. Utilize all appropriate business dimensions in planning and analysis models (departments and functions)
1. Industrial-strength planning platform with 64-bit, in memory capabilities for very large multi-dimensional cubes
2. Proportional spreads across dimensions
3. Workflow statuses for the entities and depts in organizational hierarchies
4. *Modeling power to business end-users through Cognos Insight (data analysis and prototyping)
5. *Improved BI Integration
6. *Update dimensions with Performance Modeler
7. *Utilize additional dimensions with
Cognos Insight
![Page 14: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/14.jpg)
14
Suboptimal Practices (“Don’ts”) 1. One annual, lengthy budgeting process
2. Provide only a bottoms-up planning method or model
3. Waste time chasing and consolidating distributed Excel workbooks
4. Risk silos of planning data
5. Close financial periods without line management input and distribute final BvA reports to line management weeks after closing
6. Rely on manual maintenance of planning solution structures
7. Limit planning or analysis model dimensions to General Ledger segments or only major business dimensions
![Page 15: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/15.jpg)
15
IBM Cognos TM1 v10.1 New Components
![Page 16: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/16.jpg)
16
Training Schedule and Details Here
IBM Cognos TM1 v10.1: Analyze Data and Prototype Models with Cognos Insight (1 day)
IBM Cognos TM1 v10.1: Develop and Deploy Planning Models with Performance Modeler (2 days)
![Page 17: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/17.jpg)
17
Next Steps • The next TM1 webinar in the series
– June 28 - What the heck is Cognos Insight? Planning, BI, or Both? • Cognos Insight for TM1 Planning
• Cognos Insight for BI
• Set up a call to discuss TM1 and Cognos Insight Licensing – Cognos Enterprise Planning (EP) to TM1 migration path
– Cognos Insight included free in several existing license types
• Cognos software support review – Recent clients have reduced support fees by 50% with right-sizing
• Contact - Chris Fargo – [email protected]
– 888-601-6010
![Page 18: IBM Cognos TM1 v10.1 Demonstration and Planning Best Practices …€¦ · 1 Helping Companies Learn From the Past, Manage the Present and Shape the Future IBM Cognos TM1 v10.1 Demonstration](https://reader031.vdocuments.us/reader031/viewer/2022030613/5add78d17f8b9a9d4d8d34d0/html5/thumbnails/18.jpg)
18
• Thank you for attending!!
• Now – Q & A
Wrap-up
Submit questions here