Analysis Tools

Web Analysis Studio enables you to leverage server-based analytical formatting tools and data source-specific tools from the client. Analysis Tools expedite comparisons, visually organize data, and promote structures and conclusions.

Analysis Tools are data source-specific, and all Analysis Tools are not available in all data objects.

Analysis Tools are centrally organized and applied by the Analysis Tools Manager, accessed using the data object shortcut menu. The Analysis Tools Manager features an Ordered By panel showing the number and order of Analysis Tools definitions activated on the current data object. Toolbar buttons enable you to generate Analysis Tools definitions.

Analysis Tool

Used To:

Traffic Lighting

Color-code dimension member values based on fixed limits or a comparison of values.

Traffic Lighting visually associates member values whether they are sorted or ranked.

Sorting

Order the query result set.

Calculations

Create calculated rows and columns.

Data Formatting

Format data values based on member or value criteria.

Show/Hide Only

Filter data by color, value and member.

Related Content

Create Related Content links to:

  • LROs - cell notes, URLs, and file attachments stored at Essbase intersections

  • Oracle Essbase Integration Services drill-through content

  • Financial Management cell text and line item details stored at Financial Management intersections

  • Oracle | Hyperion Documents content displayed as HTML or PDF

  • Oracle's Hyperion® Application Builder for J2EE content

Restrict Data

Restrict the query result set based on criteria.

Retrieve Only Top/Bottom

Limit and rank the query result set.

Currency Conversion

SAP BW—Converts data value currencies ad hoc during analysis, and to save those conversion definitions as analysis tools.

Unit of Measure Conversion

SAP BW—Converts the data value unit of measure ad hoc during analysis, and to save those conversion definitions as analysis tools.

Edit Selected Definition

Opens the Analysis Tool for the specified definition, enabling you to edit the definition.

Remove Selected Definition

Deletes the selected Analysis Tool definition.

Remove All

Deletes all defined Analysis Tools definitions.