Upgrading OBIEE To Power Analytics With OAS
Upgrading OBIEE toPower Analytics with OASAnDOUC TechCast Days - February 18, 2021Darrell Sandfoss, BI Architect at East Kentucky Power CoopJames Binkley, Database Analyst at East Kentucky Power CoopDan Vlamis, President at Vlamis Software SolutionsCopyright 2021, Vlamis Software Solutions, Inc.
Not-For-Profit generation and transmission electric utility serving 16member-owned co-ops Provides electricity to more than 1.2 million Kentuckians in 87 counties BI has historically been used to look at financial data in a ‘descriptive’manner (i.e. hindsight what happened?). To date, a majority of the dashboards focus on financial data, and inparticular ledger actual spend vs budgeted dollars. BI is primarily intended for use by managers to stay within budget, analyzecosts, and compare the two across time. BI is also a tool often used to research questions by accounting and relateddepartments.
Vlamis Software Solutions Vlamis Software founded in 1992 in Kansas City, Missouri Developed 400 Oracle BI and analytics systems Specializes in Oracle-based: Enterprise Business Intelligence & AnalyticsAnalytic WarehousingMachine Learning and Predictive AnalyticsData VisualizationETL and data integration Multiple Oracle ACEs, consultants average 15 years Creators of the Force Directed Graph Plugin on Oracle Analytics Library www.vlamis.com (blog, papers, newsletters, services) Co-authors of book “Data Visualization for OBI 11g” Co-authors of book “Essbase and Oracle OLAP”Copyright 2021, Vlamis Software Solutions, Inc.
EKPC Background Situation at EKPC Large legacy OBIEE systemHad a series of OBIEE dashboards. Move forward or not?Visualization of OBIEE - OAS vs Tableau for adhoc access?Consider cloudDropped support for 11g BI / ODI environment several years ago Stuck at older database version due to BI compatibility Business goals - EKPC bought OBIEE for a reason Goal to improve centralized reportingConsolidated reporting – believed in consistent truth sourceBest solution was to stay with Oracle and get current and use new featuresContinued stability of data and interfaceRework foundation to allow for support and future consideration of enhanced reportingmethods Cloud vs not cloud – OAS vs OAC Was not on-prem solution for Oracle Analytics Waited for non-cloud solution Vlamis helped position Oracle Analytics as a non-cloud solutionCopyright 2021, Vlamis Software Solutions, Inc.
Approach for Project – High level Migrated entire OBIEE application Didn’t really consider BI Apps content separate from customizations.All is just data. Migrate all dashboards – don’t change anything Kept Oracle 12.1 on-prem DB exactly the same Opted to upgrade front end before backend 1. Migrated OBIEE - OAS first 2. BI Apps / ODI migration Wanted demo of DV capabilities to management Had project plan – Vlamis did most of workCopyright 2021, Vlamis Software Solutions, Inc.
Results Completed on time and under budget Went very smoothly – EKPC was able to move quickly Upgrade was pretty painless Vlamis answered questions throughout project Able to re-use old dashboards, so easy to migrate users Run in parallel with OBIEE Demoed to users. No formal training needed since update istransparent to users if don’t use new featuresCopyright 2021, Vlamis Software Solutions, Inc.
Background on OBIEE - OAS/OAC Background on OAS/OAC vs OBIEE. DV included in OAS now. Not hard to move. Worth it. If using BI Apps can move to BI Apps 10.3 Technology upgrade – moves to Weblogic 12c, ODI 12c Runs on OBIEE 12.2.1.4, OAC or OAS No significant change to BI Apps itself EKPC move No complications from automated agents orsignificant customizationsCopyright 2021, Vlamis Software Solutions, Inc.
OAS Catches Up to OAC Once a YearMay 2018OAC 4Sep 2018OAC 5Jan 2019OAC 19.1.1Feb 2019OAC 105.2Jun 2019OAC 105.3Oct 2019OAC 105.4Feb 2020OAC 5.5May 2020OAC 5.6Jul 2020OAC 5.7Sep 2020OAC 5.8Jan 2021/Mar 2021*OAC 5.9OBIEE 12.2.1.4OAS 5.5OAS 5.9* This is a planned ETA by Oracle Product Management and not confirmed for general availabilityCopyright 2021, Vlamis Software Solutions, Inc.
OAS & OAC Minimal DifferencesOASOAC Runs on premise Runs on Oracle Cloud Run in data center or “in the cloud” Customer administers Pay extra for includes DV interface Data modeling same (RPD, XSA) Pay for license and support Sold by license sales force Annual releases Can change configuration filesCopyright 2021, Vlamis Software Solutions, Inc. Can run on “cloud at customer” Have private instance (unlike BICS) Includes DV interface Data modeling same (RPD, XSA) Pay by the hour or month Sold by cloud sales force Monthly/Quarterly releases Includes Day by Day for mobile,Language Narrative Viz Data Replication
OBI - OAS Migration Process OverviewWebLogic ServerWebLogic PatchOBIEE 11g11.1.1.9OAS11g BundleDeployOBIEE 12c12.2.1.xBar fileOAS New InstanceCopyright 2021, Vlamis Software Solutions, Inc.Webinar on migrating from OBIEE to OAS
Project Details - Process Entire project done remotely During COVID time Install done via Linux login Basically exported – imported EKPC was on OBIEE 11.1.1.9 Generated export bundle from OBIEE 11.1.1.9 Followed the steps in documentation Used command line per documentation Personal reports came over as well Vlamis did most of work Used with MS Teams. Instant messages back and forth. Weekly project reports. Status report with hours.Copyright 2021, Vlamis Software Solutions, Inc.
Project Details – Back End Biggest issue was a bunch of warnings in RPD file – lots ofwarnings. 11g allowed, but in 12c were warnings. Muchreplication in BI Apps. LOTS of warnings. Your mileage mayvary. External authentication needed no changes, security migratedwith the export bundle Set Weblogic to use external authentication. Uses SSO. Implemented SSL with SSO. Signons are now encrypted fromBI Server to LDAP server. Easier In 12 than in 11 OBIEE.Copyright 2021, Vlamis Software Solutions, Inc.
Warnings in RPD file – mostly from OBIEECopyright 2021, Vlamis Software Solutions, Inc.
Project Details – Front End Difference in styles – Fusion FX vs Alta – know it looksdifferent. EKPC ended up using the new Alta style Some custom things had to be adjusted Logos on reports didn’t line up Vlamis helped EKPC fix issues Minor spacing issues Couple formulas to be adjusted for treatment of nulls Null dates changed to 1900 dateCopyright 2021, Vlamis Software Solutions, Inc.
Timeline Started Sept 1, 2020 with prep meeting then delayed Really started October 3 Mostly done by October 24 Documentation and training done November 5 Most of work done in 3 weeks Demo at end System in production nowCopyright 2021, Vlamis Software Solutions, Inc.
Benefits Allows to retire old hardware Users appreciate updated interface. Cleaner, modern look No loss of functionality No change to navigation Now supported by Oracle Performance similar to OBIEE Reliability similar Adoption similar Data visualization now built inCopyright 2021, Vlamis Software Solutions, Inc.
The Future Now interested in putting formulas in RPD file instead ofreports Considering new dashboards in DV Reconsidering Adhoc capabilities now have data visualization Whole new audience Need to explain measures, dimensions, etc. Excited about futures Machine learning, mashups, maps, etc. There has always been a hope and desire to eventually movetoward showing the data in a ‘diagnostic’ and even ‘predictive’manner.Copyright 2021, Vlamis Software Solutions, Inc.
New Possibilities in OAS with DVCopyright 2021, Vlamis Software Solutions, Inc.
Migrate OBIA 10.1 on OBIEE to 10.3 on OASOBIA 11.1.1.10.1Out of Place MigrationWebLogic 11gOAS 5.5OBIEE 11gODI 11gOracleDB 12.2In Place UpgradeOBIA 11.1.1.10.3OBIA 11.1.1.10.2WebLogic 12gWebLogic 11gOut of Place MigrationOBIEE 11gODI 11gOBIEE 12gODI 12gDWCopyright 2021, Vlamis Software Solutions, Inc.DW
Conclusion Worth making the move Capitalized on existing investments and set up well for thefuture Avoided having to reinvent the wheelCopyright 2021, Vlamis Software Solutions, Inc.
Contact Information Darrell Sandfoss, darrell.sandfoss@ekpc.coop James Binkley, james.binkley@ekpc.coop Dan Vlamis, dvlamis@vlamis.com, @dvlamis www.ekpc.coop www.vlamis.comCopyright 2021, Vlamis Software Solutions, Inc.
Capitalize on Investment in DW, OBIEECopyright 2021, Vlamis Software Solutions, Inc.
OBIA 11.1.1.10.1 OBIEE 11g ODI 11g Oracle DB 12.2 Out of Place Migration In Place Upgrade Out of Place Migration WebLogic 11g OAS 5.5 OBIA 11.1.1.10.2 OBIEE 11g ODI 11g DW WebLogic 11g OBIA
Server OBIEE Administration tool and OBIEE software certified with the release Client Workstations Internet Explorer 6.0, Win2K/Windows XP 1.3 Deployment in OBIEE 10g There are two major steps in deploying an OBIEE Dashboard, first we need to create the data object metadata (.rpd file) in the OBIEE Administration tool.
OBIEE 12c, Oracle has given the capability of mashing OBIEE data with Excel data where a user can upload a spreadsheet to the server and mash it up with OBIEE data. However, there are few drawbacks to OBIEE 12c mashup: a) First, you need to upgrade to
OBIEE Data Security/Access Currently, Oracle BI Application does the authentication via Oracle EBS, object level security via OBIEE groups and data level security via OBIEE group (Ledger only). Users who login into OBIEE through EBS are able to see all the assigned ledger data irrespective of
1.3 Deployment in OBIEE 10g There are two major steps in deploying an OBIEE Dashboard, first we need to create the data object metadata (.rpd file) in the OBIEE Administration tool. Then, using the OBIEE Web, we create the Answers based on the .rpd file and assemble them in a Dashboard.
currently uses Oracle Business Intelligence Enterprise Edition (OBIEE) version 11g software. This three-part training course will deal with using OBIEE, including how to write your own queries and create your own dashboard reports. Specifically, the sessions will cover: 1. Creating Analyses in OBIEE 2. Viewing Analysis Results in OBIEE 3.
currently uses Oracle Business Intelligence Enterprise Edition (OBIEE) version 11g software. This three-part training course will deal with using OBIEE, including how to write your own queries and create your own dashboard reports. Specifically, the sessions will cover: 1. Creating Analyses in OBIEE 2. Viewing Analysis Results in OBIEE 3.
object metadata (.rpd file) in the OBIEE Administration tool. Then, using the OBIEE Web, we create the Answers based on the .rpd file and assemble them in a Dashboard. If the OBIEE server is present in Linux machine then merging of module specific repositories should be done using OBIEE Administration Tool installed on Windows machine and the .
Refer to API RP 500 and NFPA 70 for guidance. When loading liquids that can accumulate static charges, refer to the precautions described in the International Safety Guide for Oil Tankers and Terminals, Safety of Life at Sea, API MPMS Ch. 3, and API RP 2003. Care must be taken with all liquid-in-glass thermometers to prevent breakage, which will result in a safety hazard. If the liquid in the .
