Importing financial reports in smart view
In Reports , you can:
- Download a Report as an Excel workbook, which can be refreshed in Oracle Smart View for Office . You can later change the POV and respond to prompts, where applicable.
- Download a Report Grid as Excel ad hoc in Smart View , and you can perform available ad hoc operations.
In Smart View for Excel, you can:
- Import a Report as an Excel workbook.
- Import the Report grids as ad hoc grids, and then perform supported ad hoc operations on the grids directly against the data source, such as pivoting and member selection. You can save the grids and use them as sources for embedded content in report package doclets. See Working with Reports in Smart View.
- Working with Download as Excel
- Working with Download Grid as Ad hoc Excel
Working with Download as Excel
When downloading a report to Excel, a new Excel workbook will be created. If "Print All Selections" is enabled for one or more of the report’s POV dimensions, each printable page will generate a separate worksheet for each member combination of the report.
Note: The worksheet names will reflect the report name followed by the first POV dimension with "Print All Selections" , truncating the sheet name as needed to meet Excel’s 31 character limit.
Note: Report text boxes may appear distorted or with overlapping text when importing or exporting to Excel when the fonts used within the text boxes are not installed on the client machine. To fix this, install the missing fonts used within the text boxes on the client machine.
For information on differences between Reports and Reports rendered in Excel, see Differences between Reports and Reports Imported in Excel in Designing with Reports for Oracle Enterprise Performance Management Cloud .
The maximum number of rows and columns supported by Excel in a worksheet is 1,048,576 rows and 16,384 columns. Exporting a report to Excel can result in an error if the limit is exceeded.
Working with Download Grid as Ad hoc Excel
When downloading a grid as ad hoc Excel, the web browser will download a Smart View link file. Click on the file to launch Excel. You will be prompted to sign on to the respective Data Source login page. If you already have an active Data Source connection, the sign-on dialog will not appear.
- The Download as Ad hoc Excel option, while viewing a report on the web, is available for HTML Preview only.
- Reports Formatting is not retained in Excel.
- The output data in Excel are based on the Smart View Options . Review all the Formatting settings. For more information, see Setting Smart View Options.
- This feature is not available for hidden grids.