![]() Bi Publisher Pdf TemplateCreating Excel Templates Browser version script Oracle Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher Release 11 g (11.1.1) Part Number E13881-02 Creating Excel Templates This chapter covers the following topics: • • • • • • • Introduction An Excel template is a report layout that you design in Microsoft Excel for retrieving and formatting your enterprise reporting data in Excel. Excel templates provide a set of special features for mapping data to worksheets and for performing additional processing to control how your data is output to Excel workbooks. Features of Excel Templates With Excel templates you can: • Define the structure for your 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 your data to manipulate it prior to rendering • Use native Excel functionality Limitations of Excel Templates The following are limitations of Excel templates: • For reports that split the data into multiple sheets, images are not supported. If the template sheet includes images, when the data is split into multiple sheets, the images will show only on the first sheet. • There is no tool to facilitate the markup of the template with BI Publisher tags; all tags must be manually coded. Some features require the use of XSL and XSL Transformation (XSLT) specifications Prerequisites Following are prerequisites for designing Excel templates: • Microsoft Excel 2003 or later.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |