Navigating Data Objects and Data Sources

Web Analysis documents contain a variety of non-static data objects:

Spreadsheets
Charts
Pinboards
SQL Spreadsheets
Freeform Grids

You can rearrange, expand, change and concentrate dimension intersections; these are called navigation methods because they enable travel through dimensional hierarchies.

Navigation methods vary for data objects and data sources:

Table 1. Web Analysis Studio Supported Data Sources

Type	Data Source
OLAP	Essbase IBM DB2 OLAP Server SAP BW
Oracle \| Hyperion	Financial Management Oracle Hyperion Planning, Fusion Edition
Relational	IBM DB2 Enterprise Server Edition Microsoft SQL Server Oracle Teradata Other JDBC RDBMS

Type

Data Source

OLAP

Essbase

IBM DB2 OLAP Server

SAP BW

Oracle | Hyperion

Financial Management

Oracle Hyperion Planning, Fusion Edition

Relational

IBM DB2 Enterprise Server Edition

Microsoft SQL Server

Oracle

Teradata

Other JDBC RDBMS

OLAP data sources support all navigation methods described in this chapter. Other Oracle | Hyperion data sources and relational data sources support fewer navigation methods.