Oracle Analytics Cloud Essbase Overview Features Copyright 2017

Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 3

Oracle Analytics Cloud - Essbase Flexible platform for the creation of departmental or enterprise-wide custom analytic applications and management reporting Software as a Service Platform as a Service Infrastructure as a Service Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal 4

Who Will Use Analytics Cloud - Essbase? • Essbase users looking for a Cloud solution – Reduce costs and simplify maintenance – Hybrid Deployments between on-prem applications and cloud cubes – Faster access to latest Essbase innovation • Integration with other cloud services – Essbase as a data source for BICS and DVCS – Consolidated data from multiple EPM cloud and onprem instances – Analyze data from other Saa. S applications • Analytics platform for every Excel user – Analytics happens everywhere – Most still use Excel, using data downloaded from other applications – Essbase empowers Excel by adding unified analysis model, interactivity and collaboration Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 5

Oracle Analytics Cloud – New: March 2017 Standard Edition Data Visualization Self-service data prep Spreadsheet collaboration Essbase standard Enterprise Edition Standard plus: Data modeling Essbase Enterprise Reporting Large scale & HA Day by Day Mobile CPU Purchases, “OCPU”, Includes Mobile, Client tools, & Desktop Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 6

Essbase Cloud Service - Architecture • Choose your shape – 1, 2, 4, 8, 16 OCPUs – 7. 5 GB to 15 GB of memory per OCPU • What is an OCPU? – Equivalent to one physical core • Metered and Non-Metered • Semi-managed Service – SSH Access – Administration Dashboard HTTP/SHTTP and TCP Ports Cloud Tools and Scripts Essbase J 2 EE Cloud Platform Essbase JAgent Command Line Tools Cube Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal cube

Proven Value, Redesigned for the Cloud • Re-architecture of Essbase for the Cloud – Designed to support higher concurrency and faster recoverability – Eliminated security bottlenecks – Memory utilization – Dynamic Scalability • Unified middleware layer for all services • Based on industry standards for ease of integration APS Scenario Management DBX CDS Thin Client Editor Data Source Dynamic Filters Grid UI Essbase Server Java Agent Catalog Drill Through Scripting: R, Groovy, JACL Java API, REST and Web Services Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal

OAC - Essbase Features • Access to Essbase capabilities – BSO/ASO/Hybrid databases – Flexible dimensionality – Dynamic formulas – Calc scripts – Data uploads • Smartview connectivity • Browser based UI • Integration with BICS • Cloud Only features – Sandboxing – Scenario management – Design by Example templates – Excel Import/Export • Administration – Database statistics – Manage connections – Locks – Security Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 9

Cloud Based UI for Design and Management • New database management and outline editor tools • Execute Jobs – Dim builds, Data Load, Calc Scripts • Define Scripts • Administration capabilities • Manage Files • Define Substitution Variables • Manage application/Database settings Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal

Utilities & Templates New Cloud Utilities and Rapid Business Modeling • Utilities • LCM – End to End Management • CLI – Leverage the New REST API’s • Smartview – Excel Reporting • Templates • Build a corporate inventory of Templates for reuse across different departments • Reuse templates with customization Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 11

Simplified Security Server Roles Administrator Full access to administer users, applications and databases. Power User Ability to create and delete applications and databases User Ability to access any application or database that has a minimum access permission Application Privileges Application Manager Ability to create, delete, and modify databases and application settings; assign users Database Manager Ability to manage the databases, database artifacts, locks, and sessions Database Update Ability to read and update data values; using any assigned calculations and filters; Create and delete scenarios Database Access Ability to access scenarios; read data values in all cells; and access specific data and metadata Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 12

From Excel to Essbase in Less than a Minute Auto Analyze Data and Create Cubes • Tool-less approach for faster deployments AMOUNT PROD. FAMILY PROD. TYPE ITEM Excel to Cloud in seconds Uploading a spreadsheet creates a business model DATE – – CITY • Automatic schema inference on load COUNTRY One click provisioning and deployment STATE – Sales Data • Zero learning curve, no Essbase skills needed – Modify the cube design can also be done from Excel Powerful yet Flexible • Forced Column designations One Step – Provide Generation relationships. Eg. product. category, category. sub_category… – Provide hints. Eg. Product. color[attr], revenue[measure] • Intrinsic Hints Automatic Schema Inference COUNTRY HIERARCHY PRODUCT HIERARCHY TIME HIERARCHY CUBE CREATION – Header presentation in Table. Column form • Statistical Analysis – Used when the report headers are in no special format. – No knowledge or changes are needed. – No hints are given from the user Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 13

