Shortcut Menus

Data object shortcut menus are context sensitive to headers, cells, dimensions, and data values. It provides immediate access to advanced formatting and function options:

Command

Description

Submenu

Browse

Displays the Dimension Browser dialog box, used for member selection

 

Keep Only

Retains only the selected member

 

Remove Only

Removes only the selected member.

 

Drill

Increases or decreases the level of dimension detail

  • Drill

  • Down

  • Up

  • To Top

  • Options

Analysis Tools

Applies sorting, ranking, filtering, calculation, and conversion definitions to the current selection

  • Analysis Tools Manager

  • Traffic Lighting

  • Sort

  • Retrieve Only Top/Bottom

  • Restrict Data

  • Calculation

  • Show/Hide Only

  • Format

  • Currency Conversion (On SAP BW data sources)

  • Unit of Measure Conversion (On SAP BW data sources)

Related Content

Accesses data from other Oracle | Hyperion sources

 

Search

Searches for a member in the selected dimension

 

Data display

Sets custom data display behavior

  • Selected Member

  • Selected Member First

  • Default Label Mode

  • Product-specific Label Mode

  • Dimension Header Sort (Default, Ascending, Descending, Level, Generation)

  • Show Linked Reporting Object Indicators

  • Suppress (Missing Rows, Shared Members, Zero Rows)

Refresh data

Refreshes the data from the data source

 

Export Data

Exports data values

You can export to Microsoft Office, to a tab-delimited text file, or to the operating system clipboard in these formats:

  • Query-ready

  • Formatted

  • Image

  • Export Entire Report

  • Unformatted

Print

Displays the Print dialog box, used to print the current page of the data object

 

Formatting

Displays the Formatting dialog box, used to set header and cell formatting options

 

Edit data

Edits cell values and writes them back to Essbase

Spreadsheet Options

Displays the Spreadsheet Options dialog box used to select options. For charts, opens Chart Properties

 

Column Sizing

Sets the column width

  • Autosize

  • Custom width

  • Set all columns to this width