Enterprise Analysis & Reporting Solutions Powered By IBM Cognos TM1

Transcription

Enterprise Analysis & ReportingSolutions Powered by IBM Cognos TM1 2009 IBM Corporation

Agenda Business Challenges IBM Cognos Performance Management Platform IBM Cognos TM1 9.5 Q&A 2009 IBM Corporation

With this change comes anexplosion in information Yet organizations areoperating with blind spotsLack of Insight1 in 3 managers frequently makecritical decisions without theinformation they needVolume of Digital DataInefficient Access1 in 2 don’t have access to theinformation across their organizationneeded to do their jobsVariety of InformationInability to Predict3 in 4 business leaders say morepredictive information would drivebetter decisionsVelocity of Decision Making 2009 IBM CorporationSource: IBM Institute for Business Value

Driving a Smarter Enterprise 70% of CFOs believe they have an advisory or decisionmaking role on an Enterprise NAGEMENTMENTSALESSALES Finance needs to improve its effectiveness in order todeliver on the Enterprise CHASINGPURCHASINGDriving integration of informationacross the viding inputs into enterprisestrategy51%Supporting / managing / mitigatingenterprise RCUSTOMERSERVICESERVICEEffectiveness2Measuring / monitoring businessperformance3Driving enterprise cost 100%Source: 2010 IBM Global CFO study 2009 IBM Corporation4

IBM Cognos solutions – Enabling Finance to drive LIDATEDay-to -day IBM Cognos FinancialPerformance Analytics IBM Cognos BI IBM Cognos ControllerOperational/Finance AnalysisClosing idation System)(Consolidation System)(Consolidation System)Day-to-day analysisof ledgers/transactions: G/L,AP, ARExamples: Data Input &Changes Create singlecurrencies Collect FromSubsidiaries Minority interestholdings Ad-hoc analysis Drill through totransactions Day-to-dayperformance Invoice activity Risk measures Efficiency trackingClosing Process(Accounting Processes) Intercompanyeliminations Group closing adj. Close Sub Ledgersand Systems Managementadjustments AccountReconciliation Allocations Intercompanytransactions Prepare journalentries: accruals& adjustmentsInternal Reporting Financial reporting Consolidationadjustments Cash flow & otherpreparationExternal Reporting Publish quarterly,annual t MileReporting IBM Cognos FinancialPerformance Analytics IBM Cognos Controller IBM CognosController/ FAP IBM Cognos 8 TM1/Business Intelligence IBM Cognos Controller/FAP IBM Cognos 8 TM1/ BI IBM Cognos FinancialPerformance AnalyticsReporting(Reporting Systems)(Reporting Systems) Financial reporting BIDay-to-DayFinancialReporting Financial statementpreparation Advancedformula calculationsInternal controls &ReportingcomplianceFirst ning/Modelling IBM Cognos TM1 IBM Cognos 8Business IntelligenceCompliance & Control 2009 IBM Corporation

Extending reporting capabilities –Controller 8.5 architectureSOURCESYSTEMSREAL TIMEClose ReportsTRICKLE Automated integrationwith TM1 Direct publish Incremental real timeupdates Meta gAnalysisFinancial ReportsPostProcessReporting8Dashboards 2009 IBM Corporation

Agenda Business Challenges IBM Cognos Performance Management Platform IBM Cognos TM1 9.5 Q&A 2009 IBM Corporation

BI and Performance ManagementPlan, Understand and Optimize PerformanceFinanceSalesProductDevelopmentHow arewe doing?What shouldwe be rcesWhy?IT/Systems 2009 IBM Corporation

IBM Cognos 8 Performance Management SystemUniversal CapabilitiesApplications & BlueprintsAccess & InteractivityBusiness ModelingPerformance Management PlatformInformation Infrastructure 2009 IBM Corporation

Agenda Business Challenges IBM Cognos Performance Management Platform IBM Cognos TM1 9.5 Q&A 2009 IBM Corporation

IBM Cognos TM1 A patented 64-bit read-write in-memoryOLAP engine that provides compact datastorage and exceptionally fast performance Model design and data access thatpresents business information in familiarformats Ease of use, thanks to a developmentenvironment that enables users to createsophisticated applications with no needfor programming or traditional IT skills An intuitive, flexible approach, whichenables users to easily express complex,multi-dimensional business rules Fuses Analysis & Analysis together toprovide greater accuracy A component of Cognos 8 PerformanceManagement Platform 2009 IBM Corporation

