Tuesday Oct 27, 2015

New Data Visualization Cloud Service

Powerful, Easy-to-Use Visual Analytics Now Accessible to Every Business User

Oracle Data Visualization is now available to your clients in three forms:

  1. As an integrated add-on module to OBI 12c on-premise (OBI 12c Major Release is Available)
  2. Within BICS (BI Cloud Service)
  3. And now in DVCS (Oracle Data Visualization Cloud Service)

This makes rich, powerful visual analytics accessible to every business user. People at all levels of an organization can blend and analyze enterprise, personal or big data in just a few clicks, effectively sifting through data clutter to quickly uncover and share hidden patterns and actionable insights. All of this can be done without the need for expert IT resources, resulting in faster time to value and significant increases in ROI.

“Adoption and usage patterns at our 400+ Business Intelligence Cloud Service customers confirm that fast, easy-to-use data visualization is critical to their businesses,” said Hari Sankar, group vice president, Business Analytics, Oracle. “Oracle Data Visualization Cloud Service makes data visualization 100 percent self-service, empowering business users to go from raw data to actionable business insights in just a few minutes. This new service delivers rich visual analysis, rapid discovery of insights and secure collaboration, enabling fact-based decisions at every level of the organization.”

Oracle Data Visualization Cloud Service eliminates the complexity typically associated with blending and correlating data sets. Easy, automatic data blending allows users to combine data from a variety of sources—Oracle and other SaaS applications, on-premises systems, external sources and personal files—and immediately gain new insights using visual analysis. They can enrich the analysis with narratives to create stories that can be shared across the organization in a scalable, secure fashion. The creation and sharing of analytic insights is supported on mobile, tablet and desktop devices, enabling complete flexibility and unlimited access.

“Skanska implemented Oracle as a common BI solution for all users around the globe, for easy mobile access, self-service tools, and improved decision-making—and it reduced costs,” said Peter Bjork, vice president of information systems strategies, Skanska AB. Conny Bjorling, the senior business analyst driving the BI project on Bjork’s team, added, “Now with Data Visualization, we have something that is as visually compelling as it is easy to use. The storytelling functionality is a pivot point in terms of being able to explain your insights effectively.”

For more information see:

Monday Oct 26, 2015

OBI 12c Major Release is Available

BI 12c is the strategic foundation of Oracle’s analytics platform, delivering significant new value and lower total cost of ownership to the many existing Oracle BI customers, as well as being a compelling analytics platform for new customers.  BI 12c is critical to Oracle’s hybrid strategy, complementing BI Cloud capabilities by making fast, friendly data visualization and managed, scalable enterprise-class analytics available on-premises.

The new Data Visualization offering appeals to a large set of existing Oracle BI users, as well as opening up expansion opportunities with new users.

What’s New

BI 12c delivers a major update to the Oracle BI platform, with enhancements across the entire platform, as well as new Data Visualization capabilities.  Highlights and benefits include:

Easy to upgrade:  BI 12c offers a radically simple and robust upgrade from 11g, saving customers time and effort in moving to the new version.  BI 12c includes a free utility to automate regression testing, the Baseline Validation Tool, which verifies data, visuals, catalog object metadata, and system-generated SQL across 11g and 12c releases.

More Visual:  A consistent set of Data Visualization capabilities are now available across Oracle BI Cloud Service and Oracle BI 12c, as well as the upcoming Oracle Data Visualization Cloud Service, offering customers a continuity of visual experience unmatched by our competitors.  Business users can point and click to upload personal data and blend it with IT-managed data in BI 12c, which automatically infers connections between data sets.  Visualizing data is as easy as dragging attributes onto the screen, with optimal visualizations automatically displayed – no modeling or upfront configuration required.  Related data is automatically connected, so highlighting data in one visual, highlights correlated data in every other visual, immediately showing patterns and revealing new insights.  These insights, along with narrative comments, can be shared as interactive visual stories, enabling seamless collaboration that drives fact-based decisions.

More Advanced Analytics:  Predictive analysis is more tightly integrated, enabling customers to more easily forecast future conditions based on existing data points, group elements that are statistically similar, and expose outliers.  BI 12c includes the ability to run the free Oracle R distribution on BI Server, and extend existing analytics with custom R scripts, which can point to any engine (R, Oracle Database, Spark, etc.) without needing to change the BI RPD to deliver results.

