Using OBIEE Visual Analyzer with Teradata Database

Applications
Applications covers the world of Teradata apps, including apps offered by Teradata (such as TRM or DCM), as well as best practices and methodologies for building your own Teradata-connected apps.
Teradata Employee

Using OBIEE Visual Analyzer with Teradata Database

OBIEE VISUAL ANALYZER

 

Background

Visual Analyzer (VA) is a web-based tool that allows the business user to explore data visually. Creating visualizations is so easy in Visual Analyzer that the data analysis work becomes more an individual experience in exploration and discovery rather than an extended process of constructing views from data.

The Visual Analyzer user interface takes a few, simple inputs then automatically creates rich, compelling graphics. The ease with which visualizations are created allows the user to experiment with a wealth of different options for visualizing the data and making discoveries in terms of trend, correlations and patterns.  In addition, with Visual Analyzer’s capability to load external data sources, you get self-service mash-ups of data; the blending of governed enterprise data combined with your own files.

Visual Analyzer is available with OBIEE 12c as well as stand-alone.  The stand-alone version is called Data Visualization Cloud Service (DVCS) and is one of Oracle’s cloud application offerings.

Overview

OBIEE and DVCS both work with Teradata as a data source.  The connectivity between the systems is accomplished with ODBC.  Any of the recent versions of Teradata database and Teradata ODBC work with Visual Analyzer.  See the product support matrix for exact versions that are supported.  This article will show how to use the Teradata database with VA.  This article assumes that OBIEE is already installed and running.  If that is not the case, there is an article on Teradata Developers Exchange that shows how to get and use the OBIEE Sample Application to access the Teradata Database.  The same article also shows how to install and configure the Teradata ODBC drivers.  Once connectivity is in place, the OBIEE rpd can be updated with Teradata metadata.

Working with Visual Analyzer

  1. Sign into Oracle BI and launch Visual Analyzer.  This is done from the home page:

2. In the browser provide username/password and click on Sign in.

      3. After signing in, go to the left pane and select Create VA Projec.

   

4. Once you select VA Project, Visual Analyzer is launched in a separate tab

5. Now you can use the data model to create the visualizations. In the Add Data Source window, select any Subject Area and then click Add to Project

6. The canvas along with the Data Elements pane is displayed.  Any Teradata data source can be used.  In this example, the AutoSnowflakeSales subject area is from northwind rpd (Teradata rpd) and the data is coming from Teradata.

Items can be selected from the Data Elements pane.  These are instantly shown in the results pane. 

See the section below on “changing visualizations” for examples of VA output.

Mashups

One of the features of OBIEE is the new concept of data mashups.  Users can mash dataset together to look for patterns.  Data Mashups allow self-service extensions to BI data model.  Users can upload spreadsheets as datasets into the BI system and can query data in the spreadsheets in conjunction with curated data.

  1. For Mashups, create a new data source and import data from Excel fie.

2. After importing the Excel file, add the excel file to the project

In the above screenshot, VA_Sample2 is the Excel file.

To work with Excel, we should have one common column between subject area and the excel sheet. Based on that common column it will aggregate the data to show analysis.

Changing Visualizations

Visual Analyzer provides quick and easy creation of interactive visualizations with a standard set of visual controls.

  1. Drag and drop required Data Elements to the canvas.
  2. You can change the visualizations as per your requirement.

3. The horizontal stacked bar chart, Revenue by Product is displayed below. Visual Analyzer selected horizontal stacked bar chart as the most appropriate visualization for the selected data elements.

4. Change the visualization type. Select Horizontal Bar from the drop-down list in the Explore panel. You can also change the visualization type from the View Select Dialog icon View Select Dialog iconpresent in the Visualization toolbar

5. You can also add colors to the visualizations. Drag Region to the color area of the Explore panel

6. The horizontal bars are displayed with different colors on the basis of region. Notice also the title changes dynamically.

This article has shown what Visual Analyzer is and how to work with VA and Mashups by changing different types of visualizations using data that is coming from Teradata Database.