Exam: 1Z0-200 - [7]

Daily Business Intelligence (DBI)

- Out-of-the-box reporting and analysis application that enables senior managers and executives to see relevant, accurate and timely information using self-service overview pages.
- DBI overview page is designed for a particular functional, management responsibility. Managers can drill down from the summarized information on each page to detailed reports or to specific transactions in underlying applications, e.g. the Profit and Loss page is designed for a profit centre manager. his page summarizes profit and loss information using the Revenue, Expenses and Operating margin KPIs.
- DBI architecture simplifies the reporting process and ensures the managers are looking the most accurate and up-to-date data.
- DBI only updates the data that has changes since the last refresh.

Overview Page: An overview page is designed to meet the needs of a particular responsibility.
Responsibilty: Is designed for a particular business function or user such as Expense Manager.
Region: A region is a unique set of information on a page.
5 types of regions in DBI are:
1. Table,
2. Graph,
3. Parameter,
4. KPI, and
5. Links
KPI: A KPI is a business metric used for reporting such as Revenue or Operating margin. Managers can use KPIs to compare and judge their performance.

* DBI setup steps need to be performed before using an overview page.
- DBI provides cross-enterprise functionality that is not available as part of standard Oracle reports.

Technical Componets of DBI-

1. Single Oracle Instance: DBI resides in a single instance, which is same as transactional instance. Which reduces the need for a separate maintenance and administration team and optimize reporting performance.
- Materialized views and incremental refresh capabilities enable DBI to summarize a large amount of data efficietly.

2. E-Business Suite Tables: Changes in E-Business suite tables are reflected in DBI whenever incremental request set is run.

3. Base Summary tables and Materialized Views: Used to store summarized DBI data thats serve as the source of the data on each page.

4. Metadata: Used to define the complex relationship between the dimensions, responsibilities, menus, request sets, KPIs, pages, and reports. Metadata is predefined and can not be modified.

5. Rendering technology: Used to render the pages based on the data that is defined in the base summaries, materialized views, and the metadata layer.

6. Request Set generator: Enables to create initial and incremental request sets for each page using the definitions in the metadata layer. The generated request sets include all of the concurrent programs that you need to load or refresh a page.

Common Dimensions:
- A dimension defines a hierarchical relationship between data. YOu can use dimesions to view data at different level of details.
- Dimensions can be either flat or recursive.
1. Flat Dimension: Can be hierarchical but does not display the hierarchy between items.
2, Recursive Hierarchy: Displays a hierarchy between items.
- Each page has a dimesion that is considered the primary dimension. It determines which values are compared in the KPI region.
- Common DBI dimensions are:
1. Currency Dimension
2. Organization Dimension
3. Item Dimension
4. Person Dimension
5. Sales Group Dimension
6. Operating Unit Dimension
7. Time Dimension
8. Inventory Organization Dimension

1. Currency Dimension: Flat dimension that allows to see financial data across all organization units in a common currency. This dimension is populated based on the currencies and daily exchange rates that are defined in Oracle General Ledger.

2. Organization Dimension: Flat dimension that defines the hierarchical relationship between organizations in an enterprise.


Anonymous said...

Very good post! We will be linking to this great post on our site.
Keep up the good writing.

my page - Diaper Rash home Remedies

Anonymous said...

Hey there! Someone in my Myspace group shared this site with us so I came to give it a look.
I'm definitely enjoying the information. I'm book-marking and will be tweeting this to my followers!
Great blog and brilliant style and design.

Feel free to visit my web blog :: coconut oil for hair

Anonymous said...

Heya i am for the first time here. I came across this board and I in finding
It really helpful & it helped me out a lot. I am hoping to offer something again and help
others like you aided me.

Feel free to surf to my website: Eco Sanctuary

Anonymous said...

This paragraph will help the internet viewers for creating new weblog or even a blog from start to end.

my page :: Unknown

Anonymous said...

First off I want to say superb blog! I had a quick question that I'd like to ask if you do not mind. I was curious to know how you center yourself and clear your mind before writing. I have had trouble clearing my mind in getting my ideas out there. I do take pleasure in writing but it just seems like the first 10 to 15 minutes are usually wasted just trying to figure out how to begin. Any suggestions or hints? Thank you!

Feel free to surf to my web-site; world of tanks hack

Sridevi Koduru said...
This comment has been removed by the author.
Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.