More Mobile:  Keyword search (“BI Ask”) empowers users to literally talk to their data, asking questions and having visualizations automatically created as responses, opening up an easy entry point for authoring.  Additionally, the interface for iOS has been completely redesigned; and Mobile BI for Android offers sharing and following for nearby devices, as well as the ability to project any dashboard or story to GoogleCast-enabled devices.

Faster:  Sophisticated in-memory processing includes BI Server optimizations and support for multiple in-memory data stores, while in-memory Essbase on Exalytics offers enhanced concurrency and scalability, as well as significant performance gains.

Friendlier:  Usability updates throughout BI 12c demonstrate Oracle’s continued commitment to making analytics as fast, flexible, and friendly as they are powerful and robust.  A new user interface simplifies the layout for the homepage, Answers, and Dashboards, making it easier for users to quickly see what’s important; HTML-5 graphics improve view rendering; and it’s easier for users to create new groups, calculations, and measures, for simpler, more direct interaction with results.

Bigger Data:  BI 12c enables customers to use new data, from local, Oracle, and Big Data sources, including personal files uploaded by users; direct access to data in Hyperion Financial Management and Hyperion Planning applications; and ODBC access to Cloudera Impala.

Higher ROI, Lower TCO:  Streamlined administration and life cycle management reduce the time and resources required to manage BI 12c, decreasing costs and increasing value for this and future releases.  Enhancements include separating metadata from configuration; simpler, more robust security; easier backup, restore, and disaster recovery; hot patching of metadata; and many more.

Oracle BI 12c is available for download from OTN


Tutorials -

Tuesday Oct 13, 2015

Oracle BI Applications Version is Available

Oracle Business Intelligence Applications (BI-Apps) is now available on the Oracle Software Delivery Cloud, and on the Oracle BI Applications OTN page.

What is New:

Oracle Cloud Application Sources for Hybrid Analytics

Oracle Business Intelligence Applications introduces the following cloud application sources:

· Service Analytics: Oracle Service Cloud (RightNow)

· HR Analytics: Oracle Talent Cloud (Taleo Recruit)

Content Enhancements for existing Oracle BI Applications

· Oracle Project Analytics delivers out of the box support for PeopleSoft Grants Management. The Grants Management Accounting module helps plan, manage, and track an institution’s grant activities, with support for Award Analysis and Award Funding subject areas.

· Oracle Student Information Analytics now provides class enrollment and term enrollment snapshots to fulfill internal and external reporting requirements.

· Integration with Oracle Data Relationship Management (DRM) enables the creation and management of custom hierarchies for the Business Unit dimension in Oracle E-Business Suite

Certifications and ETL Health Check improve productivity

· BI-Apps is Certified with the latest version of Oracle BI Foundation Refer to the new features and product documentation for more details on this release.

· BI-Apps is Certified with ODI (11gR1 PS7). Refer to these new features and product documentation for more details on this.

· A Diagnostic Health Check phase is now included as part of the BI Applications ETL. Any reported issues are collected in Configuration Manager along with suggested actions to help resolve the health check issues.

For more information:

Monday Sep 14, 2015

BICS 30-Day Trial now Available for Oracle BI Cloud Service

If you go to the BICS entry page @ Cloud.Oracle.com you will now find a “Try it >” button at the top.

So please let your clients know of this, and work with them on a planned 30-day trial evaluation process, within which you can help them prove the business value for them using BICS and Visual Analyser, and so convert the trial into a full project roll-out.

  • When you click the “Try it >” button you will see two next steps:
    1. Overview of Trial Setup Process – This provides an overview of the trial setup process, setting up users and administrators and configuring settings to optimize your experience.
    2. “Start Trial” button to actually fill in the information to get going with BICS.

Otherwise, if you need to catch up on BICS news, then replay this Partner Web-conference Update on What is New for BICS, and follow the provided links there, to more partner resources for demos and training.

Wednesday Aug 19, 2015

Oracle Big Data Discovery Version 1.1

Partners and customers can replay our webcast with Cloudera, Unlock Your Analytic Talent with the Visual Face of Hadoop (originally on August 29).

