Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Metadata for Analytics Applications >

Updating Finance Analytics Logical Table Sources

In the Oracle BI repository file, logical table sources are set by default to settings in Oracle's Finance Analytics family of products (Finance Sales Analytics, Finance Service Analytics, Finance Marketing Analytics, Finance Institutional Analytics, Finance Retail Analytics), the Healthcare Analytics family of products (Oracle Healthcare Sales Analytics, Oracle Healthcare Service Analytics, Oracle Healthcare Marketing Analytics, Oracle Healthcare Partner Manager Analytics), and the Oracle Insurance Analytics family of products (Oracle Insurance Partner Manager Analytics, Oracle Insurance Sales Analytics, Oracle Insurance Service Analytics, Oracle Insurance Marketing Analytics, Oracle Insurance Partner Manager Analytics). Before using these Financial Services Analytics applications, you must update the logical sources for two tables in the Oracle Business Intelligence repository file. These logical sources must be deactivated in order for Oracle's Finance Analytics family of products (Finance Sales Analytics, Finance Service Analytics, Finance Marketing Analytics, Finance Institutional Analytics, Finance Retail Analytics), the Healthcare Analytics family of products (Oracle Healthcare Sales Analytics, Oracle Healthcare Service Analytics, Oracle Healthcare Marketing Analytics, Oracle Healthcare Partner Manager Analytics), and one of the Oracle Insurance Analytics family of products (Oracle Insurance Partner Manager Analytics, Oracle Insurance Sales Analytics, Oracle Insurance Service Analytics, Oracle Insurance Marketing Analytics, Oracle Insurance Partner Manager Analytics) reports to point to the correct logical model and retrieve the correct data. Do this by deactivating the sources for the Fact-Asset logical table in the Core subject area and activating the FINS logical sources, as shown in the following procedure.

NOTE:  Before performing the following procedure, shut down the Oracle BI Server.

To update Logical Table sources for Finance Analytics

1. Launch Oracle BI Administration Tool and open the Analytics Repository (OracleBIAnalyticsApps.rpd).

   Go to the Business Model and Mapping window (the logical layer window) and open the Core folder.

   Scroll down to the Fact - CRM - Asset logical table and open its Sources folder.

2. In the list of logical table sources, right-click Fact_ASSET_F_FINS.

   Select Properties.

3. Click the General tab in the Properties window and make sure that the Active check box is checked.

   If it is not, check it.

4. In the list of logical table sources, right-click W_ASSET_F.

   Select Properties.

5. Click the General tab in the Properties window.

   Make sure the Active check box is unchecked. If it is not, uncheck it.

   Click OK and save the repository.

6. Restart Oracle BI Server.