Planning AspectsAnalyzeModel4Contribution 2009 IBM Corporation

AnalyzeCapabilities: Explore Performance Gaps Validate Corporate Drivers Define “What If” Scenarios Organizational, Product Family,Product/Channel Mix Validate Planning AssumptionsBenefits: Ability to meet the dynamic needs ofthe organization . Provide a fact based approach planningprocesses 2009 IBM Corporation

IBM Cognos TM1 A patented 64-bit read-write in-memoryOLAP engine: Optimized for large data volumes Instantaneous updates from streameddata Drill through to transaction systems forgreater detailed analysis Supports multi-dimensional analysis Advanced Sorting and Ranking Public and Personal Views Familiar Excel & Web interfaces 2009 IBM Corporation

Personalized Hierarchies Create customizedconsolidations Advanced filtering: Hierarchical level Spelling pattern Attribute value Element name Expression Alias support 2009 IBM Corporation

Personal Scenarios No predetermined modelrequirements forscenarios Unlimited flexibility forend user scenariobuilding Available in all TM1clients (Excel, TM1 Web,Contributor, & Cognos 8BI) 2009 IBM Corporation

ModelCapabilities: Centralized meta-data, dataand business rule definitions Certified connectors to SAPBW & R3 Owned by Office of Finance Support of Planning BestPractices Driver based Planning Rolling ForecastsBenefits: Ability to meet the dynamic needs of theorganization Flexible to meet the broad requirements offinancial & operational planning solutions Adapts to your business process Single version of the truth for all planningprocesses 2009 IBM Corporation

IBM Cognos TM1 Modeling Expression based modelingenvironment to define planning andanalysis assumptions Can seamlessly integrate withContributor for new planning andanalysis applications On demand interactive simulation totest business scenarios Provides real time responsivenessfor large and sophisticated models An extension of the analysis process Owned by finance/business user 2009 IBM Corporation

ContributionCapabilities: Familiar Web & Excel Deployment Rich Workflow Application linkage Start small and expand enterprisewide A component of Cognos 8Performance PlatformBenefits: Timeframe-appropriate Plans High Participation & Data Volumes A Wider / Deeper View Increased accuracy 2009 IBM Corporation

Two Enriched Contribution EnvironmentsMicrosoft Excel BasedManaged Contribution 2009 IBM Corporation

IBM Cognos TM1 Excel Based ContributionEnterprise Ready Excel Based Contribution TM1 Server Explorer for power users tomaintain dimensions, cubes, rules, andintegration TM1 Excel to create rich planning andanalysis solutions TM1 Web to deploy TM1 based Excelapplications across the organization IBM Cognos 8 Business Intelligence forenterprise level analysis, scorecardingand financial & production reporting. 2009 IBM Corporation

Cognos TM1 Active Forms Drill down Self-managing reports Server-side zero suppression Top count filtering In-sheet dynamic formatting ‘On the Fly’ row contentconfiguration Stacked rows / independentlydrillable sections Active reports from multiplecubes in one sheet 2009 IBM Corporation

IBM Cognos TM1 Managed Contribution Workflow Pick lists (driver execution) Undo/Redo feature End User Personalization (Multipane docking) Personalized Scenarios Personalized Hierarchies) Color code data changes Charting Drill down Support 2009 IBM Corporation

Managed Contribution Deployment of TM1 ModelObjects Quickly Turn TM1 Objects intoManaged Applications Planning Workflow Structured Planning ProcessApprovals 2009 IBM Corporation

Agenda Business Challenges IBM Cognos Performance Management Platform IBM Cognos TM1 9.5 Q&A 2009 IBM Corporation

2009 IBM Corporation26

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 warrantyof 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 isintended 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 licenseagreement 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 IBMoperates. 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 arenot 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 ofthe 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. 2009 IBM Corporation27

IBM Cognos Financial Performance Analytics IBM Cognos BI Day-to -day IBM Cognos Controller Consolidation IBM Cognos Controller/ FAP IBM Cognos 8 TM1/ Business Intelligence Financial Reporting Analytics/ Planning/ Modelling IBM Cognos TM1 IBM Cognos 8 Business Intelligence IBM Cognos Controller IBM Cognos .