Scenario Management • Sandboxing and Scenario Management What-if Reject – Create private copy data for what-if and sensitivity analysis – Refresh from the base data or merge the Sandbox into it – Apply lightweight workflow to scenarios and submit approvals – Assign Approver and Viewer type roles Create Submit Approve Apply Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 14

Cloud Integration and Data Movement Multiple Options for Data Loads • Uploaded flat files • Database as a Service • On-prem sources (will require VPN) Multiple Reporting Options • Smart View (no, no Excel Add In) • BICS integration is similar to OBI integration with Essbase • DVD integration is already available as beta and evolving • Management Reporting (Web. FR) with EPRCS Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 15

DV and Essbase - Complete Offering • Essbase • DV – Allow users to interact with the data using Excel – Ingests and harmonizes spreadsheets, collates and manage disparate inputs – Provide coherence, consistency and sharing – Enables and manages the iterative information cycle Excel, BI, Source Systems Essbase – Data Interaction and Collaboration • • Data from any source Exports from other systems Hand crafted spreadsheets • – Visually research and discover – Review and visualize personal data – Review and visualize group data and in the context of wider corporate data – Provides insights at key stages of the iterative information cycle – Automatically creates an Essbase cube when needed Interact with the data and mode using Excel with a strong server side data consolidation and integrity (multi-user read/write access) Add model validation and shared KPIs for user scenarios and data gathering DV – Visualize and Discover • • Visual discovery Share analysis and results Track and monitor progress Create an Essbase model for multi-user write collaboration, scenario management and What-If analysis Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal 16

DV Integration • Connect to Essbase Cube on the Cloud – Select Data Source – Choose Essbase – Provide Connection Details – Select Application & Cube Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 17

Creating Visualizations • Query Essbase • Build visuals to analyze data in Essbase Cubes

Compare Scenarios side-by-side and Merge with Base Copyright © 2017, Oracle and/or its affiliates.

Cube Designer – Excel Modeling and Gallery Templates • Smart View Add-in – Create Essbase Applications – Build and Manage essbase applications and properties – Set Member formula – Run Calc Scripts – Manage Design Templates – Run Calc Scripts – View/Manage Dimension Hierarchies Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 20

Cube Designer - Overview • The Cube Designer – uses the Smart View extension framework for Excel integration and server communications – uses the REST APIs of the Essbase cloud to perform all Essbase operations Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 21

Connections • Derives the connection information to the Essbase cloud via the Smart View private connections • Provide the URL to the Essbase cloud in the private connections panel of Smart View Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 22

Gallery & Private Workbooks • The Cube Designer provides a set of application workbook examples which demonstrate the various capabilities of the Essbase cloud • They can be used to house standard org-wide templates for Essbase Applications • Private - Allow the user to maintain their own private collection of workbooks Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 23

Cube Designer Wizard • The application workbooks have a strictly defined structure which the Essbase cloud understands and can consume in order to generate an Essbase cube. • To facilitate the creation of this defined workbook structure, the Cube Designer Wizard can be used to quickly generate a valid application workbook. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 24

Formula Editor • A basic formula editor is included in the Cube Designer to aid the user in creating valid member formulas • there are lists of valid operators and Essbase functions which can be used within the member formula. • the user can copy and paste members from the workbook into the editor, if you click on a cell in a worksheet and then right click within the editor, the text from that cell is copied into the editor wrapped in double quotese workbook into the editor Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 25

Hierarchy Viewer • The Cube Designer provides a hierarchy viewer to aid in the development of the parent/child relationships • the alias, storage and consolidation properties are shown and can be hidden • there is a Find capability within the tree view Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 26

Build Cube • Building the cube is the first of the four steps to designing a cube • A cube can be created or an existing cube can be updated • the data contained with the data worksheets can be loaded into the cube • the calculation worksheets can be executed in the order they appear in the application workbook Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 27

Load Data • The Load Data operation is provided for the purposes of iterative cube development • It is a common practice that once a cube is built, a process of loading, calculating and querying is performed to validate the accuracy and performance of the cube. • The Load Data operation will run as an asynchronous job in the Essbase cloud Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 28

Calculate and Analyze • Calculate – Run Calc Scripts • Analyze – Create Smart View Ad Hoc – Connect Query Sheet - the user can include worksheets beginning with the name “Query”, this will take them to the first occurrence, connect to Smart View and perform a query refresh Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 29

View Jobs • The Cube Designer maintains a client-side log of the jobs executed

