Friday, August 26, 2016

Oct 2016 : What's new with DV Desktop V2 (12.2.2)

Oracle DV Desktop V2 (12.2.2) just released today (Oct 18th), see an overview of new features included in this community entry.

This brief video gives a tour of new features in DVD V2 :

Highly interactive R 3D Visualizations on OBIEE Dashboards

Visualizations in R are great and the world has been using it for quite long now. But the possibility of visualizing your R processed data with 3-Dimensional and highly interactive web-based html based visualizations opens door to whole new range of possibilities. Yes! It is possible to visualize your data using such cool and highly interactive R visualizations on OBIEE dashboards.

Earlier versions of our OBIEE SampleApp have numerous examples that leverage OBIEE Advanced Analytics and display vizs generated using custom R-Scripts in an static image format. With web browsers that support web graphics libraries users can now render fully interactive and cool visualizations generated by custom R-Scripts on OBIEE dashboard. Latest OBIEE SampleApp V607 has these examples.

Take a look at this video to see how it works:

Thursday, August 25, 2016

Oracle JET Visualizations on OBIEE Dashboards!

OBIEE supports Custom visualizations to tailor fit the requirements of Developers and end users. Many versions of OBI SampleApp include various examples to showcase these custom visualizations. 

In OBIEE SampleApp V607, this capability of OBIEE to support Custom visualizations is taken to next level: Now, OBIEE supports cool new visualizations developed using Oracle JET Libraries. 

Oracle JET (JavaScript Extension Toolkit) is a collection of open source and Oracle contributed JavaScript Libraries. JET Visualizations not only visualize data from reports using cool visualizations, they also allow lot of customization, interactivity and support lot of animations. 

Take a look at this video to see how JET Visualizations look like on OBIEE Dashboards: 

For more Information on Oracle JET: Click Here

Friday, August 19, 2016

Oracle IoT integration with BICS

Oracle IoT enables users to digest large volumes of BigData directly in BICS.  Watch the following recording to see how IoT and BICS work together for seamless integration and real time Data Visualization reporting. 
  • HVAC simulator
  • direct data stream into BICS db
  • Seamless Data Visualization reporting
  • export data from BICS for localized DVD analysis

Using Groups and Conditional Groups in Oracle DV to extend your data

 Oracle Data Visualization includes various tools to extend and enrich user's data. Groups and Conditional Groups under the data stage in Oracle DV are examples of this.

This brief video below shows how to wrangle your data to add groups or conditional groups. By “Grouping” a column, we create a user-defined column with groups that contains one or more member values of that column.  “Conditional grouping” also adds a user defined column but in this case groups are determined based on conditions evaluated on its column values.

Wednesday, August 17, 2016

Diagnostics Support for Oracle Data Visualization Desktop

If you are working with the Oracle Support team to resolve a specific issue in Oracle Data Visualization Desktop, they may ask you to generate a diagnostic dump file.
Oracle Data Visualization Desktop comes with an inbuilt tool to gather detailed diagnostic information in event of failure or error.
This diagnostic dump can be used by technically adept end users to diagnose issues themselves or can be handed to Oracle Support for expert analysis.
The resultant dump file contains the following information:
      1. Version Information
      2.  Installer Logs
      3.  App Component logs – status info of BI Presentation server, BI Server and other critical                components
      4.  Jetty Logs
      5.  DSS logs
      6.  Webcat metadata plugin logs
      7.  Derby logs
      8.   SAW Server logs
      9.   BI Presentation Server Logs
     10. BI Server logs

Steps to generate the diagnostic dump file:

 1)   Open the command prompt and change the directory to the Data Visualization Desktop               installation directory (for example, C:\Progra m Files\Oracle Data Visualization).

    2)  Type diagnostic_dump.cmd and then provide a name for the .zip output file (for ex:

    3)  Press the Enter key to execute the command.

    4)   You can find the diagnostic output file in Data Visualization Desktop installation directory.         Unzip the log files to view contents

Leverage the 'Attribute' function to boost your DV insights

The 'Attribute' Function in DV and OBI calculations allows to treat any aggregated metric value into an attribute discrete member.
Calculated metric values can thus be used as series for any visualizations, like bar charts for example. 

If you ever used the 'Treat as an Attribute' flag in the Answers expression editor, the ATTRIBUTE function is the syntax behind this functionality. it's accessible in any calculations in DV or OBIEE.

An example of the value that this capability brings, is when one needs to compute aggregates on rows that are grouped by values of another metric aggregate : How much revenue is contributed annually by all customers that only buy once from us, twice, thrice, etc cohorts ?


The explicit syntax for this function is :  
ATTRIBUTE(<expression> BY <attribute list> WHERE <predicate>)  
The BY clause may be empty, in which case grand total grain is assumed.

Friday, August 12, 2016

Oracle DV direct connector to RightNow Cloud Service

Oracle Data Visualization offers a direct connection capability to RightNow Cloud Service.

The brief video below showcases how to quickly configure it and leverage DV visualization and wrangling features to derive immediate live insights from your RightNow Cloud Service.

Thursday, August 11, 2016

OBIEE SampleApp V607 available for free download on OTN

OBIEE SampleApp V607 is available for public download from OTN here.

SampleApp V607 combines the technologies of Oracle Business Intelligence Foundation 12c  together in a standalone virtual box image creating a comprehensive OOB collection of examples and integrations designed to demonstrate Oracle BI capabilities, product integrations, and design best practices.V607 includes several Oracle products pre-installed : 

 Below is a summary of new additional content in this version of the image : 

Use Data Blending option to influence join types in Oracle DV

Oracle DV Data Blending option allows to control the type of join between two data sources in a report : Full, Left or Right Outer. 

In any given visualization using at least two data-sources, user can directly influence if the report should return all rows from each source, or only the rows that satisfy the matching join on one side or on the other side.

The recording below shows how to leverage this option, and the influence in the result set in the report.

Building Infographics by leveraging Oracle DV Freeform Layout

Oracle DV enables Freeform layout for Visualizations canvases, allowing users to exactly set the position of each element, and overlay visualizations one on top another.
Using Freeform layout, it becomes easy to compose custom infographics, with background images overlaid by interactive visualizations showing insights on underlying data. All in a meaningful, optimized overall layout representation.

Use the free example available on the Public-store (search for ID:60811A on left search dialog). You can deploy it in seconds on your own Oracle DV to see how it's built.

Tuesday, August 9, 2016

BICS August 2016 update : Email delivery of BICS reports

An update of BICS services happened over August 07th weekend. 

The new patch includes a number of bug fixes on the services, along with an e-mail delivery capability for BICS end users. The feature allows e-mail delivery of report content on demand or on a schedule, by a simple right click on any Webcat Answers reports object.