Oracle Big Data Discovery version 1.1 is now available. This release extends Oracle’s innovation in Big Data Analytics by bringing together the best open-source and Oracle technologies, enabling you to reach more of the market and address more of your clients’ analytics challenges.

  • Big Data Discovery now runs on Hortonworks HDP 2.2.4+, in addition to Cloudera CDH 5.3+.  That makes BDD the first Spark-based big data analytics product to run on the top two Hadoop distributions, significantly expanding your market opportunity.
  • Customers can now access enterprise data sources via JDBC, making it easy to mash up trusted corporate data with big data in Hadoop.  BDD 1.1 elegantly handles changes across all this data, enabling full refreshes, incremental updates, and easy sample expansions.  All data is live, which means changes are reflected automatically in visualizations, transformations, enrichments, and joins.
  • Dynamic visualizations fuel discovery – but no product can include every visualization out-of-the-box.  This release includes a custom visualization framework that allows customers and partners to create and publish any visual and have it behave like it is native to BDD.  Combined with new visualizations and simpler configuration, this streamlines the creation of discovery dashboards and rich, reusable discovery applications.
  • Big Data Discovery is unique in allowing partners and customers to find, explore, transform, and analyze big data all within a single product.  This release significantly extends BDD Transform, making it both easier and more powerful.  New UIs make it easy to derive structure from messy Hadoop sources, guiding users through common functions, like extracting entities and locations, without writing code.  Transformation scripts can be shared and published, driving collaboration, and scripts can be scheduled, automating enrichment.  Transform also includes a redesigned custom transformation experience and the ability to call external functions (such as R scripts), providing increased support for sophisticated users. 
  • BDD 1.1 supports Kerberos for authentication (both MIT and Microsoft versions); enabling authorization via Studio (including integration with LDAP) to support Single Sign-on (SSO); and providing security at both project and dataset levels.   These options allow customers to leverage their existing security and extend fine-grained control to big data analytics, ensuring people see exactly what they should.

Also see “Big Data Discovery” Hosted Demonstration Instances for Partners.

And if you wish to deep dive into Spark (although to use BDD, this is not needed), I suggest you check out the Cloudera Developer Training for Apache Spark.

Wednesday Jul 15, 2015

OBI11g Analyses Hadoop data directly (without ETL) using Oracle Big Data SQL

You may have noticed that OBI can now analyse Hadoop data directly (without ETL) using Oracle Big Data SQL for Data Access (or Cloudera’s Impala), and can easily join it with other OBI data sources onto one dashboard. To find out more you can review the Big Data documentation below, and try it for yourself by downloading the Demonstration VM for OBI 11g SampleApp v506 including Cloudera and Big Data SQL.

Oracle Big Data Appliance Software User's Guide

1 Introducing Oracle Big Data Appliance

2 Administering Oracle Big Data Appliance

3 Supporting User Access to Oracle Big Data Appliance

4 Configuring Oracle Exadata Database Machine for Use with Oracle Big Data Appliance

5 Optimizing MapReduce Jobs Using Perfect Balance

6 Using Oracle Big Data SQL for Data Access

7 Oracle Big Data SQL Reference

Essentially, Oracle Big Data SQL accesses Hadoop via external tables to:

  • ORACLE_HIVE: Enables you to create Oracle external tables over Apache Hive data sources. Use this access driver when you already have Hive tables defined for your HDFS data sources. ORACLE_HIVE can also access data stored in other locations, such as HBase, that have Hive tables defined for them. The DBMS_HADOOP PL/SQL package contains a function named CREATE_EXTDDL_FOR_HIVE. It returns the data dictionary language (DDL) to create an external table for accessing a Hive table.
  • ORACLE_HDFS: Enables you to create Oracle external tables directly over files stored in HDFS. This access driver uses Hive syntax to describe a data source, assigning default column names of COL_1, COL_2, and so forth. You do not need to create a Hive table manually as a separate step: you can just define the record format of text data, or you can specify a SerDe for a particular data format.

External tables do not have traditional indexes, so that queries against them typically require a full table scan. However, Oracle Big Data SQL extends SmartScan capabilities, such as filter-predicate offloads, to Oracle external tables with the installation of Exadata storage server software onto an Oracle Big Data Appliance. This technology enables the Oracle Big Data Appliance to discard a huge portion of irrelevant data—often up to 99 percent of the total—and return much smaller result sets to the Oracle Exadata Database Machine. Therefore, End users obtain the results of their queries significantly faster, as the direct result of a reduced load on Oracle Database and reduced traffic on the network.

