You are here: BI Publisher BI Publisher for beginners : Introduction to Data Model

BI Publisher for beginners : Introduction to Data Model

Rate this item
(3 votes)

Data model is BI Publisher Report Component, which contain a set of instructions to retrieve the structured data to generate B Report. Data models reside as separate objects in the catalog. It extracts the data from single or multiple sources. It can transform the data during the Extraction process using Formula columns, Summary columns. To build a data model, you use the data model editor.

Components of a Data Model

•    Data set

A data set contains the logic to retrieve data from a single data source. 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). A data model can have multiple data sets from multiple sources.

•    Event triggers

A trigger checks for an event. When the event occurs the trigger runs the PL/SQL code associated with it. 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.

•    Flexfields

A flexfield is a structure specific to Oracle Applications. The data model editor supports retrieving data from flexfield structures defined in your Oracle Application database tables.

•    Lists of values

A list of values is a menu of values from which report consumers can select parameter values to pass to the report.

•    Parameters

A parameter is a variable whose value can be set at runtime. The data model editor supports several parameter types.

•    Bursting Definitions

Bursting is a process of splitting data into blocks, generating documents for each data block, and delivering the documents to one or more destinations. A single bursting definition provides the instructions for splitting the report data, generating the document, and delivering the output to its specified destinations.

Features of the Data Model Editor

•    Link data — Define master-detail links between data sets to build a hierarchical data model.

    Aggregate data — Create group level totals and subtotals.

•    Transform data — Modify source data to conform to business terms and reporting requirements.

•    Create calculations — Compute data values that are required for your report that are not available in the underlying data sources.

Data Source Options

  • SQL queries submitted against Oracle BI Server, an Oracle database, or other supported databases
  • Microsoft Excel spreadsheet data sources
  • Multidimensional (MDX) queries against an OLAP data source
  • Oracle BI Analyses
  • Existing XML data files
  • View objects created using Oracle Application Development Framework (ADF)
  • HTTP XML feeds off the Web


Please stay tune for the next article on this series, 'Working with Data Model Editor'.

Till then, Happy reading.

This article is part of BI Publisher for beginners series. You will see many more articles on Data Model design, Template desing, Administration, Web Services, Scheduler. The contents are picked-up from BI Publisher Training documents from  Adiva consulting. If you have any question regarding these articles or training program, please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Read 7907 times

Leave a comment

Make sure you enter the (*) required information where indicated.
Basic HTML code is allowed.