Daily Business Intelligence
- reporting and analysis framework mainly used by senior managers and executives to view relevant, accurateand timely information by using
a. overview pages
b. drill-to reports
- povides cross enterprise functionality by using E Busines Suite architecture.
- its a single, global, transactional database consisting of all product, customer and supplierinformation integrated to management reports for the E Busines Suite.
- DBI creates and updates summaries in the same database where transactions are stored. This avoids moving asubset of the transactions to a separate database to support offline analysis etc.
DBI Report Components
- Overview Pages
- Parameter
- Responsibility
- Region
- KPI
Parameter - each overview page consists of a set of parameters that we can use to change the data that is displayed on the overview page. Some parameters are common to all overview pages, whereas some are unique to each overviewpage.
Responsibility - is designed for a particular business functionality or user. Responsibilities are pre-seededand provide access to a particular overview page or a set of overview pages.
Region - is a container for a unique set of information on an overview page. There are five different regions:
a. Table
b. Graph
c. Parameter
d. KPI
e. Links
KPI - Key Performance Indicators. They are strategic business factors used for reporting. They are designed for comparing and judging performance on strategic business factors such as Revenue or Operating Margin. Eachoverview page consists of a set of KPIs that define the content of the overview page.
DBI Pages
- Pages provide summarized content about a particular functional area.
- Content of each page is unique, but the basic features are the same.
- Access to pages is provided by responsibilities.
- Pages contain the following features
- Parameters
- KPI
- Regions
DBI Parameters
Date - determines the start date for the data.
Period Type - determines the period.
Compare To - determines how we want to compare the data.
Primary Dimension - determines the value that are compared in the KPI region of the Page. There is only oneprimary dimension for each page.
Currency - We can use both primary and secondary currency.
DBI Reports
- Every table and graph region of a DBI Page is based on a report. We can drill down to the underlying reports byclicking the linked values and text in the regions.
a. Reports can have additional parameters and some of these may be dependent on one another.
b. Reports can display more data than a page.
c. Reports do not truncate data.
d. Report data can be exported to microsoft excel spread sheet or pdf file.
e. Report links can be personalised by the user.