Transform Data • the Essbase cloud allows for a freeform table of data to be used as the basis for a cube design • an algorithm in the Essbase cloud will determine the shape of the cube based upon the header information as well as the data relationships • a set of “forced designations” can be used to augment the header information Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 31

Admin Tasks • In order to allow the user to maintain a clean server environment, the Cube Designer allows for the deletion of entire applications or just a single cube. – option to delete an Essbase application – option to delete an Essbase cube Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 32

New Command Line Tool - Ess. CLI • Execute jobs such as calcs, clears, data load and dim builds • Upload files to the cloud service • Check job statuses • LCM Import Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | Confidential – Oracle Internal

Moving Your Cubes to the Cloud • Use LCM export to move cube artifacts from on-premise to cloud – Cross cube references such as XREF and Partitions are not included and need to be recreated manually – Use LCM export from 11. 1. 2. 3 and 11. 1. 2. 4 deployments – Cloud cubes are all Unicode and Encrypted (encryption at rest) – Start with a default CFG, change if needed Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 34

Pre-requisites • JDK 8 or higher • Unicode Mode – Convert all application and associated artifacts to Unicode mode before export • Substitution Variables – Server-level SVs must be converted to Application-level SVs – Server-level SVs are no longer supported. • Hybrid Aggregation Mode – Default Calc and query processor on the cloud is hybrid mode. • Implied Sharing not supported on the cloud Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 35

Configuration Settings • Default settings are different on the cloud – IGNORECONSTANTS is TRUE by default – INDEXCACHESIZE and DATACACHESIZE settings now control cache sizes for all cubes – GRIDSUPPRESSINVALID is now TRUE by default – QRYGOVEXECTIME is now set by default to 300 seconds • Oracle strongly recommends managing all configuration settings at the application level. • Application-level configuration is preserved during the LCM utility export and import processes. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 36

Other considerations • You must convert all application-level files and artifacts into database-level files and artifacts before you export them from on-premises Essbase instance – In the cloud service, artifacts are supported at the database level only. – This includes calculation scripts, rule files, and text files • Partitions – Only transparent partitions are supported by the LCM utility. – Replicated and linked partitions are not supported. – Always import the source applications before the target applications. • After you migrate an Oracle Essbase on-premises application with a unique member outline to a cloud service instance, you cannot change the outline to allow duplicate members. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 37

Lift… Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 38

Lift… PS C: Usersxxxxxxx> java -version java version "1. 8. 0_121" Java(TM) SE Runtime Environment (build 1. 8. 0_121 b 13) Java Hot. Spot(TM) 64 -Bit Server VM (build 25. 121 b 13, mixed mode) PS D: appesscsv 702Essbase. LCMUtility>. /Essbase. LCM. bat export -server xxxx. us. oracle. com: 1423 -user admin -password -application liftshift -zipfile D: appesscsv 702dataliftshift. zip Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 39

… and Shift PS D: appesscsv 702cli>. /esscs. bat login -user cloud. user -password Admin 123 -url http: //unitxxxxx. oracleads. com: 9000/essbase Details: user "cloud. user" logged in PS D: appesscsv 702cli>. esscs. bat lcmimport zip. File. Name D: appesscsv 702dataliftshift. zip overwrite true File "D: appesscsv 702dataliftshift. zip" Uploaded. . Status: 200 Details: Completed Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 40

… and Shift Copyright © 2017, Oracle and/or its affiliates. All rights reserved. |

New Command Line Tool - Ess. CLI • Execute jobs such as calcs, clears, data load and dim builds • Upload files to the cloud service • Check job statuses • LCM Import Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 42

Cloud Migrations • Essbase CLI • Export Utility – Export an essbase cube in MS Excel template format – Works for both on-prem and cloud • LCM Utility – migrate Essbase on-premises applications, folders and elements via a. zip file • Cube Designer – Export Cube to Application Workbook and then Build Cube to import • Excel Template – Export the Cube Metadata into Excel Template Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 43

Load Rules Editor • New JSON format • Support for both Studio and BPM Rule files • Capability to create/edit new Rule file from UI Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 44

Financial Reports • MR (AKA Web FR, vi EPRCS) support close to v 1 release • FR to MR report conversion tool planned for later this year Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 45

Resources • Documentation – http: //docs. oracle. com/cloud/latest/analytics-cloud-docs. html • Working with Essbase – http: //docs. oracle. com/cloud/latest/analytics-cloud/essbase-cloud-interface. html • Youtube – https: //www. youtube. com/user/Evolving. BI Copyright © 2017, Oracle and/or its affiliates. All rights reserved. | 46