![peoplesoft bi publisher add-in for word 2016 peoplesoft bi publisher add-in for word 2016](http://d1dlalugb0z2hd.cloudfront.net/vpuml/tutorials/word_screenshots/05_create_class_diagram.png)
The package must exist on the default data source.ĭatabase Fetch Size - Sets the number of rows fetched at a time through the JDBC connection.Įnable Scalable Mode - processing large data sets requires the use of large amounts of RAM. For data models that include event triggers or a PL/SQL group filter, you must enter a default PL/SQL package here.
![peoplesoft bi publisher add-in for word 2016 peoplesoft bi publisher add-in for word 2016](https://mani2web.files.wordpress.com/2014/05/10.png)
Event triggers make use of PL/SQL packages to execute RDBMS level functions. Oracle DB Default Package - If you define a query against an Oracle database, then you can include before or after data triggers (event triggers) in your data model. The default data source you select here is presented as the default for each new data set you define Data models can include multiple data sets from one or more data sources. Selecting a component on the left pane launches the appropriate fields for the component in the work area.Įnter the following properties for the data model:ĭescription: Description about the Data Model.ĭefault Data Source - Select the data source from the list. The Data Model Editor is designed with a component pane on the left and work pane on the right.
![peoplesoft bi publisher add-in for word 2016 peoplesoft bi publisher add-in for word 2016](https://reader020.staticloud.net/reader020/html5/20190802/589da6e71a28abe5498bd5b8/bg1.png)
Microsoft Excel spreadsheet data sources.SQL queries submitted against Oracle BI Server, an Oracle database, or other supported databases.Transform data - Modify source data to conform to business terms and reporting requirements.Ĭreate calculations - Compute data values that are required for your report that are notavailable in the underlying data sources. Link data - Define master-detail links between data sets to build a hierarchical data model.Īggregate data - Create group level totals and subtotals. A single bursting definition provides the instructions for splitting the report data, generating the document, and delivering the output to its specified destinations. The data model editorsupports several parameter types.īursting is a process of splitting data into blocks, generating documents for each data block, and delivering the documents to one or more destinations. The data model editor supports retrieving data from flexfield structures defined in your Oracle Application database tables.Ī list of values is a menu of values from which report consumers can select parameter values to pass to the report.Ī parameter is a variable whose value can be set at runtime.
![peoplesoft bi publisher add-in for word 2016 peoplesoft bi publisher add-in for word 2016](http://1.bp.blogspot.com/-OhU4AnQweOI/WcTYKCuCTjI/AAAAAAAAPv0/9H79nK_dasURbKasHa2mOgtaWAw5LpcuACK4BGAYYCw/s1600/image002-714929.png)
The data model editor supports before data and after data triggers.Event triggers consist of a call to execute a set of functions defined in a PL/SQL package stored in an Oracle database.Ī flexfield is a structure specific to Oracle Applications. When the event occurs the trigger runs the PL/SQL code associated with it. Adata model can have multiple data sets from multiple sources.Ī trigger checks for an event. A data set can retrieve data from a variety of data sources (for example, a database, an existing data file,a Web service call to another application, or a URL/URI to an external data provider). To build a data model, you use the data model editor.Ī data set contains the logic to retrieve data from a single data source.It can transform the data during the Extraction process using Formula columns, Summary columns.It extracts the data from single or multiple sources.Data models reside as separate objects in the catalog.Datamodel is BI Publisher Report Component, which contain a set of instructions to retrieve the structured data to generate BI Publisher Report.