Upload a Microsoft Excel file (file type.xls or. Select an existing data model from the catalog.Ĭlick Next to proceed to Choosing Guide Me or Use Report Editor. See Chapter 15, "Translation Support Overview and Concepts."Ĭhoose one of the following options to begin building your report: Complete this step if the report requires support for multiple languages. See Section 2.9, "Configuring Report Properties."Īdd translations for the layouts. See Section 2.8, "Configuring Parameter Settings for the Report." See Section 2.7, "Configuring Layouts Using the List View." See Section 2.6, "Adding Layouts to the Report Definition." You can create a simple layout using the guide or add the layout later.Įdit the simple report layout that you created using the Create Report guide, or create a new layout. Launch the Create Report guide to select a data source, and create a basic report. The Create Report process guides you through the following steps: After creating the basic report, use the report editor to configure the report and create additional layouts. The Create Report process guides you through the steps to create a basic report. For more information about report components, see the sections that are listed in the following table. This chapter describes the process of creating a report by selecting a data model, adding a layout, and configuring properties using the report editor. BI Publisher's translation support enables you to include translations for individual layouts or for all translatable strings in the layout, data model, and the report metadata. Optionally, add translations for the report. The report properties enable you to control many aspects of the report generation, formatting, and display. Next, configure properties for the report. BI Publisher supports templates created from a variety of sources including Microsoft Word, Adobe Acrobat, Microsoft Excel, Adobe Flash, and BI Publisher's own layout editor. A layout consists of a template file and a set of properties for rendering the template file. The layout defines how the data is presented in the report. The next step is to design a layout for the report data. For more information, see Section 2.4, "Creating Reports Using a Direct Connection to a Subject Area." Reports that use Oracle Business Intelligence Subject Areas as the data source do not require a separate data model. For information on creating a data model, see Oracle Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher. It may also contain parameters with lists of values, bursting definitions and other structures or properties that determine how data is provided to a report. A Data Model may contain multiple data sets and it defines how data fields are structured in relation to each other. A Data Model defines data that is used by a report. The first step in creating a new report is to select the source of the data for the report. A report typically consists of the following components: