Sun. Trust Enterprise Business Intelligence Delivery Services BI Tools - Cognos Center of Excellence Yolande Small-Wiggins Cognos Systems Admin Version 10. 2. 2 April 22, 2016 Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com
AGENDA ■ Overview of the BI Tools – Enterprise Co. E ■ Scope of Services ■ High level Approach to Cognos Upgrade 10. 2. 2 fp 3 ■ What’s New in 10. 2. 2 ■ Q&A Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 1
Overview of the BI Tools - Cognos Center of Excellence BI Tools Manager Cognos Application Administrator Cognos System Administrators Primary Role: Responsible for ensuring Primary Role: Creates, enhances, and applications are deployed based on best practices and evolving business requirements. maintains the reporting/cube solution environment including publication, deployment, and accessibility of the environment. Additional Roles: Cognos Metadata Administrator Cognos Release Administrator Cognos Security Analyst Additional Roles: Cognos Infrastructure Architect Cognos Security Architect Cognos Portal Administrator Backup For: Backup to System Admin Backup For: N/A ■ Strategic Project Planning ■ Development Standards & Policies ■ Corporate Training Roadmap ■ Application Profiles ■ Consulting & Advisory Services ■ Support Development Efforts Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 2
Interacting with the BI Tools - Cognos COE Project Managers ■ Cognos COE provides new Cognos staff with orientation to the development environment and standards ■ Cognos COE assists with Development Approach and Capacity Planning ■ Cognos COE provides access to data sources from Cognos Connection ■ Cognos COE implements Security group/role mapping to Cognos environments ■ Cognos COE manages deployment to QA and Production environments. ■ Cognos COE conducts Check Point reviews for code review for Quality Assurance ■ PMs initiate staffing requests by contacting BI Tools Manager ■ BI Tools Manager provides a resource ■ PMs are responsible for onboarding project staff ■ PMs are responsible for managing and evaluating project staff ■ PMs are responsible for ensuring requests to the various servicing organizations are submitted in a timely manner and that development activities are performed with governing standards. BI Tools Manager ■ If necessary, BI Tools Manager involves the Cognos COE to help screen/ interview external candidates Cognos COE Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 3
Interacting with the Cognos COE - Security Authentication ■ The Authentication process identifies who the user is through a set of credentials. For users that access the Sun. Trust Report. Net applications, the authentication will occur against the corporate active directory server. Authorization ■ Authorization stipulates what you are permitted to do within the environment once your identity has been validated. It is the process of granting or denying users access to data, and permission to perform activities on that data, based on their sign on identity. This type of security addresses two distinct areas: - Object: object level security refers to access to the components that make up the Report. Net application such as folders and reports - Data: Data level security addresses the need to protect specific rows and/or columns within a database Administration ■ Refers to the ability to manage privileges, accounts, groups, roles, assign accounts to group or roles, etc. Administraton Authorization Authentication Content Manager Cognos Namespace Content Permissions CAM Interface to Providers Authorization Authentication Providers Encryption Providers Certificate LDAP Default 40 bit (OOTB) Authority NT Domain Entrust Built in CRN CA Active Directory Open SSL Microsoft Cognos S 7 Namespace Sun One SAP Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 4
Interacting with the BI Tools - Cognos COE ■ Interactions are focused in the Centralized Activities arena: - Infrastructure - Security - Product Administration § Scheduling - Standards Development and Validation § Reporting § Metadata - Deployment - Performance Testing Analysis ■ Decentralized Activities will still be managed by the App Teams: - Project Management Requirements Gathering Metadata Modeling Report Development Application Security Administration Page 5
Scope of Services ■ BI Tools - Cognos Enterprise Environment - Management of Distributed Environments for Development, Quality and Production - Load Monitoring - Security Architecture - Capacity Planning/System Optimization - Auditing - Application Deployment - Global Configurations, Customizations and Portal Behavior - Software Buildouts - Applications Supported: Data Governance, Mortgage Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 6
Cognos Upgrade February 2016 Sun. Trust Bank | Take a step toward financial confidence Join the movement at on. Up. com
Project Objective, Scope and Business Value Objective Scope Business Value Efficiency Risk Current Cognos version support will be terminated by the vendor. To make sure right vendor support is available for Cognos in Sun. Trust, this project aims to upgrade the current Cognos tool from 10. 1. 1 to newer and supported version 10. 2. 2. § § § Migrate Cognos tool and its related components like framework manager etc. to the newer version. Migrate current production artefacts to newer Cognos version. Perform adequate testing and implement any changes required to be compatible with the new Cognos version. § Cognos tool is enterprise reporting tool for Sun. Trust and used by all LOBs in Sun. Trust. Adequate support from vendor is key for new report development and analytics. § Analytical and new business development programs leverage Cognos for data analytics and key business decisions. Unavailability right support from vendor will drive losses in revenue. 8 Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Growth & Profitability Efficiency
Solution Architecture 9 Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com
Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 10
Risks/Issues # Probabili Impact ty Type Owner Description Opened Target Actual on Close Issue: Cognos Framework manager, Cube manager and Transformer are not able to connect to DB when trying to open from Citrix. 1 M M Solution BICE team Impact: Developers not able to perform any changes or new developments using Citrix Mitigation Plan/Steps: Working with Citrix team to to resolve the issue. 11 Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com 01/15
Testing Execution Highlights § Completed the execution of all reports in Public Folders – 36 reports changed and tested to be compatible with Cognos 10. 2. 2. § Work in progress – 43 report failures are being analyzed and retested * Testing Not Required – As requested by business team(s) not to test certain reports, reports that are disabled in production and duplicate reports Automated Testing Manual Testing Recent Migrations Total Objects [A] 11410 3719 96 Executed Objects [B] 7105 1814 94 # Passed [C] 7050 1784 93 # Analysis in progress [D = B-C] 12 30 1 Testing Not Required [E] 4305 1903 2 % Pass [F = C/B] 99% 98% 99% % Completion [G = (C+E)/A] 100% 99% Warnings/Gotchas: Must get three Fix. Pacts installed after Upgrade • Framework Manager Issues/problems • Fixpacts must be installed in sequential order (1, 2, 3 etc. per IBM’s recommendation Total 15225 9013 8927 43 6210 99%
SUCCESS!!!! 13 Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com
Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 14
Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 15
Q&A ■ Questions? Sun. Trust Bank | Take a step toward financial confidence. Join the movement at on. Up. com Page 16
Скачать презентацию Sun Trust Enterprise Business Intelligence Delivery Services BI
f463a36e538b5dfae3194a2abf4f1f4f.ppt