Note that alternatively, and similarly, Oracle SQL Connector for HDFS provides access to Hadoop data for all Oracle Big Data Appliance racks, including those that are not connected to Oracle Exadata Database Machine. However, it does not offer the performance benefits of Oracle Big Data SQL: see Oracle Big Data Connectors User's Guide.

Tuesday Jun 16, 2015

Big Data Spatial and Graph Analytics for Hadoop

We have just added Oracle Big Data Spatial and Graph support for Hadoop and NoSQL database technologies.  For over a decade, Oracle has offered leading spatial and graph analytic technology for the Oracle Database: we have now applied this expertise to work with social network data and to exploit Big Data architectures.  

Oracle Big Data Spatial and Graph includes two main components:

  1. A distributed property graph database with 35 built-in graph analytics to discover graph patterns in big data, such as communities and influencers within a social graph
  2. A wide range of spatial analysis functions and services to evaluate data based on how near or far something is to one another, or whether something falls within a boundary or region

Property Graph Data Management and Analysis

Property graphs are commonly used to model and analyze relationships, such as communities, influencers and recommendations, and other patterns found in social networks, cyber security, utilities and telecommunications, life sciences and clinical data, and knowledge networks.  

Property graphs model the real-world as networks of linked data comprising vertices (entities), edges (relationships), and properties (attributes) for both. Property graphs are flexible and easy to evolve; metadata is stored as part of the graph and new relationships are added by simply adding an edge.

Oracle Big Data Graph provides an industry leading property graph capability on Apache HBase and Oracle NoSQL Database with a Groovy-based console; parallel bulk load from common graph file formats; text indexing and search; querying graphs in database and in memory; ease of development with open source Java APIs and popular scripting languages; and an in-memory, parallel, multi-user, graph analytics engine with 35 standard graph analytics.

Spatial Analysis and Services – Enrich and Categorize Your Big Data with Location

With the spatial capabilities, users can take data with any location information, enrich it, and use it to harmonize their data.  For example, Oracle Big Data Spatial can look at datasets like Twitter feeds that include a zip code or street address, and add or update city, state, and country information. These results can be visualized on a map with the included HTML5-based web mapping tool.  Location can be used as a universal key across disparate data commonly found in Hadoop-based analytic solutions. 

“Big Data systems are increasingly being used to process large volumes of data from a wide variety of sources. With the introduction of Oracle Big Data Spatial and Graph, Hadoop users will be able to enrich data based on location and use this to harmonize data for further correlation, categorization and analysis. For traditional geospatial workloads, it will provide value-added spatial processing and allow us to support customers with large vector and raster data sets on Hadoop systems.” - Steve Pierce, CEO, Think Huddle

Your Spatial & Graph specialist contact in EMEA is Hans Viehmann (hans.viehmann@oracle.com).

You can attend a live web-conference on Spatial & Graph on Tuesday, July 21st at 6:00 PM UK / 7:00 PM CET

Wednesday Jun 10, 2015

Partner Web-conference Update on What is New for BICS

You can REPLAY this Conference by clicking on Replay Webcast (originally on 22/June, audio will play over your computer speakers or headset, but you have to login to Oracle first).

This Partner Web-conference update was on what is new for BICS, where we showed some of the latest features such as Visual Analyzer and discussed some of the use-case study stories for the many customers who have already bought into the Oracle BI Cloud Service. We also confirm the partner resell and referral processes for you to earn your partner margin.

If you need to catch up on the past announcements, try the links below:

Tuesday May 19, 2015

OBI 11g Release Now Available

This new release of Oracle Business Intelligence v., includes a number of new features and a focus on overall quality improvement. Significant new features and enhancements include:

Expanded Data Source Support, including support for Cloudera Impala and Hive2.  Users can also access information directly from their Hyperion Planning applications to build and deliver analytical content with OBI. Integration with the Oracle 12c database has been enhanced with support for compression, Exadata Hybrid Columnar Compression (EHCC), and in-memory Oracle database features.

