New Features inOracle Analytics Cloud 105.2.0
Dan Vlamis, Vlamis Software Solutions
@vlamissoftware, 816-781-2880
www.vlamis.com
[email protected], @dvlamis
Copyright © 2019, Vlamis Software Solutions, Inc.
Vlamis Software Solutions
▪ Vlamis Software founded in 1992 in Kansas City, Missouri
▪ Developed 200+ Oracle BI and analytics systems
▪ Specializes in Oracle-based:▪ Enterprise Business Intelligence & Analytics▪ Analytic Warehousing▪ Data Mining and Predictive Analytics▪ Data Visualization
▪ Multiple Oracle ACEs, consultants average 15+ years
▪ www.vlamis.com (blog, papers, newsletters, services)
▪ Co-authors of book “Data Visualization for OBI 11g”
▪ Co-author of book “Oracle Essbase & Oracle OLAP”
▪ Creators of the Force Directed Graph Plugin on the Oracle Analytics Library
▪ Oracle University Partner
▪ Oracle Gold Partner
Copyright © 2019, Vlamis Software Solutions, Inc.
OBIEE, BICS, DVD, OAC New Features Webcasts
▪ 11.1.1.3 (August 2010)
▪ Huge release with major new functionality
▪ 11.1.1.5 (May 2011)
▪ BIWA TechCast May 25: Oracle BI 11.1.1.5 - New Features
▪ 11.1.1.6 (February 2012)
▪ BIWA TechCast Feb 29: Oracle BI 11.1.1.6 New Features
▪ New features mostly for Exalytics
▪ 11.1.1.6.2 and 11.1.1.6.2 BP1 (May 2012 and June 2012)
▪ BIWA TechCast Aug 1: Oracle BI 11.1.1.6.2 BP1 New Features
▪ Trellis Views
▪ 11.1.1.7 (April 2013)
▪ BIWA TechCast Apr 5 Oracle BI 11.1.1.7 New Features
▪ Freeze headers/scroll bars for tables and pivot tables
▪ View
▪ content in SmartView in Excel and enhanced export
▪ New Oracle R Enterprise (ORE) integration and capabilities
▪ 11.1.1.9 (May 2015)
▪ BIWA TechCast Jun 4, 2015 Oracle BI 11.1.1.9 New Features
▪ Search in Subject Areas pane
▪ Global variables and Save Column As choice in Criteria tab
▪ 12.2.1 (October 2015)
▪ BIWA TechCast Nov 19, 2015 Oracle BI 12.2.1 New Features
▪ BICS March 2016 (March 2016)
▪ Webcast Apr 5, 2016 BICS BICS March 2016 New Features
▪ 12.2.1.1 (June 2016)
▪ BIWA TechCast Jul 19, 2016 Oracle BI 12.2.1.1 New Features
▪ 12.2.1.2 and DVD 2.0 (October 2016)
▪ Webcast Nov 22, 2016 DVD 12.2.2 and OBIEE 12.2.1.2. New Features
▪ DVD 3.0 (June 2017)
▪ Webcast Aug 29, 2017 DVD 3.0 New Features
▪ DVD 4 (October 2017)
▪ Webcast Nov 9, 2017 DVD 4 New Features
▪ OAC 4 (December 2017)
▪ Webcast Dec 19, 2017 OAC 4 New Features
▪ Webcast Apr 4, 2018 Migration from OBIEE to OAC Webinar
▪ 12.2.1.4 (June 2018)
▪ Webcast Jun 19, 2018 Oracle BI 12.2.1.4 New Features
▪ OAC 18.3.3 (September 2018)
▪ Webcast Sep 27, 2018 OAC 18.3.3 New Features
▪ OAC 19.1.1 (January 2019)
▪ Webcast Feb 27, 2019 OAC 19.1.1 New Features
▪ Webcast Mar 6, 2019 Intro to OAC Running on ADW
All listed on website at http://www.vlamis.com/obiwebinars/
OAC 105.2.0 New FeaturesWebcast April 23, 2019
Copyright © 2019, Vlamis Software Solutions, Inc.
Use Questions or Chat or Questions to communicate
OAC 105.2.0 Selected New Features Overview
A. Close OCI Admin Gaps1. Start/Stop, Scale-up
2. Additional Configure System Settings
3. Increased System Limits
4. Usage Tracking
5. Java-script enablement
6. Light Write back (Answers)
B. Enhance Viz Experience7. General UI Enhancements
8. Improved Auto-Chart & Chart Selector
9. Enhanced Chart-Vizs Properties
10.Pivot Table Interactive Formatting
11.Pivot Table Asymmetric selections
12.Viz data-copy enhancements
13.Relative Time filtering
14.OSM Map Background
15.Points cluster layer
16.Size-by on line layers
17.Shapes edge & Map Dist. Selection
C. Collaborative & Actionable18.Data point linked-annotations
19.Project Read only Mode
20.Sharing improvements
21.Custom Actions plugins for DV
22.BIP sourcing from Data Flows
D.Deeper Data Flows23.Undo/redo, zoom, show labels
24.New Branch Aggregate/Transform steps
25.Single click rename/delete
26.Customize Essbase cube outline
27.DF Inspect details, Hourly Schedules
28.Enhanced Job monitoring
E. Enterprise Data Sources29.Snowflake Connector
30.RDC Installer, Direct XSA Connector
31.RDC New Datasources
32.Data Prep Experience Enhancements
33.SSO pass-on for OTBI Datasources
To be demoed live in OAC 105.2.0 webinar
1. OAC Start/Stop & Scale-up Oracle-Managed instances
Start/Stop InstanceScale Up/Down OCPUs
2. Configure System Settings
Administrators can set value for numerous system configuration parameters from ‘Configure System Settings’ web UI
See https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/configure-advanced-options.html for valid values
3. Increased System Size Limits
Item 105.2.0 Limit Value
File size limit when creating datasets 250 MB
Columns limit when creating datasets All file based sources 250 Columns
Amount of Data retrieved by Presentation Layer from DB
2 OCPU - 12 OCPU 1.1 M. Rows
> 12 OCPU 2.2 M. Rows
Amount of Rows Exported (unformatted file export only, csv)
2 OCPU - 12 OCPU 1.1 M. Rows
> 12 OCPU 2.2 M. Rows
4. OAC Usage Tracking
Create DB Connection Details in RPD (Using any DB)
Populate information in Configure System Settings
Execution DetailsROW_COUNTCUM_NUM_DB_ROWTOTAL_TEMP_KBNUM_DB_QUERYCUM_DB_TIME_SECCUM_NUM_DB_ROW
CacheCACHE_IND_FLGNUM_CACHE_INSERTNUM_CACHE_HITS
User, Session &… USER_NAMESESSION_IDPRESENTATION_NAMETENANT_IDSERVICE_NAME…
Query OriginQUERY_SRC_CDSAW_SRC_PATHSAW_DASHBOARDSAW_DASHBOARD_PG
Execution TimingSTART_TSSTART_DTSTART_HOUR_MINEND_TSEND_DTEND_HOUR_MINRESP_TIME_SECTOTAL_TIME_SECCOMPILE_TIME_SEC
Query DetailsQUERY_TEXTQUERY_BLOBQUERY_KEYSUCCESS_FLGERROR_TEXTREPOSITORY_NAMESUBJECT_AREA_NAME
Physical QueryQUERY_TEXTQUERY_BLOBTIME_SECROW_COUNTSTART_TSSTART_DTSTART_HOUR_MINEND_TSEND_DTEND_HOUR_MIN…
4. OAC Usage Tracking Details
5. Custom Javascript Enablement
User-Defined java-scripts
Set file URL in Admin settings and add it to safe domains
Invoke JS functions in Actions or custom report columns
6. Light Writeback
Set RPD column as Writeable
Grant write back privileges
Enter Writeback XML in System Settings
Run Writeback from Answers Reports
7. General UI enhancements
New Graphics
Enhanced Right Click Menu
Shape-Assignments
8. Improved Auto Charting & Chart Selector
Intuitive Chart Selector Menu
Auto Chart Viz Type
Before
(19.1.1)
Now
(105.2.0)
Double-Click Adaptive Auto-Charting:
- double click an object and best chart type will be created.
- double click another object, chart automatically will adapt
Improved Auto-Charting logics
+
Toggle Gridlines off
9. Enhanced Chart Properties : Data Values & Gridlines
Data Values enabled by Data Series (show data values only for a series)
Data values position
10. Enhanced Pivot Table : Toggling Headers, Interactive Table re-shaping
Toggle Rows and Columns headers visibility on or off
Before
(19.1.1)
Drag and drop data objects directly from data-source on the Pivot table, Reposition objects on existing pivot tables
Now
(105.2.0)
Custom Ctrl-select series or specific data-points at once on the pivot table…
11. Pivot Table : Asymmetric Selections
… & use asymmetric selection to keep, remove, brush or auto filter any other charts on the page
Before
(19.1.1)
12. Viz Data Copy enhancements : Tabular Data Extract
Now
(105.2.0)
12. Pivot Table Data Copy : Pivoted & Selected Data Extract
Copy All DataKeep pivotal format
Copy Selected DataOnly keep selection
13. Relative Time Filters
Create dynamic relative filtering filters (rolling, to date) leveraging date objects
14. New OSM Map Background
Bright
New Map Back-ground for OpenStreetMap
with Map-Type options
Positron
Dark
15. Points Cluster Map Layer
Individuals dynamically clustered within based on view zoom level
Cluster with just one point
16. Size-by Enabled for Line Maps Layers
Size Edge for Line Map Layers
17. Map Distance SelectionMaps Shape Edge
Radial Selection to select geometries within a particular radius
Custom Shapes assigned to data series or data points
18. Data Point Linked Annotations
Create visual connectors to reference data points with annotations
19. Project Read-Only Mode
Share = Consumption Options
Access = File Access Permissions
Read Only Read Write
ViewNo Save,No Save As
No Save,No Save As
EditNo SaveSave As Enabled
Save EnabledSave As Enabled
20. Sharing Improvements
Social Sharing on LinkedIn
21. Data-driven Custom Actionsin DV
Create JS based custom Action Plugins that can be invoked from DV Data Actions, passing DV context
22. BIP – Use DV Data Flow as a Source
Use Results of Data Flow as Source like any other BIP Datasource
BIP connecting to both DV Data Sets and DV Data Flows
23. Dataflow – Show Labels, Undo/Redo, Zoom
Zoom In/Out on Data Flow
Show Labels off to fit large dataflows into overview
Undo/Redo last steps
24. Dataflow - Branch/Aggregate Step Enhancements
Add Data, Join, Merge Rows available after Branch nodes
Multiple aggregations on single column
Add more group by columns
25. Dataflow - Single click rename/delete
Single click selection / rename
Single click delete
Datatypes displayed in preview
25. Dataflow – New Transform step
26. Dataflow-Customize Essbase Cube Outline
Configure option to customize cube outline
OrganizeHierarchy Outline
Source/Targets details in Data Flow Inspect
27. Dataflow Inspect : Source/Target, History, Hourly grain schedules
Hourly Grain Scheduling
Scheduling History & Logs
New Jobs & Schedules monitoring Screen. Full details about completed and Scheduled jobs
28. Dataflow Enhanced Job Monitoring
29. Datasources - Snowflake Connection
Snowflake DatatypeConnector
30. Datasources - RDC enhancements
RDC independent Installer (no WLS required)
Enable RDC for DV Connections
RDC Enabled for specific connections
+ New Datasources supported : MySQL, Spark, Hive, Impala
31. Datasources - RDC New Datasources
Supported Data-sources via RPD layer
• Oracle DB, • Essbase, • Teradata, • DB2, • SQL Server, • MySQL (incl Com-
munity Edition), • Spark, • Hive, • Impala.
Supported direct connection types in DSS (DV direct)
• Oracle DB, • Essbase, • DB2, • SQL Server
32. Data Prep Metadata View Enhancements
Single click metadata edit & rename
33. SSO pass on for OTBI Datasources
In Fusion Applications, grant BIImpersonator role to DVadmin user
In DV, create connection with Dvadmin user, select authentication mode
Grant read access on this connection to DV users. SSO-like behavior occurs when accessing datasets using this connection
Copyright © 2019, Vlamis Software Solutions, Inc.
Demo OAC BI Features
Copyright © 2019, Vlamis Software Solutions, Inc.
Oracle Analytics Library
http://www.oracle.com/goto/OAStore
Copyright © 2019, Vlamis Software Solutions, Inc.
Resources and Questions?
Vlamis Home www.vlamis.com Blog www.vlamis.com/blog Prior OBIEE releases www.vlamis.com/obiwebinars
OAC What’s New Documentation https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/index.html#ACSWN-GUID-CFF90F44-BCEB-49EE-
B40B-8D040F02D476
Oracle Analytics Library with plugins and demos https://www.oracle.com/solutions/business-analytics/data-visualization/library.html
YouTube channel Oracle Analytics from SampleApp Team https://www.youtube.com/user/EvolvingBI/videos
YouTube video playlist on OAC 105.2.0 new features https://www.youtube.com/playlist?list=PL6gBNP-Fr8KW3yf9sG90lpJvOd_HLil9a
Course on Oracle Analytics www.udemy.com/augmented-analytics
Gartner BI Bakeoff 2019 Demo Materials – Oracle blog article, https://www.youtube.com/playlist?list=PL6gBNP-Fr8KW581Zqli0F6-QwOywPmsSQ
Dan VlamisEmail: [email protected]: @dvlamis
Phone (816) 781-2880
Vlamis Software SolutionsTwitter: @vlamissoftwareLet us know if you want to know about future webinars!