Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Report (DBI)

DBI Report

A DBI report is a summarized or transactional view of data in graph and table format.

From Oracle Daily Business Intelligence Implementation Guide R11i

In DBI, a report is actually a container.  It contains the following components:

  • Report parameters
  • A table region: A report can only have one table.
  • Multiple graph regions (typically three graph regions per report)
  • A link region: Report links can be personalized by the user.

DBI design process is started with creating report.  Once a report is created, you then create measures, and then create dashboards.

Reports are similar to pages and regions, but have the following differences:

  • Reports can have additional parameters (View By parameters), and some of these parameters may be dependant on one another. For example, in the Purchasing Savings report, the Customer and Category report parameters are dependant on the Operating Unit parameter. You must select a value in the Operating Unit parameter before you can select a value in the Customer or Category parameters.
  • Reports with additional View By parameters enable you to drill and pivot on the values in the first column, so you can to view the value by any other dimension, except for time.
  • Reports can display more rows and columns of data than a page.
  • Reports do not truncate data
  • Report data can be exported to a Microsoft Excel spreadsheet or to a PDF file.
  • Report links can be personalized by the user.

It is important to note that the reports in Daily Business Intelligence are not standard Oracle reports; instead, they are special reports that were developed using Oracle Performance Management Viewer (PMV). PMV is a foundation technology component for Daily Business Intelligence that defines and renders reports.