Work on Reports in Google Sheets

You can now open and work on Reports in Google Sheets using Oracle Smart View for Google Workspace.

Applies to: Planning and Budgeting, Profitability and Cost Management, Close Management and Consolidation, FreeForm, Tax Reporting

Reports is the standard reporting tool for creating Cloud EPM reports. Using Oracle Smart View for Google Workspace, you open Reports in Google Sheets and perform the following actions:

• Import a report grid as an ad hoc grid and perform ad hoc operations on the grid.
• Import a report in a new spreadsheet as a fully-formatted report.
• Insert a report in the same spreadsheet as a fully-formatted report.
• Once inserted or imported, you can do the following operations on formatted reports:
  • Edit POV and prompts in the report.
  • Analyze a grid in the inserted report to perform further ad hoc operations.

In the Smart View Home panel, all available reports can be accessed from the Reports folder. Alternatively, if reports are stored in a user-defined folder, you can find them in the respective folder. You can right-click on a report to import it as an ad hoc query, import it, or insert it in the same spreadsheet. In the Extensions menu, under the Smart View for Google Workspace menu, a new Reports menu is introduced with options to edit POV, edit prompts, and analyze grid from the imported report.

Business Benefit: Users of Google Sheets can now open and work on Cloud EPM Reports using Oracle Smart View for Google Workspace.

Key resources

• Reports in Working with Oracle Smart View for Google Workspace