Description
OBIEE repository consisting of each and every metadata of the BI Server and is overseen through the organization device. It is utilized to store about the application environment such as
- SQL Information
- Caching
- Data Modeling
- Aggregate Navigation
- Connectivity Information
- Caching
- Security
- Connectivity Information
Description
The Tools of Business Intelligence Administration are utilized to keep up Business Intelligence metadata storehouses. These tool will contributes a graphical portrayal of the 2-layers of the store:
In oracle BI Administration apparatuses will select metadata from database and other information sources to make the physical layer of the BI Administration archive. It adjust and rearrange the foreign made metadata into an arrangement of activities.Making these presentation layer from the plan of action, for presentation to clients that are process for the business knowledge data through Oracle BI repository.
OBIEE store database is otherwise called a RPD on account of its document augmentation. The RPD record is secret key secured and you can just open or make RPD documents utilizing Oracle BI Administration instrument. To send an OBIEE application, the RPD record must be transferred to Oracle Enterprise Manager. Subsequent to transferring the RPD, the RPD watchword then should be gone into Enterprise Manager.
- Business Model and Mapping Layer
- Physical Layer
Description
In this progression, you restart the Oracle BI Server administration to stack the bise1 store into memory, as takes after:
- Select Start - > Programs - > Administrative Tools - Component Services. Double tap Services.
- Restart the Oracle Business intelligence Server benefit.
- Check that the Oracle BI Presentation Server and Oracle Business Intelligence Java Host administrations are begun. In the event that they are not began, begin them. The administrations can be begun in any request.
- Close the Component Services window.
Description
The accompanying steps describes how to create the layers in the application of physical layer.
The repositories in the physical layer consisting of data about the informational sources. To make the framework in the physical layer the client need to import metadata from databases and other data sources.
- Change the names in the physical layer if required.
- Create physical joins between the Dimension and Fact tables.
Description
It portrays the intelligent or plan of action of items and their mapping between the plan of action and Schema in the physical layer. It enhances the Physical Schema and maps the customer business essential to physical tables. The OBIEE system association instrument can comprise at least one plan of action articles. A plan of action question portrays the plan of action definitions and the mappings from lucid to physical tables for the plan of action.
Following are the accompanying steps for creating Mapping layer and Business Model in the repository −
- Create a models in the business
- Examine coherent columns
- Examine coherents joins
- Rename logical table objects manually
- Examine logical table sources
- Rename logical table objects using the rename wizard and deleting unnecessary logical objects
- Creating measures
Key points
- BI Repository - Consisting of all metadata of the BI server.
- Oracle BI Administration Tools - Is utilized for maintaining BI metadata repositories.
- Start Oracle BI Services - Restarting all the Oracle BI Server to load the bise1 repository.
- Physical layer - Describes how to create the layers in an applications.
- Business model and mapping models - Describes the mapping between the 2 layers.