OBI12c Upgrade Experience at Liberty Global

Transcript

1. info@rittmanmead.com www.rittmanmead.com @rittmanmead OBIEE 12c Upgrade Experience at Liberty Global Case Study Francesco Tisiot, Principal Consultant, Rittman Mead 1
2. info@rittmanmead.com www.rittmanmead.com @rittmanmead About the Speaker 2 • Francesco Tisiot • Principal Consultant at Rittman Mead • Based in Verona, Italy • Writer for Rittman Mead Blog - http://www.rittmanmead.com/blog/ • Over 9 years of experience in BI • Email: francesco.tisiot@rittmanmead.com • Twitter: @FTisiot
3. info@rittmanmead.com www.rittmanmead.com @rittmanmead About the Rittman Mead 3 •Oracle BI and DW Gold partner •Winner of several UKOUG Partner of the Year awards including BI •World leading specialist partner for technical excellence, 
 solutions delivery and innovation in Oracle BI •Approximately 100 consultants worldwide •Experts in BI, DW and Big Data •Offices in US (Atlanta), Europe •Skills in broad range of supporting tools: - OBIEE, OBIA, Essbase, Oracle OLAP - GoldenGate, ODI - Big Data • Partnership with Cloudera and Amazon
4. info@rittmanmead.com www.rittmanmead.com @rittmanmead Who is Liberty Global?
 4
5. info@rittmanmead.com www.rittmanmead.com @rittmanmead About Rittman Mead 5 T : +44 (0) 1273 911 268 (UK) or (888) 631-1410 (USA) or 
 +61 3 9596 7186 (Australia & New Zealand) or +91 997 256 7970 (India) E : info@rittmanmead.com W : www.rittmanmead.com
6. info@rittmanmead.com www.rittmanmead.com @rittmanmead Liberty Global 6 ‣ Country Operations ‣ Active in 14 countries ‣ As of March 31st, 2016: ‣ 54 million homes passed ‣ 27 million customers ‣ 57 million RGUs (video, internet, and voice subscribers) ‣ 7 million mobile subscribers and 6 million WiFi access points ‣ Revenue: $18.4 billion ‣ Liberty Global Ventures ‣ Digital to Home
7. info@rittmanmead.com www.rittmanmead.com @rittmanmead Rittman Mead and LGI 7 2012 RittmanMead BI team growth within LG 2011 LG and RittmanMead partner up in BI 2013 RittmanMead consolidated partner of LG BI Team 2014 LG and RittmanMead Partner in BD 2015 Consolidated partnership in BI & BD possibility in Analytics SCM Operational KPIs eDWH Video Reporting NPS Audience Measurement 2015 LG and RittmanMead Long term BD partner
8. info@rittmanmead.com www.rittmanmead.com @rittmanmead 10g to 11g Migration?
 8
9. info@rittmanmead.com www.rittmanmead.com @rittmanmead 10g to 11 Migration 9
10. info@rittmanmead.com www.rittmanmead.com @rittmanmead Why Upgrading?
 10
11. info@rittmanmead.com www.rittmanmead.com @rittmanmead Why Upgrading? 11 T : +44 (0) 1273 911 268 (UK) or (888) 631-1410 (USA) or 
 +61 3 9596 7186 (Australia & New Zealand) or +91 997 256 7970 (India) E : info@rittmanmead.com W : www.rittmanmead.com
12. info@rittmanmead.com www.rittmanmead.com @rittmanmead OBIEE12c New Features 12 ‣ Simplify and lower cost of admin and operations ‣ Improve user experience ‣ Enable advanced analytics for everyone ‣ Support more data sources ‣ Enhance mobile experience ‣ Data Visualization ‣ Data Mashups ‣ Updated Look and Feel ‣ Enhanced Big Data Connectivity
13. info@rittmanmead.com www.rittmanmead.com @rittmanmead OBIEE12c Installation
 13
14. info@rittmanmead.com www.rittmanmead.com @rittmanmead Prerequisites 14 •Migration Tool works with 11.1.1.7 and 11.1.1.9 •Prerequisites Checks • OEL6 • JDK 1.8+ • Browser Versions - IE11.* FF 31+ • Database - 12.1.0.1+ 11.2.0.4+ •Review Server Capacity • Additional Server Load - Visual Analyser / Data Mashup
15. info@rittmanmead.com www.rittmanmead.com @rittmanmead Installation 15 • No In-place migration option • Software Download through Oracle’s Website • Installation Steps • JDK 8 • Weblogic 12c • OBI 12c Deployment • OBI 12c Configuration
16. info@rittmanmead.com www.rittmanmead.com @rittmanmead Additional Steps 16 • Admin Tool • Start/Stop Scripts • Log Files Location • Code Promotion Process • Code Versioning - RPD - Catalog - Security • Training https://speakerdeck.com/rmoff/source-control-code-deployment-and-concurrent-development-for-obiee-12c
17. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration
 17
