Build and Run a Financial Package Summary

How to Preview Financial Package Reports

1. Save the Financial Package report with updated changes.

2. Click Preview from within the Financial Package interface to open the Financial Package Preview page, which allows you to determine where you’d like to place the output file and what kind of notification you’d like to receive.

   • E-mail notification - Select to add email recipients to whom you wish to send a copy of the report.

   • Attach generated document to e-mail - Select to include the report output in the status notification email.

   • Save to File Cabinet - Select to have the output document saved to a folder in the File Cabinet.

3. Select a file location destination.

4. Click OK on the Financial Package Preview page, once your selections are complete, to return to the Report page. A message will be displayed indicating that the Financial Package document has been created successfully.

5. Click the link provided in the message to download the created Financial Package document.

Linked Documents

There are two options to store attached documents: System or File Cabinet. When updating documents, there are different procedures depending on where you have chosen to store the document.

If System file is selected, the document you are using in the Financial Package output file is maintained on either a local drive or a shared drive within your network.

• Hidden sheets cannot be linked from an Excel workbook.

• Excel Add-in files should be tested and confirmed.

• Sheet selection is allowed only in system uploads.

• There is no limitation to the number of sheets that you can have in the uploaded Excel document.

Updating Linked Documents

To update a linked document: 

1. Open the document locally (in Word or Excel), make the change, and save the file.

2. Open the Financial Package Report in the Reports File Cabinet and open the required section.

3. Select Browse to navigate to the updated file and save the changes made to the section.

4. Preview the FPP.

Rendering a Report Leveraging a Template

• Microsoft Excel default page numbers are supported, but customized page numbers are not supported in the header/footer. Use alignments (left/right/center) for the header/footer instead of spaces. If the page number is included with spaces, starting at page 10, it will wrap to the next line.

• The cover page of the Financial Package report can be designed using a Microsoft Word Template and attaching it to the Financial Package report. You can also define header and footer and apply a watermark logo in the template to generate a nicely formatted Financial Package output.

• Ensure that you define only one page for the Cover Page in the template. If the content in the cover page is more than one page, the content after the first page is truncate during the Financial Package Word document creation.

• Reduce the size of your margins in the template to provide more area for rendering either reports or referenced Microsoft Excel or text documents (Word or plain text). It is recommended that you increase the area so that the resulting report is presented in a clear and easy to read manner.

• Template margins are applied to the generated Financial Package report for all sections, including document uploads. Ensure that the margins are applied without overlapping the header/footer section. The bottom margin of a page should be above the top margin of the footer. The top margin of page should be below the bottom margin of the header. Do not overlap.

• You can modify the Heading Styles that the Financial Package output document uses. To make the change to the styles, open your template and select the Styles Window. Within the Style Window, highlight the Style you want to modify and select the drop-down arrow and select “Modify”.

• You can change items such as font, font size, and color. Once complete, select New documents based on this templateto apply the settings to all future Financial Package Reports that are generated based on this template.

If you have the Financial Package output report open when making the change to the template, close the Financial Package output report and Preview the report again. you cannot re-generate the output to see the results of changes made to the template.

Overrides, Use Cases, Expected Results

When you add a report to a Financial Package report, some selections can be overwritten. For example, a POV could be applied or there could be selections made in the Financial Package interface (i.e. page selections in Financial Package for run-time purposes) that will change the output of the report once generated in the Financial Package.

The order of precedence in which data is populated in Financial Package reports is as follows:

1. Financial Package selections

2. POV selection

3. Report selections

Setup and Expected Results

The following are the expected results when a Finance Dynamic Report is added with Dimension security applied:

Override Substitution Variables

You can edit substitution variables (either standard or dynamic) for Dynamic Reports in a Financial Publishing Package (FPP), for variables that are used in the header and footer, member selections, report sets, or line headers.

If a variable is part of a Dynamic Report, the Substitution Variables icon is displayed in the toolbar when the report is selected as part of the FPP. Clicking the icon launches a window which displays a consolidated list of all the substitution variables used in the reports. You can then override the default variable values before generating the Dynamic Report by clicking the variable and making the desired change. The override is applied to preview or generation of the FPP.

Additionally:

• If a single variable is used in multiple reports or multiple times in a single report, it is displayed only once in the User Prompt and takes the common value;

• Icons appear in the gird if the variable is used on headers, report sets, or dimensions;

• If the same variable is used in the header of one report and on the report set in another report, both header and report set icons are shown;

• Default values from master substitution variables are displayed in the dialog, and you can update the variable values before running the FPP.

Security and User Types

The following items describe the security access and roles required for successful execution of Financial Package Reports that contain Dynamic Reports.

1. If a user is a Report Administrator, they can run any Financial Package Report. All of the sections of the Financial Package Report will be rendered. Where the user's dimension security applies, that user will be able to view the data within the report.

2. If the user is a Report User:
   • The user can be given read or full control access to the Financial Package report or folder in Report Security, which allows that user to review the structure of the Financial Package report and preview it. To be able to view all artifacts contained within the Financial Package report, the user must have read or full control access to the artifacts (reports, documents stored within the File Cabinet). It is not required that users are given folder access to folders that contain stored artifacts in order for those artifacts to display accurately in the Financial Package output.
     • If a user is added as an owner of the report, that user can preview the output. All sections will be displayed and where the user's dimension security applies, the user will be able to view the data within the report.
       • The Owner of the report will be able to perform the following actions that a participant can’t:
         • Change the Code, Name, Description, Due Date, Report Folder, and Template associated with the report.
         • Change the Owner
         • Add Participants
       • Participants can preview and generate Financial Package reports. If the user is not an Owner and is added to some sections of the report only as a Participant, that user will be able to Preview the Financial Package output, but will only see the sections for which they are Participants and data where their dimension security applies.
         • Participants are restricted by:
           • Any properties associated with sections which they have not been “Assigned To”
           • Financial Package Report properties
           • The inability to add a new section
           • The inability to add Report Access unless the user has been given “Full Control” of the Financial Package Report in Maintenance > Admin > User Management > User > More list-box > Report Access