The Oracle Business Intelligence data model that is provided with Oracle Commerce Business Intelligence connects reporting analyses to the data warehouse database. It includes database connection information and it presents the data in the data warehouse to the Oracle Business Intelligence server in a manner that is more useful for creating reports.
To configure your data warehouse database connection information in the data model:
Make sure that you have installed and configured Oracle Commerce Platform including the reporting components for Oracle Commerce Business Intelligence. Make sure that you have the user account and connection information for the data warehouse database. See Installation Overview.
Run the Oracle Business Intelligence Administration tool.
If you have installed Oracle Business Intelligence on Microsoft Windows, choose the Administration tool from the Start menu options for Oracle Business Intelligence.
If you have installed Oracle Business Intelligence on another operating system, download and install the Oracle Business Intelligence Developer Client Tools on a Microsoft Windows computer. Download the Oracle Business Intelligence Developer Client Tools installer from the Oracle Business Intelligence download Web page (http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html).
Move a copy of the Oracle Commerce Business Intelligence data model repository file to a directory in which you can open and edit it with the administration tool. The repository file is provided in the Oracle Commerce Platform installation directory at the following location.
<ATG11dir>/ARF/DW/OracleBI/OracleBIServerComponent/repository/
ATG.rpdOpen the repository file in the Oracle Business Intelligence Administration tool. Enter the default password
Admin123.Open the properties dialog box for the physical layer of the model. Select View > Physical if it is not already selected. Select the physical layer (labeled ATGDW) and choose Edit > Properties.
Open the Connection Pool tab and double-click the ATGDW Connection Pool connection to edit it. Enter the connection information for your data warehouse database.
Click OK on all open dialog boxes. Save the model and check its consistency when prompted. Close the repository file. You will need this file when you deploy business intelligence content. See Deploying to the Oracle Business Intelligence Server.
Note: Improve the security of your installation by changing the data model repository file password.
Note: See comprehensive information about configuring repository files for Oracle Business Intelligence in the documentation for that product (http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/documentation/bi-ee-087853.html).