18. info@rittmanmead.com www.rittmanmead.com @rittmanmead Upgrade 18
19. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration 19 •Migration Utility • Compatible only with 11.1.1.7 and 11.1.1.9 •Migration Steps • Export Migration utility jar file from 12c installation • Create 11g export bundle • Stop 12c Services • Import the export bundle in 12c • Import during Configuration phase or with migration-tool.sh • Start 12c Services
20. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Utility Includes 20 •Migration Utility includes • Roles/Polices • Repository • Catalog (including BIPublisher content)
21. info@rittmanmead.com www.rittmanmead.com @rittmanmead • Console settings • SSL • Security Realm Configuration (Authentication, Authorisation) • Local WL User and Groups • Additional Deployments • Apex, AnalyticsRes • Usage Tracking • Agent Schedule • BI Publisher Schedule and Configuration • Single component (BIPS, BIS) Configuration • Additional Configurations (UserScripts.js) Migration Utility Doesn’t Include 21
22. info@rittmanmead.com www.rittmanmead.com @rittmanmead Testing
 22
23. info@rittmanmead.com www.rittmanmead.com @rittmanmead Validation 23
24. info@rittmanmead.com www.rittmanmead.com @rittmanmead Type of Validation 24 •Catalog Validation •Baseline Validation Tool •User Validation
25. info@rittmanmead.com www.rittmanmead.com @rittmanmead Catalog Validation 25 •Check of Catalog Corruptions • Pre-Upgrade and Post-Upgrade • ValidateAccounts • ValidateHomes • ValidateItems • ValidateLinks https://www.rittmanmead.com/blog/2016/11/performing-a-catalog-validation/
26. info@rittmanmead.com www.rittmanmead.com @rittmanmead Baseline Validation Tool 26 •Baseline Validation Tool • Compatible with 11.1.1.7 and 11.1.1.9 •Automated Testing • Report • Dashboard • LogicalQuery • Catalog • UI •Compares two Baselines • Pre and Post Upgrade • On the whole Catalog or only a part of it •Can be used to validate changes between environments
27. info@rittmanmead.com www.rittmanmead.com @rittmanmead Baseline Validation Tool 27 •Configuration File • PreUpgrade and PostUpgrade • OBIEE’s Analytics URL • Test details • Type of Test • Type of Browser to Use for UI Comparison • Part of The Catalog to scan • Number of Concurrent Threads • Thresholds • Small differences can be expected (e.g. in logos) • Timeouts
28. info@rittmanmead.com www.rittmanmead.com @rittmanmead User Validation 28 •Baseline Validation Tool doesn’t test everything • Actions • iBots • Security • Print • Export • Smartview • Content Creation
29. info@rittmanmead.com www.rittmanmead.com @rittmanmead Estimating Migration and Validation Effort
 29
30. info@rittmanmead.com www.rittmanmead.com @rittmanmead Estimating Migration and Validation Effort 30 “70% of all statistics are made up on the spot”
31. info@rittmanmead.com www.rittmanmead.com @rittmanmead Estimating Migration and Validation Effort 31 •Test Migration • Test Server Installation • Perform Migration • Select List of Dashboards • Run BVT • Analyse the Outcome
32. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Plan
 32
33. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 33 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live •Server • OS • Packages • Capacity •Browser •Database •11g Version in supported list (11.1.1.7+)
34. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 34 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live •JDK 1.8 •Weblogic 12c •OBIEE 12c • Deployment • RCU • Configuration
35. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 35 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live •Console Configuration • SSL • Security Provider(s) • Local WL Users • Additional Deployment(s) • Components (BIPS, BIS, …) Settings • Additional Configuration (Mapviewer, Apex)
36. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 36 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live • Create 11g Export Bundle • Import Bundle in 12c • Migrate BIP Settings and Schedule • Migrate Agents Schedule
37. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 37 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live •Baseline Validation Tool • Select the features • Select the list of Dashboard Pages and Analysis • Set the BVT Configuration File • Create the Baselines • Compare Results
38. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 38 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live • Not all testing can be performed automatically (e.g. actions) • Selected End Users perform additional testing • Collect Feedback
39. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 39 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live •Analyse Baseline Validation Tool output • Refine BVT parameters (e.g. Threshold) • Scan other parts of the Catalog • re-execute BVT if needed •Analyse Feedback from End User Testing •Fix bugs and issues
40. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 40 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live • Redirect Users to 12c Environment
41. info@rittmanmead.com www.rittmanmead.com @rittmanmead Pre Upgrade Configuration at LGI 41
42. info@rittmanmead.com www.rittmanmead.com @rittmanmead Pre Upgrade Configuration 42 DEV UAT PROD VM OEL6 VM OEL6 Exalytics Exadata(s) Impala IPlanet Data Sources LDAP
43. info@rittmanmead.com www.rittmanmead.com @rittmanmead Single Server View 43 RCU Schemas IPlanet LDAP Database Map Schema OBI Server Multiple Authentication Providers Mapviewer Intra Components SSL Apex APEX Schemas
44. info@rittmanmead.com www.rittmanmead.com @rittmanmead OBIEE Details 44 •800 registered users ‣ 100 users active per day ‣ 20 concurrent users •Over 50 Subject Areas ‣ Row Level Security ‣ Subject Area Security •Over 30 Official Dashboards ‣ Over 300 Dashboard Pages ‣ Over 1200 Analysis
45. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Details at LGI 45
46. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Details at LGI 46 •Same box installation ‣ 12c Installed where 11g is running • No Space constraints • OS Compatible ‣ 12c Automated Testing done during out of business hours • BVT can run a # of parallel threads ‣ Go Live -> Switch 12c Managed Server ports to the default used in 11g •Bugs fixed in DEV promoted to UAT and Production ‣ Archive and Unarchive for Catalog Objects ‣ Stored fixed versions of the RPD and merge •Same Date or Week Environments Go Live
47. info@rittmanmead.com www.rittmanmead.com @rittmanmead But…. 47 •Exalytics Image on OEL5 ‣ Upgrade Plan over Weekend • Backup old OEL5 env • Installed OEL6 Exalytics Image • Reconfigured OBI 11.1.1.9 ‣ Backup Plan • Use UAT as Production ‣ Apache server redirecting traffic
48. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Steps 48 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live DEV 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live UAT 12c Prerequisites Check OBI 12c Installation OBI 12c Configuration OBI 12c Migration OBI 12c Automated Testing End User Testing Testing Review and Bug Fixing Go Live PROD OEL6 Image Deployment
49. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Key Points 49 •Prerequisite analysis must be done Upfront for all environments •DEV Configuration is a First Milestone for ‣ Security Integration ‣ SSL ‣ Single Component Configuration •11g Bundle Export and Import in 12c can be performed multiple times ‣ Checklist of all errors and solution can be created and migration completely tested •BVT ‣ Thresholds can be fine-tuned in DEV and UAT ‣ Can be run for a single Catalog folder ‣ List of Relevant Dashboard
50. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Key Points 50 •User Testing is done in DEV, UAT and PROD ‣ DEV User Testing • Aimed at Power users, Global testing of the environment ‣ UAT User Testing • Dashboard and Analysis Creators from the Affiliates use UAT as development environment. • Catalog Artefacts (Dashboards) are created directly in UAT ‣ PROD User Testing • Analyst work directly in Production, mostly creating analysis on the fly
51. info@rittmanmead.com www.rittmanmead.com @rittmanmead Rittman Mead Suggested Initiatives 51 •Performance Analytics ‣ System evaluation ‣ Diagnostic Toolkit ‣ Custom Dashboard ‣ Ongoing support •Commmentary - Chit Chat ‣ Conversation Capabilities into Dashboards •12c Training
52. info@rittmanmead.com www.rittmanmead.com @rittmanmead 52 • Self-Paced Training offering flexibility around your busy schedule • Use to refresh knowledge on previously learnt lessons & exercises • Courses written & delivered by Oracle ACE experts • Learn - Use Rittman Meads LMS as your virtual classroom to access all course videos, demos & labs • Practice - Get hands on with your very own cloud based training environment (OBIEE, ODI etc) • Engage - Have the chance to send questions to Rittman Meads Principal Trainer network On Demand Training
53. info@rittmanmead.com www.rittmanmead.com @rittmanmead 53 Questions?
54. info@rittmanmead.com www.rittmanmead.com @rittmanmead Thank you for Attending 54 • Thank you for attending this presentation, and more information can be found at http://www.rittmanmead.com • Contact us at info@rittmanmead.com • Follow-us on Twitter (@rittmanmead) or Facebook (facebook.com/rittmanmead) • Email: francesco.tisiot@rittmanmead.com • Twitter: @FTisiot
55. info@rittmanmead.com www.rittmanmead.com @rittmanmead 55 OBIEE 12c Upgrade Experience at Liberty Global Case Study Francesco Tisiot, Principal Consultant, Rittman Mead