Skip to main content

Menus in the Hubble Desktop Viewer

Note:
Some menus (for example the Budgeting menu) will only be displayed if you have the required licenses and capabilities assigned to you in the Administration tool.

Home Menu


  • Run - Execute an inquiry based on the currently selected filters to return a result set
  • Open - Open a previously saved inquiry from the Object Repository
  • Close Inquiry - Close the currently active inquiry
  • Close All – Close all open inquiries
  • Favorites - Add an inquiry as a favorite for easy retrieval, manage favorites and retrieve previously marked favorites
  • PDF - Output single or multiple result sets in PDF format for subsequent printing
  • Excel - Export single or multiple workbooks to Microsoft Excel
  • Print Options – Set the options to export to PDF
  • Excel Options - Set the options to export to Microsoft Excel
  • Enter Comments – Enter comments in a comment column
  • Filter Selections – Specify selections for any filter regardless of whether the filter is available on the screen or not
  • User Defined Filters – Define and save pre-set filter criteria to be used in inquiries
  • Choose Selectors – Specify the current value for the defined selectors
  • Sort Ascending – Sort the selected column in ascending order
  • Sort Descending – Sort the selected column in descending order
  • Restore Sort – Restore to original sort order
  • Subtotals/Headers – Toggle whether subtotals and headers are displayed in the inquiry
  • Hide Details – Set whether headers and totals display without the detail lines
  • Show Visualizations - Toggle whether chart, data or both display in the inquiry
  • Default Drill Link - The link that will be used as the default, meaning when you double-click on a value, that link will be used

Restatement Menu (Currency Restatement Licensees and JD Edwards users Only)

For JD Edwards users only. You must also be assigned a Currency Restatement License to see this menu.


  • Exchange Rate Restatement - Display all exchange rates used in the current report, given the current filter settings

Budgeting Menu / Planning Menu (Budgeting Licensees Only)

This menu is called Budgeting for JD Edwards users, and Planning for Oracle EBS users. You must be assigned a Budgeting License to see this menu.

  • Activities - Open the Budget Setup dialog
  • Hubble Ledgers - Define a ledger for use in budgeting or forecasting
  • Forms – Define a form for use in budgeting or forecasting
  • Open Form – Review budgeting forms and their related cycle and status, as well as open the form
  • Enter Budget - Toggle going in and out of Budget Entry Mode, enabling you to enter budgeting or forecasting data into the form defined
  • Enter Comments - Enter comments associated to a specific row
  • Finalize - Enabled only if a cycle is ready to be finalized, this button will prompt you with confirmation request if selected
  • Cycle Status - Open the Cycle Status dialog
  • Upload - Upload your Microsoft Excel workbook back into Hubble
  • Download - Download the designated Microsoft Excel workbook from the repository to the local workstation
  • Create - Create an Excel export to use the budgeting form as a reusable model
  • Cascade - View the progress of each item as well as the overall progress of Cascade.

Quick Access Toolbar

The QAT or Quick Access Toolbar is located at the top left corner of the screen and it allows you to quickly access the operations you access most frequently, such as Run:

The buttons in the Quick Access Toolbar are retained after logging out and back into the application.

Quick Access Toolbar Options - When you click on the arrow to the right of the Quick Access Toolbar, you have three options:

  • More Commands
  • Show Quick Access Toolbar below the Ribbon
  • Minimize the Ribbon

Quick Access Toolbar Customization

To customize the Quick Access Toolbar, follow these steps:

  1. Click on the drop-down menu of the toolbar and select More Commands:
  2. All available commands are in the left panel. Select the command(s) you wish to use by moving it to the right hand side. On the right side is a list of all buttons that are currently included in your Quick Access Toolbar.

  3. Click OK to save your changes and return to the inquiry.
To Undo an Option in Regards to the Quick Access Toolbar

To undo an option, such as the option to place it below the ribbon, click on the drop-down to the right of the Quick Access Toolbar and select that option again to deselect it.

Shortcut to Add Commands to the Quick Access Toolbar:

To add commands to the QAT:

  1. Highlight the button/function you wish to add to the Quick Access Toolbar, e. g. PDF.
  2. Right-click and select Add to Quick Access Toolbar.
Viewing the SQL Statement Being Used to Run the Inquiry

This is a common function that users add to their QAT First, your Administrator must grant you the capability to view the SQL statement being used to run your current inquiry. This is set in Administrator in Advanced Capabilities under Feature Control > Advanced Tuning. Set Editable to Yes and mark the checkbox to Show the Advanced Tuning Feature.

Once the capability is set, you can add this command to your Quick Access Toolbar by doing the following:

  1. Click on the drop-down menu to the right of the Quick Access Toolbar.
  2. Select More Commands.
  3. Scroll to the bottom of the available commands and under the COMMANDS NOT ON RIBBON heading, highlight View SQL and click Add to add it to the right panel.

  4. Click OK to return to your inquiry. The View SQL command will be added to your Quick Access Toolbar.
  5. After adding filter criteria to your inquiry, you can now click the View SQL command in the Quick Access Toolbar to view the SQL statement.

Minimizing the Ribbon

There are two ways you can minimize the ribbon:

  1. Click the drop-down menu to the right of the Quick Access Toolbar and select Minimize the Ribbon:

  2. Double-click any of the menus, such as Home:

To maximize the ribbon again, follow the same steps as listed above, either going to the drop-down menu to the right of the Quick Access Toolbar or by double-clicking on any of the menus.