WIXLIB

WHAT’S NEW IN COGNOS BI VERS. 10.2.2Overview of Added Features and Functionalities

GoToWebinar Control PanelSubmit questions hereClick arrow to restore fullcontrol panelCopyright 2014 Senturus, Inc. All Rights Reserved2

Presentation Slide Deck on www.senturus.comCopyright 2014 Senturus, Inc. All Rights Reserved3

Today’s Agenda Introductions What’s New in IBM Cognos BI Version 10.2.2 10.2.2 Demonstrations Cognos Disclosure Management (CDM) Introduction Senturus Introduction Additional Resources Q&ACopyright 2014 Senturus, Inc. All Rights Reserved4

Introduction: Today’s PresentersStefanConstantinidesGreg HerreraPresident & CoFounderSolution AdvisorNorth AmericaSenturusIBMDon DavisClient Technical Professional –Business AnalyticsIBMCopyright 2014 Senturus, Inc. All Rights Reserved5

WHAT’S NEW IN COGNOS BIVERSION 10.2.2Added Features and Functionalities Overview

Stefan Constantinides, sconstan@us.ibm.comEnabling Foundational Self-Service withCognos Business Intelligence V10.2.2 2014 IBM Corporation

IBM Cognos Business Intelligence V10.2.2Enabling Foundational Self-Service Speed deployment to enable foundational self-service Streamline the report creation process to save time and makeauthors more efficient Empower more users with increased personalization and moretargeted capabilities8 2014 IBM Corporation

Speed deployment to enableFoundational self-service9 2014 IBM Corporation

Targeted profiles will engage even more users andmake them more self-sufficientCustomize profiles inReport Studio &Workspace Advanced10Views based on skilland requiredfunctionalityEnables more users tobe Self-Sufficient 2014 IBM Corporation

Use ‗quick set-up‘ to easily install & configure allCognos BI components for testing and prototyping11 2014 IBM Corporation

Increase confidence by managing security at the individualuser level in multi-tenant deployments12 2014 IBM Corporation

Leverage high performing Dynamic Cubes by quicklymigrating existing Framework Manager models13 2014 IBM Corporation

Proactively plan your upgrade using theCube Designer Hardware Sizing Guide14 2014 IBM Corporation

Support users with a broad range of disabilities with broadenedaccessibilityUS Section 508 Compliant,from modeling through toauthoring15Supports assistivetechnologiesProduce fully accessible,compliant reports. 2014 IBM Corporation

Conformance UpdatesApplication Server SAP NetWeaver Application Server 7.4Content Store DB2 for z/OS 11 Microsoft SQL Server 2012 R2 Microsoft SQL Server 2014Portal Servers WebSphere Portal 8.5 Liferay PortalSecurity Libraries GSKitWeb Servers Apache HTTP Server 2.4 Microsoft Internet Information Services 8.516Datasources Cloudera Impala 1.3 Netezza 7.1, 7.2 DB2 for i5/OS 7.2 TM1 10.2.2 InfoSphere BigInsights 2.1, 3 Apache Hive 0.11, 0.12 Microsoft SQL Server 2012 R2, 2014 Microsoft SQL Server Analysis Services 2012 R2,2014 MySQL 5.7 PostgreSQL 9.3, 9.4 Teradata 15Drivers JT400 JDBC driver (DB2 iSeries)Mobile iOS8 Android 4.4 2014 IBM Corporation

Streamline the report creationprocess to save time and makeauthors more efficient17 2014 IBM Corporation

Build a report once and create a consistent corporateidentity with reusable style templatesDefine Styles forstandardized reporting18Create Templates forgroups to provide astarting pointSimplify ReportMaintenance byUpdating Styles Once 2014 IBM Corporation

Leverage the new visualization capabilities and customizethem directly in Report Studio Extensible visualization properties are exposed in Report Studio & Workspace Advanced Extensible visualization data slots are now flexible, use only those that you need.19 2014 IBM Corporation

See changes to your reports in real-time and speedauthoring with Active Report Live Preview20View Active ReportContent in ReportStudio DirectlyChange Layout toMatch Device Outputor CustomMake FormattingChanges Directly inPreview Mode 2014 IBM Corporation

Empower more users withincreased personalizationand targeted capabilities21 2014 IBM Corporation

Quickly upload and easily model personal data sourcesfor end-to-end analysis with My Data Sets Upload CSV, XLS, XLSX, and create reports and dashboards Manage uploaded data files without IT Administrators can define who has privilegesData in aCSV orExcel File22Upload toCognosBISimpleModelingAuthorReports 2014 IBM Corporation

Quickly focus your analysis by using Dynamic Filters inCognos WorkspaceCreate interactiveYOU dashboardsCAN THROUGHfor easyCOGNOSanalysisBI 10.NEXTDefine custom buttonsthat specify a filteractionFilter related widgetsby selecting values23 2014 IBM Corporation

Learn more about these exciting innovationsat www.AnalyticsZone.Com See the new features in action Read blogs on key topics from product experts Test drive a trial version of Cognos BI V10.2.2 Let us know what you think!1.2.„Sign up‟ or „Sign in‟ to www.AnalyticsZone.ComClick on Downloads and Trials and select “Business Intelligence” on the menu 24 2014 IBM Corporation

IBM Watson Analytics & Cognos Business IntelligenceCloud-based agile analytics forbusiness usersGuided flexible exploration withcognitive computing andautomated visualization selectionAutomated discovery ofcombinationsand permutations of data providingnew answersA standardized gateway tomaximizeBusiness Intelligence value acrossthe EnterpriseFoundational Business Intelligencefor the EnterpriseSupport for multiple data sourcesand operating environments withcustomizable visualizationsA known and trusted analyticsfoundationProvides a baseline of informationto feed Watson Analytics acrossone integrated and supportedenvironmentExploration and InnovationValue and TrustWatson AnalyticsCognos Business IntelligenceIndividual Self-SufficiencyFoundational Self-ServiceRevolutionize how your business transforms data into meaningful insights25 2014 IBM Corporation

