Note: | Financial Reporting supports Public Sector Planning and Budgeting with the ability to produce a Budget Book containing Financial Reporting reports and textual data in PDF format or deployable html Web site. See Oracle Hyperion Public Sector Planning and Budgeting User’s Guide for information. For a brief overview, see Using Books in Public Sector Planning and Budgeting. |
Books are created, edited and saved in EPM Workspace. You must have administrator or designer rights to create a book.
When previewing a book in the EPM Workspace it can be viewed in HTML or PDF format, where an Interactive table of contents is displayed and the books document can be launched. In addition, the book can be previewed as “Complete Book in PDF’, where all of the book content is compiled into one PDF file, with a table of contents. A book can include reports, snapshot reports, and third party documents (Adobe Portable Document Format files (PDF), text (.txt) files, and Microsoft Office Excel, PowerPoint and Word files). Third party documents are listed in the table of contents and can be launched in the same manner as Financial Reporting documents. They are also included in a PDF file, when opening a Book as “Complete Book in a File”.
Note: | In order for a Microsoft Office document to be converted to PDF format in “Complete Book in PDF”, the version of the document must be the same as the version of MIcrosoft Office installed on the print server. |
When generating book output through the batch scheduler, books can be generated in PDF output or for static HTML Web site output. The HTML Web site supports built-in search capability as well as the ability to use templates for layout and page customization. See the topic “Managing Book HTML Output Layout” in the Oracle Hyperion Financial Reporting Workspace Administrator's Guide.
Book output has the following features for PDF and HTML (unless specified otherwise):
Ability to define a book with sections and subsections with a table of contents
HTML only: Ability to use templates for layout and page customization. See the topic “Managing Book HTML Output Layout in the Oracle Hyperion Financial Reporting Workspace Administrator's Guide .
In a Microsoft Word document, ability to insert Financial Reporting reports using the FRExecute function. See FRExecute Syntax.
In a Microsoft Word document, ability to insert links to report or any files located in the repository and third party documents through Oracle Universal Content Management using Microsoft Word's Hyperlink option. See Creating Hyperlinks in Microsoft Word.
Ability to add third party documents to books through Oracle Universal Content Management and Oracle BI EE.
Note: | Book search works fine for special characters except in text surrounded by “< >”characters such as “<123>.” In this instance, you can search for separately for character “<”, or “>”, or “123”. |
A book can include:
Financial Reporting documents, both dynamic and snapshot reports.
Third party documents
Microsoft Word - can include
embedded Financial Reporting reports using a the FRExecute function. See FRExecute Syntax for information.
Smart View queries
Microsoft Excel
Microsoft PowerPoint
Adobe Portable Document Format files (PDF)
text (.txt) documents
URL links. URLs can be copied from a browser, or Oracle Business Intelligence Enterprise Edition and Oracle Universal Content Management servers:
Heading text
Related Content in Financial Reporting reports can be included in book output. For Related Content features, see the Oracle® Hyperion Financial Reporting Studio, Fusion Edition User's Guide. For Related Contend behavior in books, see Behavior of Related Content in Books.
With the exception of URLs in the above list, the files must reside in the repository in order to select them for a book. Third party documents (Microsoft and PDF files) are listed in the table of contents and can be launched in the same manner as Financial Reporting documents. They are also included in a PDF file, when opening a Book as “Complete Book in a File”.
Note: | When you save a book as a snapshot book, expansions are removed. Related Content links are available. |
When adding a report to a book, the report may contain prompts for member selection. Prompts are defined when the book is run. Also when adding a report to a book, dimensions from the book POV can be set to multiple members. When the book is run, the report iterates over each member. For example, if North, South, East, West, Actual, and Budget are selected, the book contains six versions of this report. You can collate the printed output by member selection if the same member selections are used for all reports in the book. This enables, for example, all the reports for East, Budget to be grouped.
You can copy report member selections between reports if they use the same data source. This eliminates having to select shared members multiple times.
Using Microsoft Word Documents in Books
Microsoft Word document can use all the formatting features included in the Word product.
Customizing the Table of Contents
A table of content, with headings and subheadings as in a tree structure, is created for the documents compiled in the book. You can add additional content within this hierarchy, move or delete content, and format the layout. You can change the heading structure by increasing or decreasing the indent. You can copy member selections to other reports in the book.
A table of contents is created for the book. You can collate the reports within the printed table of contents by report or by member selection. For example, you can create the following two books:
Book 1 Balance Sheet (New York, Boston), (Q1, Q2) Cash Flows (New York, Boston), (Q1, Q2)
Book 2 Balance Sheet (Actual, Budget), (Q1, Q2) Cash Flows (New York, Boston), (Q1, Q2)
If you collate reports in printed books by report, The first report for each set of member selections is run, then the second report for each set of member selections is run. The following book is generated:
Book1 Table of Contents
Balance Sheet
New York, Q1
New York, Q2
Boston, Q1
Boston, Q2
Cash Flows
New York, Q1
New York, Q2
Boston, Q1
Boston, Q2
If you collate reports in printed books by member selections, each report for the member selection is run. The following book is created:
Book1 Table of Contents
Balance Sheet
New York, Q1
Cash Flows
New York, Q1
Balance Sheet
New York, Q2
Cash Flows
New York, Q2
Balance Sheet
Boston, Q1
Cash Flows
Boston, Q1
Balance Sheet
Boston, Q2
Cash Flows
Boston, Q2
Select File, then New, then Document. The 1. Select a Task wizard is displayed in the Content area.
In Step 2: Select Files, select reports and other artifacts from folders, then click
.Tip:
Press the Shift key to select multiple consecutive reports. Press the Ctrl key to select multiple non-consecutive reports.
Optional: To remove a report from the book, select the report, then click
. To remove all reports from the book, click 
.Note:
If you move, delete, or rename a report or other artifacts in the repository, they are removed from the book the next time the book is opened. Those artifacts must be added again if you wish to include them in the book.
When completed, click Finish to open the Book Editor.
Note:
To display dimensions in the table of contents, select the dimension name in the Book Editor and select Display, and then Hide from the bottom panel
Optional: Add or change members selections for the book POV:
Optional: Copying report member selections from one report to another in the Book Editor:
Note:
Member selections are only copied between reports having the same dimensions on the User Point of View.
To save the book, select File, and then Save to save the Book with a file name and description.