OBI12c Upgrade Experience at Liberty Global

[email protected] www.rittmanmead.com @rittmanmead OBIEE 12c Upgrade Experience at Liberty Global
Case Study Francesco Tisiot, Principal Consultant, Rittman Mead 1

[email protected] 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: [email protected] • Twitter: @FTisiot

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead Who is Liberty Global?  4

[email protected] 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 : [email protected] W : www.rittmanmead.com

[email protected] 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

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead 10g to 11g Migration?  8

[email protected] www.rittmanmead.com @rittmanmead 10g to 11 Migration 9

[email protected] www.rittmanmead.com @rittmanmead Why Upgrading?  10

[email protected] 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 : [email protected] W : www.rittmanmead.com

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead OBIEE12c Installation  13

[email protected] 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

[email protected] 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

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead Migration  17

[email protected] www.rittmanmead.com @rittmanmead Upgrade 18

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead Migration Utility Includes 20 •Migration Utility includes
• Roles/Polices • Repository • Catalog (including BIPublisher content)

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead Testing  22

[email protected] www.rittmanmead.com @rittmanmead Validation 23

[email protected] www.rittmanmead.com @rittmanmead Type of Validation 24 •Catalog Validation •Baseline
Validation Tool •User Validation

[email protected] 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/

[email protected] 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

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead User Validation 28 •Baseline Validation Tool doesn’t
test everything • Actions • iBots • Security • Print • Export • Smartview • Content Creation

[email protected] www.rittmanmead.com @rittmanmead Estimating Migration and Validation Effort  29

[email protected] www.rittmanmead.com @rittmanmead Estimating Migration and Validation Effort 30 “70%
of all statistics are made up on the spot”

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead Migration Plan  32

[email protected] 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+)

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

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)

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

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

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

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

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

[email protected] www.rittmanmead.com @rittmanmead Pre Upgrade Configuration at LGI 41

[email protected] www.rittmanmead.com @rittmanmead Pre Upgrade Configuration 42 DEV UAT PROD
VM OEL6 VM OEL6 Exalytics Exadata(s) Impala IPlanet Data Sources LDAP

[email protected] 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

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead Migration Details at LGI 45

[email protected] 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

[email protected] 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

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

[email protected] 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

[email protected] 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

[email protected] 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

[email protected] www.rittmanmead.com @rittmanmead 52 • Self-Paced Training oﬀering ﬂexibility 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

[email protected] www.rittmanmead.com @rittmanmead 53 Questions?

[email protected] 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 [email protected] • Follow-us on Twitter (@rittmanmead) or Facebook (facebook.com/rittmanmead) • Email: [email protected] • Twitter: @FTisiot

[email protected] www.rittmanmead.com @rittmanmead 55 OBIEE 12c Upgrade Experience at Liberty
Global Case Study Francesco Tisiot, Principal Consultant, Rittman Mead

OBI12c Upgrade Experience at Liberty Global

OBI12c Upgrade Experience at Liberty Global

More Decks by FTisiot

Other Decks in Technology

Featured

Transcript