Upgrade to Pro — share decks privately, control downloads, hide ads and more …

OBI12c Upgrade Experience at Liberty Global

FTisiot
December 07, 2016

OBI12c Upgrade Experience at Liberty Global

FTisiot

December 07, 2016
Tweet

More Decks by FTisiot

Other Decks in Technology

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 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. info@rittmanmead.com www.rittmanmead.com @rittmanmead Migration Utility Includes 20 •Migration Utility includes

    • Roles/Polices • Repository • Catalog (including BIPublisher content)
  14. 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
  15. 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/
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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+)
  21. 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
  22. 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)
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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
  30. 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
  31. 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
  32. 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
  33. 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
  34. 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
  35. 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
  36. 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
  37. 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
  38. 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
  39. info@rittmanmead.com www.rittmanmead.com @rittmanmead 55 OBIEE 12c Upgrade Experience at Liberty

    Global Case Study Francesco Tisiot, Principal Consultant, Rittman Mead