Setting Table of Contents Text

In the Book Editor, the information in the Display Text field shows the text for each artifact entry in the table of contents. The default text in the table of contents is the artifact name or, in the case of a member, the member name. For example, if the artifact in the book is a report, the report name is shown. If the artifact in the book is an external file (for example, a Microsoft Word document), the file name from the repository is shown.

A panel at the bottom of the Book Editor displays the default properties of the book and enables you to change an artifact's textual and processing settings for the table of contents. For example, you can change the selected artifact name to the artifact's to customized text, or you can choose to not display any text for the selected artifact. Other properties are read-only.

To set the table of contents text for an artifact:

  1. From Oracle Hyperion Enterprise Performance Management Workspace with the BI Catalog open, right-click a book, and then select Open In Editor.
  2. In the Book Editor, highlight an artifact and scroll to the bottom panel. You can edit the following:
    • Display—For members, the value is always Display. For reports, the following options are available:

      • Name—Artifact name
      • Description—Description as it exists in the repository
      • Custom Text—Custom text that you enter
      • Do Not Display—Do not display the text in the table of contents

      If you select Custom Text, the Display Text field is enabled so you can enter text.

      You can include a Value function in the Custom Text to insert a member label of a dimension as follows:

      <<value(dimension-name)>>

      For example: <<Value(Product)>> or <<Value(Year)>>

      Using the Value function, you can create a cleaner, more streamlined table of contents. For example, the book can contain two reports that are run for the children of Qtr1. In Custom Text, you can include a <<Value(Year)>> function, and then hide the member selections.

      In the following example, “Period” and “Year” are added to the Profit & Loss and Balance Sheet reports:

      Profit and Loss for <<Value(Period)>> <<Value(Year)>> and Balance Sheet for <<Value(Period)>> <<Value(Year)>>

      This changes the appearance of the table of contents from this:

      Table of Contents before using the Value function

      to this:

      Table of Contents after using the Value function

    • Display Text—If you selected Name or Description in the Display field, the report name or report description is used for the display text. If you selected Custom Text in the Display field, then type the custom text.

    • Include Related Content in HTML Table of Contents—Available when you select a report in the Book Editor.

    • For processing behavior with FRExecute and hyperlinks, see Processing Behavior of Hyperlinks and FRExecute.

    • Member Selection—Available when you select a member in the Book Editor. To change the member for the Point of View, click the entry field to display the Preview User Point of View dialog box, select a member, and then click OK.