Overview of Smart View for Google Workspace

Oracle Smart View for Google Workspace provides a common Google Workspace interface designed specifically for Oracle Fusion Cloud Enterprise Performance Management business processes.

Smart View enables users of Google Workspace to access Cloud EPM data, work on forms, and perform ad hoc analysis in Google Sheets. Using Smart View, you can view, import, manipulate, distribute and share data in Google Sheets.

To use Smart View in Google Sheets, you need to install the Smart View add-on extension from Google Workspace Marketplace. The Smart View add-on extension enables Google Workspace users to take advantage of Smart View functionality in Google Sheets.

Video

Your Goal Watch This Video

Learn how Smart View for Google Workspace enables Cloud EPM users to access Cloud EPM data, work on forms, and perform ad hoc analysis in Google Sheets.

video icon Introducing Smart View for Google Workspace

Supported Features

The following features are supported:

  • Form operations such as Open and Refresh Forms, Submit Data from Forms, Copy Versions, and View Instructions
  • Ad hoc analysis operations such as Zoom, Pivot, Keep/Remove Only, Insert Attribute, Cascade, and Save Ad Hoc Grids
  • Multiple connections in one spreadsheet
  • Smart View Options and Favorites Menu
  • Cell Styles
  • Member Selection
  • Drill Through in Web Browser only
  • Adjust, Grid Spread, and Mass Allocate
  • Multiple-Grid Ad Hoc Sheet
  • Flex Form
  • User Variables
  • Business Rules
  • Functions: HsGetValue, HsSetValue, HsAlias, and HsGetSheetInfo
  • Member Formulas
  • Task List
  • Approvals
  • Job Console
  • Accessibility

Note:

Because Oracle Smart View for Google Workspace requires that additional processing takes place on Google’s servers, you may observe slower than expected performance times for some operations.

Unsupported Features

The following features are currently not supported in Oracle Smart View for Google Workspace:

  • Dashboards, Reports, and Books
  • Operations like Spreading data for time periods, Drill through in new sheet, Undo and Redo, Copy and Paste, Save and Clear formatting, and Calc on the Fly
  • Web launch
  • Query Designer
  • Google Docs and Google Slides
  • Scripts
  • Composite Forms: No future plans for support.
  • Dimension Headers: No future plans for support.
  • Save as Smart Form (Native mode): No future plans for support.
  • Native mode for ad hoc operations: No future plans for support.

    Native mode is being phased out in favor of Standard mode, which offers enhanced features and is recommended for all users. To utilize Smart View effectively, Oracle advises you to configure your Cloud EPM applications to use the Standard mode option for the Smart View Ad Hoc Behavior setting. This ensures compatibility and access to the latest functionalities.