New Features in the Essbase Web Interface

The following new features add to the usability of the Essbase web interface.

Note:

Redwood, the default Essbase web interface is Oracle’s standard interface with a modern look and feel.

The updated interface features a new Redwood look and feel, with enhanced functionality in many areas:

  • You work in the context of the application or cube instead of working in the application and cube inspectors.
  • Objects such as scripts or the outline are opened in tabs, so you can easily toggle between them.
  • Functionality for adding members is enhanced. You can provide, in one dialog, all the general properties like storage type, dimension type, solve order, formulas, attributes, and UDAs. You can also add the multiple members consecutively using the shortcut ‘Ctrl + Enter’ or by clicking the Add button without closing the dialog.
  • Search capability is enhanced, with improved performance and access to the following operations in the Search dialog: Locate, Member inspector, and Hierarchy (Shows the hierarchy of the member in a tree view, where you can locate, launch the member inspector, or add a sibling or a child, if the outline is in Edit mode).
  • Compare two outlines side-by-side. See Compare Outlines.
  • Copy and Paste Members Within and Between Outlines. This can be between two different outlines, shown on different browser tabs, or from a source to a target outline when using outline compare.
  • View notifications from your active session. See View and Manage Notifications in the Essbase Web Interface.
  • Write and edit Essbase scripts using enhanced script editing capabilities in the Redwood Interface. See Write and Edit Scripts.
  • Navigate between applications by using the Global Menu, which opens supported pages in separate browser tabs.
  • Use enhanced search and filtering on the Jobs page, including Case-sensitive or Case-insensitive search, and Advanced Filter options.
  • Manage multiple files by selecting them using the check boxes on the Files page, and then use the Actions menu to Cut, Copy, or Delete the selected files.

Navigate Across Applications

In the Essbase web interface, you can use the global menu to quickly access commonly used pages.
  1. On the Home page, select the global menu.
    Global menu

  2. Select one of the available pages.
  3. The selected page opens in a new browser tab.

Enhanced Job Search and Filtering

The Jobs page includes enhanced search and filtering capabilities to help you locate jobs more efficiently.

To search for jobs:
  1. Open the application.
  2. Open Jobs.
  3. Enter text in the search field.
  4. Click Search search icon or press Enter.

You can refine the search results by using advanced filter option.

To filter job results:
  1. Select the Advanced Filter.
    Image of the advanced filter option

  2. Specify one or more filter criteria, such as Search By, Job Type, or Date Range.
  3. The job list is automatically updated to display the matching results.
  4. Click Reset to clear the selected filter criteria.

Note:

By default, searches are case insensitive. Select the Case sensitive option to perform a case-sensitive search.
Image of the case insensitive


Image of the case sensitive

Manage Multiple Files

You can select multiple files on the Files page and perform actions on the selected files.

To manage multiple files:
  1. Open the application.
  2. Open the Files page.
  3. Select one or more files by using the check boxes.
  4. Click Actions.
    Action menu

  5. Select Copy, Cut, or Delete.

The selected action is applied to all selected files.

Quick Access to Open a Cube, Open an Outline, or Analyze Data

In the Essbase web interface, you now have quick access to open a cube, open an outline, or analyze data.

You can open a cube from the Home page.
  1. On the Home page, find the application.
  2. Select the Actions menu for that application Image of the actions menu icon..
  3. Choose Databases > database_name.
    Image of the Applications page, Sample application, with Databases and Basic selected.

You can open an outline or analyze data in the Essbase web interface in two ways. You can open outlines or analyze data from within the cube,

  1. Open the application.
  2. Open the cube.
  3. Click Launch Outline or Analyze Data.

Now you can also open them from the Home page.

To open an outline from the Home page.

  1. On the Home page, find the application.
  2. Select the Actions menu for that applicationImage of the actions menu icon..
  3. Choose Databases > database_name > Launch Outline.
    Image showing the Actions menu for an application on the applications page, with Database > database_name > Launch Outline selected.

To open analyze data from the Home page.

  1. On the applications page, find the application.
  2. Select the Actions menu for that applicationImage of the actions menu icon..
  3. Choose Databases > database_name > Analyze Data.
    Image of the Applications page, with the actions menu for an application selected, and Databases > database_name > Analyze Data selected.

Bookmark an Active Browser Tab for Quick Access

Using your browser's bookmark feature, you can bookmark specific applications, cubes, scripts, or any active browser tab in Essbase to quickly return to that location.

Simply bookmark the browser tab you want to save, and use the bookmark to return there. This allows you to return to the specific application, database, script, or any active browser tab without going through all of the steps to navigate there in the Essbase web interface.

Open Artifacts in a New Browser Tab or in an Editor

You can open certain Essbase files in a new browser tab or in an editor. This works for files that have dedicated editors in the Essbase web interface.

To open the following file types in a new browser tab or in an editor
  • .csc – calculation scripts
  • .rul – rule files
  • .rep – report scripts
  • .msh – MaxL scripts
  • .mdx – MDX scripts
  • .dtr– drill-through reports
  1. On the Home page, select the application.
  2. Select the cube.
  3. Click Files.
  4. Go to the Actions menu for a file Image of the Actions icon..
  5. Select Open in New Browser or Open in Editor.

    Note:

    Some file types, such as .txt and .xml cannot be opened in this way. You can, however, download .txt and .xml files using the Actions menu to the right of the file.

To open a file in an editor, from within the application,

  1. From the Home page, click Files.
  2. Navigate to the cube directory, Applications > application name > cube name.
  3. Click the name of the file you want to open in an editor.

    Note:

    Some file types, such as .txt and .xml cannot be opened in this way. You can, however, download .txt and .xml files using the Actions menu to the right of the file.