Catalogs >
Oracle >
Oracle Fusion Middleware

Oracle Fusion Middleware
556Pages

Catalog excerpts

Oracle® Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher 11g Release 1 (11.1.1) E22254-03 February 2013 Explains how to create a report and how to design report layouts using a variety of template types to display the data from an Oracle Business Intelligence Publisher data model. Includes how to create visualizations, set run-time properties, define subtemplates, and enable translations.

Open the catalog to page 1

Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher, 11g Release 1 (11.1.1) E22254-03 Copyright © 2010, 2013, Oracle and/or its affiliates. All rights reserved. Primary Author: Leslie Grumbach Studdard Contributing Author: Tim Dexter, Suzanne Gill Contributor: Oracle Business Intelligence Publisher development, product management, and quality assurance teams This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly...

Open the catalog to page 2

xxiii xxiv xxv xxvi Creating Reports and Layouts

Open the catalog to page 3

Translating Reports and Catalog Objects 17 Translating Catalog Objects, Data Models, and Templates 17.1 17.2 17.2.1 17.3 17.4 17.5 Part IV Reference Information

Open the catalog to page 18

B Extended Function Support in RTF Templates B.1 B.1.1 B.2 B.3

Open the catalog to page 19

D Supported XSL-FO Elements D.1 D.1.1

Open the catalog to page 20

Preface Oracle Business Intelligence Publisher (BI Publisher) is a reporting and publishing application that enables you to extract data from multiple data sources, create layouts for report data, and publish the report to numerous output formats. BI Publisher also enables you to schedule reports and deliver the reports to multiple delivery destinations required by your business. Audience This document is intended for report designers and developers using Oracle Business Intelligence Publisher to create reports, configure reports, add translations, and use other BI Publisher report design...

Open the catalog to page 21

Access to Oracle Support Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired. Related Documentation and Other Resources See the Oracle Business Intelligence documentation library for a list of related Oracle Business Intelligence documents. In addition, go to the Oracle Learning Library for Oracle Business Intelligence-related online training resources. System Requirements and Certification Refer to...

Open the catalog to page 22

New Features for Report Designers This preface describes changes to Oracle BI Publisher report designing features for Oracle Business Intelligence Publisher 11g Release 1 (11.1.1). This preface contains the following topics: ■ New Features for Oracle BI Publisher 11g Release (11.1.1.7) New Features for Oracle BI Publisher 11g Release 1 (11.1.1.6) New Features for Oracle BI Publisher 11g Release 1 (11.1.1.5) New Features for Oracle BI Publisher 11g Release 1 (11.1.1.3) New Features for Oracle BI Publisher 11g Release (11.1.1.7) New features for report designers in Oracle BI Publisher 11g...

Open the catalog to page 23

Time series axis formatting Hide axis option Independent axis formatting For more information about these, see Section 3.9.4, "Using Advanced Chart Features." Enhanced Create Report Guide The Create Report guide is enhanced to assist report designers with the process of creating a report from selecting the data model to configuring the report layout. For more information, see Section 2.3, "Creating Reports." PDF to PCL Conversion for Embedding PCL Commands in RTF Templates BI Publisher now provides a PDF to PCL converter. Using this utility, you can embed PCL commands in an RTF template...

Open the catalog to page 24

Previously the report viewer always displayed the parameters in a horizontal region across the top of the viewer. In this release. the display of the parameter region can also be configured in one of the following ways: – – In a vertical region along the right side of the viewer As a separate full page New report viewer toolbar button to show or hide parameters This release adds a toolbar button to the report viewer to enable users to hide or show the parameter region. This enhancement complements the new parameter display options. When report parameters are configured to display as a...

Open the catalog to page 25

Define the structure for the data in Excel output Split hierarchical data across multiple sheets and dynamically name the sheets Create sheets of data that have master-detail relationships Use native XSL functions in the data to manipulate it prior to rendering Use native Excel functionality For more information, see Chapter 6, "Creating Excel Templates." Excel Template Builder BI Publisher provides a downloadable add-in to Excel that enables you to preview the Excel template with sample data. This facilitates design by enabling you to test and edit the template without having to upload it...

Open the catalog to page 26

Shared BI Presentation Catalog For installations of BI Publisher with the Oracle BI Enterprise Edition, BI Publisher now shares the same catalog with Oracle BI Presentation services. For information about the improved catalog, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Publisher. Layout Editor Design Tool This release introduces a new type of layout template and design tool. The Layout Editor is launched from within BI Publisher and provides an intuitive WYSIWIG drag-and-drop interface for designing report layouts. For a complete description, see Chapter 3,...

Open the catalog to page 27

Creating Reports and Layouts This part describes how to create reports and layouts. It includes the following chapters: ■ Chapter 1, "Introduction to Designing Reports" Chapter 2, "Creating and Editing Reports" Chapter 3, "Creating BI Publisher Layout Templates" Chapter 4, "Creating RTF Templates" Chapter 5, "Creating RTF Templates Using the Template Builder for Word" Chapter 6, "Creating Excel Templates" Chapter 7, "Creating PDF Templates" Chapter 8, "Creating eText Templates" Chapter 9, "Creating Flash Templates" Chapter 10, "Setting Report Processing and Output Document Properties"

Open the catalog to page 29