User's Manual

20-6 Oracle Financial Consolidation Hub User's Guide
For dimensions in the page level of a report, you can select a particular value. If
multiple values are available, the page level value is a list. When you select a value, the
report will refresh to show the balances that correspond to the selected value.
Export to PDF
You can export a report to PDF format. To do so, select the Report > Export to PDF
function under the Consolidation menu.
Note: The Export to PDF functionality currently does not support
images.
Saved Selections
To assign saved selections to a report, select the Report > Saved Selections function from
the Consolidation menu. The window will list all of the reporting dimensions. To select
a saved selection for a dimension, use the list next to the dimension. If you want to set
the values to be the original values when you opened or created the report, change the
current values showing up for a dimension, leave the list on Original Selection.
See: Creating Saved Selections, page 20-8
Note: The Enterprise Planning and Budgeting user interface allows you
to select members for a dimension without saving it as a saved
selection. The Excel Add-in, however, does not allow you to do this.
Layout
To change the layout of the report, select the Report > Layout function under the
Consolidation menu. Drag and drop which dimensions will show up in the rows and
columns of the report, which dimensions will be at the page level and which are
hidden. If there are multiple dimensions in any of the regions, you can drag and drop to
reorder them.
Modifying Reports using Excel Modifications
You can modify a report with any functionality available in Excel, anywhere in the
spreadsheet. Some examples of Excel functionality are:
• Insert Excel formula into the chart region of the report.
• Create an Excel chart based off of the report.
• Change the font, colors, and bordering of the report.
• Add titles and additional text to the report.
You can create Excel formulas and charts based off of the report. If the balances in the
report are changed due to analytical report modifications, for example selecting a