Stefan nos 10.2.2 2014 IBM Corporation

Stefan Constantinidessconstan@us.ibm.comCognos Disclosure Management (CDM)Introduction 2014 IBM Corporation

CDM Deployed at Amazon HUGE time saver!!!– Now with using CDM it takes 5 minutes to generate the monthly executive level reportthat used to take a minimum of 3 hours to cobble together. CDM is rapidly becoming irreplaceable at Amazon.– One of the Amazon team described it to me as something as essential as turning thelights on. How? 2014 IBM Corporation

Specific and underlying reporting problemsModelling EngineThe ―DoTheit Again‖ProblemProblemCollaborative Everymonthmeansallreportsneed to be andDocumentsinformationTheCutPasteandProblem kdrivecurrentorfrompassedaroundemail, textreflecttheperiod orsReviewersConsolidations ERPOLAP The template formsare replicated acrossmany solo and groupentities. on aare shared extensive XBRL otesoryellowstickypadsLastchanges to actual results, budgetsorrequiresforensic minuteTitle pagesreview and validation.the previouspresentation. driveNo versioncontrolto coordinate contributionstoforecastsextensiverework FP&ADatereferencesintext Data sources may notwantscontrolover the reporting process.thecanreportData integritybe compromisedbe synchronised but ectly? Noapprovalprocessoraudittrailtotoensureneed toIterative change and control process complexalltemplates WhoDatesthatdrivereportedmadewhatchangesand why?tie out with oneconsensusof theone dataversionof the truthcoordinateandtimeconsuminganother. Novisibility or control over the processor Datareported Every instance mustsources of informationchange when theApproversDocumentManagersData Warehousesource changes.ReportConsumersRisk ManagementEnterpriseData Sources 2014 IBM Corporation

How IBM Cognos Disclosure Management (CDM) addresses the problems Leverages Existing tools in Use;Word, Excel, etc. Reports directly integrated with datasources so they can be rolled forward.Master documents can be cascaded.Modelling EngineIBM CDM Changes dynamically updated inreports eg numbers within textConsolidationsComplianceChecklists Provides a powerful multi-user,collaborative AP Evidence of compliance, reportvalidation, access control and audittrails reduce operational riskData WarehouseSecurityRisk ManagementContributors DocumentManagers Workflow and version controls deliverprocess transparencyEDGAR Reports driven from a single, securedatabase so stakeholders andconsumers get a consistent view Multiple output formatsReviewers Integrated XBRL taxonomy, XBRLvalidation and pre-tagged templatereports30 2014 IBM Corporation

Organizations are relying on outdated tools and processes tomeet mandated reporting requirements1Abundance ofreports ses3High Risk oferrorsAccording to 43% of banking CFOs, there are current systemlimitations due to sub-optimal systems and processesSOURCE: The Hackett Group 2014 IBM Corporation

What We Deliver!Employ arepeatableprocessStreamlinereportassemblyMake betterdecisionsInstead of navigatinggaps in the productionof recurring reportsover and over againInstead of manuallypiecing togetherMicrosoft Word,Excel andPowerPoint filesInstead ofinterpreting ―justread‖ data, get tounderstanding rightaway 2014 IBM Corporation

Recurring, multi-author reports create the same problemsManagementreportsInternalreportsExternal ateand report Time is spent on low-value work (data/text, copy/paste, editing, validation) Limited time for specialists to make insightful decisionsSlow, manual, recurring processFacts within reports can be out of date before the report even publishedNo compliance or controls during the process 2014 IBM Corporation

Cognos Disclosure Management (CDM) solution features Replace tools and manual processes with a proven reporting solution used by300 customers worldwide Filing packages provide all the templates and XBRL connectivity that you need Familiar MS Office interface for ease of use Reduce the risk of errors with strong data integration Built in workflow plus full audit trail provides visibility and transparency Reports cascading for easier reporting of multiple subsidiaries Rollover capabilities reduce reporting for future cycles and provide an easytransition between periods and mandate versionsIBM Customers that use CDM to meet mandated reporting requirements save time,gain control and governance over the process and reduce the risk of errors. 2014 IBM Corporation

Use Cases for Cognos Disclosure Management (CDM)Finance and AccountingOperationsHuman ResourcesIndustry MandatedHeadcount ReportingPubilc Sector -- CAFRBenefits—Employee Comms.LifeSci – Clinical Trials ReportsInternal ReportingMonth & Quarter-EndManagement ReportsEEOC Compliance ReportingBoard BooksPension AdministrationHealthcare – FDA ComplianceUtilities/Energy -- FERCFinServ – Basel I, II, IIIUnion Compliance ReportsFinServ – Dodd-FrankManagement PresentationsFactory Safety ReportingFinServ – SEC, FINRA, etc.Profitability Analytics –Customer, Geo, Channel Employee Skills InventoryBusiness Unit PerformanceExternal ReportingSEC Filings – 10K, 10Q, 20FAnnual ReportIT Systems & OperationsPerformance or Pay –Employee ReportingSupply Chain/ProcurementSupply Chain PerformanceRegulatory / Public AffairsSustainability/GRI ReportingPress ReleasesSupply Chain OptimizationMarketing & CustomerManagementSecurity & ComplianceManagementVendor PerformanceProduct Line P&L‘sMaterials Hedging ReportsCampaign EffectivenessLicense Deployment ReportsPurchase Variance AnalysisE-Commerce Metric Analytics 2014 IBM Corporation