Hierarchy

A Hierarchy is set of parent-child relationship between certain attributes of a dimension. 

An example gives you a clear idea what an hierarchy is

To know about Ragged and Skipped hierarchies check this
http://prashanthobiee.blogspot.in/2013/01/ragged-and-skipped-hierarchy.html

OBIEE Architecture

OBIEE Architecture and how it works for easy understanding

For Beginners this would give you a clear idea how OBIEE works

A request is made by the Users through Answers and sent to the Presentation server. The Presentation Server converts the request into logical SQL and sent to the BI server. The BI server converts logical SQL into physical SQL and sent it to the database. The result get back to the user through the same path 

Source Qualifier Transformation

Explain about Source Qualifier transformation

Source Qualifier transformation is an active transformation which read or extract the data from the database and flat files

SQ can be used to

• Join tables from same data sources
• filter the rows when the Integration service (it adds a WHERE clause to the query) reads the data from the data source
• specify the sorted ports. The Integration service adds a ORDER BY clause to the query with sorted ports
• select distinct values from the source. the Integration service adds a SELECT DISTINCT clause to the query 

SQL override: It is a process of changing the default SQL generated by Source Qualifier transformation

Source Filter: If the source is a database the Informatica recommends to use source filter condition rather than using filter transformation. It improves performance of data extraction

Available Oracle BI Apps

The following are currently available with Oracle BI Apps ERP Analytics  - Oracle Financial Analytics - Oracle Procurement and Spend Analytics - Oracle Human Resources Analytics - Oracle Supply Chain and Order Management Analytics - Oracle Spend Classification Analytics - Oracle Project Analytics CRM Analytics - Oracle Sales Analytics - Oracle Service Analytics - Oracle Marketing Analytics - Oracle Contact Center Analytics - Oracle Loyalty Analytics - Oracle Price Analytics Industry Applications - Oracle US Federal Financial Analytics

Components of Oracle BI Apps

Components of Oracle BI Apps

The main components of Oracle BI Apps are:

1. ETL tool Informatica or ODI (SDE, SIL and PLP)
2. DAC repository
3. OBAW (pre-built)
4. RPD
5. Web Catalog

OBIA

OBIA stands for Oracle Business Intelligence Apps. OBIA is a pre-built end to end BI Application. It consists of pre-built mappings, repository, reports, Dashboards, etc
Current version of OBIA is 7.9.6.3 and is compatible with Informatica 9.x, DAC 10g and OBIEE 11g

OBIA has pre-built adapters for Oracle Apps(EBS), JDEdwards, Siebel and Peoplesoft. In additional to these pre-built adapters Oracle provides the Universal adapters that enable any other source system to be a source for the Datawarehouse.

MUDE

Explain about MUDE

MUDE  (Multi-user development environment) is used for multi-user development of the repository. 

Create a shared directory on the network for Multi-user Development (MUD).
Open the RPD to use in MUD. From Tools->Options, setup the MUD directory to point to the above directory.
Define projects within the RPD to allow multiple users to develop within their subject area or Facts.
Save and move the RPD to the shared directory setup in point 1.
When users work in the MUD mode, they open the admin tool and start with
MUD ->Checkout to check out the project they need to work on (not use the File open as you would usually do).
After completely the development, user checking the changes back to the network and merge the changes.