Improved User Experience, including a new Tree Map visualization. Subject area search makes it easier to locate elements to add to an analysis. Users can now save and re-use custom column definitions.  More options are available to users when exporting content.  Customers can now take advantage of HTML5 for rendering charts.

New Capabilities for Exalytics, including support for count distinct aggregations.  Aggregations for levels with non-unique level keys, ragged and skip level hierarchies, and time levels with no chronological keys are also supported.  A new Summary Advisor command line utility is available to assist with scripting maintenance tasks.

New Capabilities for Administration, including Mobile App Designer installed by default.  A database policy store is available for security administration.

BI Publisher Integration with WebCenter Content: This integration will enable customers to deliver BI Publisher output directly to WebCenter Content.

More information:

Friday May 08, 2015

New Oracle Enterprise Performance Reporting Cloud Service (EPRCS)

Introducing the new Oracle Hyperion EPM cloud approach for secure, collaborative, and process driven reporting. On the Oracle public cloud customers can now buy the new Enterprise Performance Reporting Cloud Service (EPRCS).

  • You can listen to an explanation of this new service on our live EPRCS Webcast on Thursday, May 21, 2015 6:00 pm UK / 7:00 pm CET.

Oracle Enterprise Performance Reporting Cloud is a purpose-built solution in the Cloud for management and narrative reporting. It provides a secure, collaborative, process-driven approach for defining, authoring, reviewing, and publishing financial and management report packages for internal and external stakeholders.

Corporate and management reporting is experiencing significant change in today’s digital age. As reported earnings become more volatile, corporate guidance—and the ability of management to clearly explain the quality and sustainability of corporate performance—is more important than ever.

The current integration of narrative into performance-reporting processes is often manual, ad hoc, and highly prone to error. New cloud-based solutions, such as Oracle Enterprise Performance Reporting Cloud, enable organizations to streamline internal and external reporting processes, combining data plus narrative in a single, secure, collaborative environment.

Read more @ the EPM blog on Enterprise Performance Clearly Explained With a Collaborative, Intuitive, Reporting Solution.



What is New in Oracle BI Cloud Service (BICS)

Anyone who subscribes to Oracle BI Cloud Service receives automatic upgrades as soon as new features become available. You don't need to request an upgrade or take any actions yourself. Go here to keep up to date with an overview of new features and enhancements added recently, for example in April 2015:

Explore data using Visual Analyzer

Visual Analyzer provides self-service analysis, seamlessly transitioning you between all phases of the analysis lifecycle: data staging, analysis, composition, and consumption. See Getting Started with Visual Analyzer, and Oracle Visual Analyzer is now Available with Demonstrations for Partners .

Manage access to Visual Analyzer through a new application role called BIDiscoveryContentAuthor. See Application Roles Predefined in Oracle BI Cloud Service.

Integrate with Oracle Database Cloud Service (Database as a Service)

Connect Oracle BI Cloud Service to any Oracle Database Cloud Service (Database as a Service) instance. See Changing the Database Connection.

Upload data models from a file

If you’ve modelled your data with Oracle Business Intelligence Enterprise Edition, then you don't need to start from scratch in Oracle BI Cloud Service. Simply upload your on-premises data model file (.rpd) to Oracle BI Cloud Service and start exploring your data through visualizations, reports, and dashboards. See Uploading Data Models from a File (.rpd).

Add your own data to analyses

You can add data from an external source to an analysis in Oracle BI Cloud Service. Adding your own data is sometimes referred to as “mash-up.” See Adding Data from External Sources to Analyses.

Oracle BICS Data Sync version 1

Oracle Business Intelligence Cloud Service Data Sync supports the load of on-premises data residing in one or more relational or comma-separated value file sources into the schema provisioned on Oracle Business Intelligence Cloud Service:

Thursday Apr 02, 2015

Cumulative Feature Tool for Oracle EPM Versions

Please try out this new web-based Cumulative Feature Overview Tool for Oracle EPM products. 

This web based Tool provides concise descriptions of new and enhanced features and functionality available between a user-selected starting and target releases.  You can also download the report output to various formats such as PDF and Excel, and it includes links to video feature overviews.  Feel free to pass this on to your customers.

Monday Mar 16, 2015

Oracle BI Applications with Cloud Application Sources for Hybrid Analytics

