OBIEE 10G/11g - (Chart|Graph) View

Saw Object

About

A graph view displays numeric information visually, which makes it easier to understand large quantities of data. For displaying a single data value, a gauge is often more effective than a graph.

Graphs often reveal patterns and trends that text-based displays cannot.

However, when precise values are needed, graphs should be supplemented with other data displays, such as tables.

A graph is displayed on a background, called the graph canvas.

All graph types with the exception of scatter and radar graphs can be 2-dimensional (2D) or 3-dimensional (3D). Not all types of graphs are appropriate for all types of data.

Obiee Graph Line

Type

Bar

Data Visualization - Bar Chart

Line

Data Visualization - Line Chart

Area

Data Visualisation - Area Chart

Pie

Shows data sets as percentages of a whole.

Pie graphs are useful for comparing parts of a whole, such as sales by region or by district.

Styles:

  • Solid Fill
  • Gradient Fill
  • Pattern Fill

Obiee 10g Graph Pie

Line-Bar

Subtypes available:

  • Standard
  • Stacked

Plots two sets of data with different ranges, one set as bars, and one set as lines overlaid on the bars.

Line bar graphs are useful for showing trend relationships between data sets.

Styles:

  • Rectangle
  • Triangle
  • Cylinder
  • Diamond
  • Gradient
  • Pattern Fill

Restrictions:

  • You cannot drag and drop measure labels.

Time Series Line

Plots time series data. It scales the horizontal axis based on the time that has elapsed between data points.

A time series line graph requires a single date or date-time data column to be selected on the horizontal axis. It has a single vertical axis, but supports multiple data series.

See Data Visualization - Line Chart

Pareto

Is a form of bar graph and line graph that displays criteria in descending order. In this graph type, the line shows a cumulative total of the percentages.

Pareto graphs are useful for identifying significant elements, such as best and worst or most and least.

Styles:

  • Rectangle
  • Triangle
  • Cylinder
  • Diamond
  • Gradient
  • Pattern Fill

Restrictions:

  • A pareto graph can have only one measure.

Obiee 10g Graph Pareto

Scatter

A scatter graph requires at least two measures. For example, you can plot one measure column on the horizontal axis and another measure column on the vertical axis. These measures are plotted for values on the Group By axis.

Styles:

  • Standard Scatter
  • Scatter-with-Lines

Bubble

Is a variation of a scatter graph that displays data elements as circles (bubbles). It shows three variables in two dimensions. One value is represented by the location of the circle on the horizontal axis. Another value is represented by the location of the circle on the vertical axis. The third value is represented by the radius of the circle.

Bubble graphs are useful for:

  • plotting data with three variables,
  • and displaying financial data over a period of time.

Restrictions:

  • A bubble graph requires at least three measures. Plot one measure on the horizontal axis, another measure on the vertical axis, and a third measure on the bubble size axis.
  • you cannot drag and drop measure labels.

Radar

Plots the same information as a bar graph, but instead displays data radiating from the centre of the graph. Each data element has its own value axis.

Radar graphs are useful for examining overlap and distribution.

Logarithmic scale

In 11G, the logarithmic scale behaves in the following ways:

  • If you specify the scale limits, then the scale limits for the logarithmic scale must be powers of 10 only. If the number that you specify is not an exact power of 10, then the power of 10 closest to the number that you specify is used.
  • If you let the system determine the scale, then the lower limit changes dynamically based on the measure used.

In previous releases, the logarithmic scale behaved in the following ways:

  • If you specified the scale limits, then the scale limits for the logarithmic scale were numbers fully divisible by 10. If the number that you specified was not divisible by 10, then the number closest to the number that you specified that was fully divisible by 10 was used.
  • If you let the system determine the scale, then the lower limit always started at 1 and the upper limit changed based on the measures used.

Conditional formatting

Conditional formatting enables you to customize the appearance of a graph based on conditions applied to columns. The formatting is applied to the column values that meet the condition.

You can specify a color in which to display graph data based upon a specific column value, or range of column values that meet the condition specified for the column.

11G:

Obiee 11g Conditional Formatting Graph

10G:

Obiee 10g Chart Conditional Formatting

For example:

  • Conditionally changing the color of a graph based on specific column values.

A user wants to create a bar graph to compare sales between two beverages, Lemonade and Cola. When creating a bar graph the user specifies two conditions, one where the bar representing Lemonade sales is yellow, and another where the bar representing Cola sales is blue.

  • Conditionally changing the color of a graph based on a range of column values.

A sales manager wants to create a bar graph to compare sales for all reps across two sales bands.When creating a bar graph the sales manager specifies two conditions, one where the bar is red for all sales reps with sales less than 250,000, and another where the bar is green for all sales reps with sales greater than 250,000.

Sort Order

In 11g, it is not possible to sort data in a graph using a column that is not included in the view. You have to add the column in the view (and hiding it required) to apply the sort order

Documentation / Reference





Discover More
Saw Object
OBIEE - (Answer|Analytics) Views

View (data displays) are used to display the data result set of an analysis. They are build using ADF DVT. Adding...
Obi Edition
OBIEE - Java Host

The Oracle Business Intelligence Javahost provides services to BI Presentation Services for Style and Skin, Charts, Gauges and PDFs. The services are provided based on request-response model. BI Javahost...
Obiee 11g Pivot Display As Running Sum
OBIEE - Running Sum (RSum)

Running Sum is a display function. This function calculates a running sum based on records encountered so far. The “By” statement resets its values for each group. Logical SQL: Result: ...
Saw Object
OBIEE 10G/11G - Answer/Analytics

(Answers 10g|Analyses 11g) is the base component of BI Presentation Service to create Web report . It provides: ad-hoc query and analysis capabilities. The definition of an answer is principally...
Obiee11g Map View Component
OBIEE 11G - Map View

Map view is a new view in 11g that permit to include a mapviewer map in an answer. When you edit a map view and work with layers, you create formats for those layers. For example: the floor maps of...
Obiee 11g Master Detail Properties
OBIEE 11G - Master Detail

Master-detail linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail...
Obiee 11g View Layout Drop Target
OBIEE 11G - The drop targets of a layout (view|pane)

In the documentation, the different drop target (area) of a view are used. The below picture shows what means: Page Edge Section (Section Sliders if the check box “Display as Slider” is checked...



Share this page:
Follow us:
Task Runner