Oracle Business Intelligence (BI) Applications, for installation ‘on-premise’, is now available on the Oracle Software Delivery Cloud, and on the Oracle BI Applications OTN page. This release is certified with the latest version of Oracle BI Foundation

New Oracle Cloud Application Sources for Hybrid Analytics

  • With the continued move to the Cloud, Oracle BI Applications has introduced support for the following Oracle Application Cloud sources: Oracle Sales Cloud, Oracle HCM Cloud, Oracle Financial Cloud, Oracle Procurement Cloud, and Oracle Project Cloud, to download cloud data to BI-Applications ‘on-premise’.

New Content Enhancements: Additional content improves existing Oracle BI Applications including:

  • Oracle Financial Analytics provides a new Essbase GL Balances model for improved EBS Financial Service Generator (FSG) Reporting and Hierarchy navigation, including support of ragged hierarchies for GL segment dimensions.
  • Oracle Project Analytics expands project-based insight with new Construction in Process (CIP) support, providing visibility for Project Stakeholders into in-progress costs, expensed costs since project inception and across organizations.
  • Oracle Procurement and Spend Analytics delivers new capabilities for Fusion Procurement, including Supply Chain Financial orchestration, negotiation and award approvals, and Buyer assignment controls.
  • Oracle Supply Chain & Order Management Analytics introduces new Inventory module support for PeopleSoft, including visibility into inventory balances, aging, transactions and valuation.
  • Oracle Student Information Analytics provides new subject area coverage for Student Financials Billing Summary and Transactions, with visibility to billing and transaction information by student or external organization.
  • Oracle Human Resources Analytics expands analysis on HR programs and workforce performance for Fusion HCM with support of Talent Management Analysis.
  • Oracle Sales Analytics introduces new subject areas for Activity Analytics, with support for Activity contact, resource and sales subject areas from Fusion Sales.


Friday Feb 20, 2015

Oracle Big Data Discovery Now Available - The Visual Face of Hadoop

There has been a lot of excitement about Oracle Big Data Discovery, and it is now generally available to customers and partners and can be sold and installed now.

This is a stunningly visual, intuitive tool that enables you to leverage the power of Hadoop and turn raw data into business insight in minutes — without learning complex products or relying only on specialists.

From a partner perspective it is perfect for proof of concept work with your clients to reveal the value they can find in their large information reservoirs combining a variety of data and text sources; potentially leading to much more and deeper analysis as part of an overall big data information architecture.

To find out more see these videos:

Check out the Capabilities of Big Data Discovery to

  1. Easily find relevant data by browsing a rich, interactive catalog of all data in hadoop using familiar keyword search and guided navigation.
  2. Explore data to understand its’ potential by visualizing the shape and quality of unfamiliar data and combining attributes to uncover interesting relationships.
  3. Transform and enrich to make data better with intuitive, user-driven data wrangling.
  4. See rich, interactive visualizations that reveal new patterns by blending diverse data sets for deeper perspectives.

More Resources:

Thursday Feb 12, 2015

Hyperion Financial Management and Oracle EPM system New Version

A great service opportunity to partners offering upgrades and modernisation to their Hyperion clients, Oracle has just announced the new Oracle Enterprise Performance Management (EPM) System Release v This new release incorporates key updates to the entire portfolio of EPM applications that enable organizations to engineer predictable performance, connect the enterprise, and further improve decision-making. See the press release here.

Oracle EPM System Release includes a major update to Oracle Hyperion Financial Management (HFM) that delivers significant performance improvements as well as simplicity of administration with an all-unix-based deployment capability. HFM is now also available on Oracle Exalytics In-Memory Machine. With this addition, the entire Oracle Hyperion Financial Close Suite and Oracle Hyperion Planning is available on Oracle Exalytics (along with OBI Foundation, Endeca and In-Memory DB), offering simplified deployment, reduced total cost of ownership, and improved performance.

“With Oracle Hyperion Financial Management we saw dramatic improvements in financial consolidation times. Executing a consolidation on our main organizational structure went from three hours to 15 minutes,” said Diane Ferry, administrator at Emerson for Oracle Hyperion Financial Management. “As we have many alternate organizational structures, the savings in consolidation times will allow us to have the application ready for our users more quickly. It will also allow our users to more quickly analyze their results.”

For more information:



« December 2015