Running the Configuration Utility

  To run the Configuration Utility:

1. Ensure that you can connect to the BI Admin Server and Financial Management Client, and verify the server details.

2. In the Oracle BI EE Administration Tool, open the RPD, and change the default repository password before running the Configuration Utility. By default, the password for the shipped repository is welcome1.

   You require the correct RPD password to upload the repository during configuration, but you cannot change the password when running the Configuration Utility.

3. From the main menu, select Start, then All Programs, then Oracle Financial Management Analytics, and then Configuration Utility.

   

4. In Catalog Location under Catalog and Repository Details, click the Browse icon to display the Select Catalog Location dialog box.

5. Select the FinancialManagementAnalytics catalog folder that contains the definitions of the available dashboard graphs in which you will configure the custom Financial Management or Financial Close Management application, and then click OK.

   By default, the catalog is located in <OFMA Installed Location>\OFMAHome_1\OFMA.

   

6. In Repository Location under Catalog and Repository Details, click the Browse icon to display the Select RPD File dialog box.

   By default, the repository is located in <Installed Location>\OFMAHome_1\OFMA.

   

7. Select the repository (RPD) file (FinancialManagementAnalytics.rpd), and then click OK.

   

8. Under BI Admin Server Details, complete these fields:

   • In Host Name, enter the Admin server name where Oracle BI EE is installed and running.

   • In Port, enter the port number.

   • In User Name, enter the Administrator user name for the Admin server.

   • In Password, enter the Administrator password for the Admin server.

9. Under HFM Server Details, enter the following details for the selected Financial Management source:

   • Enter the name of the cluster or Server Name on which the Financial Management application resides.

   • Enter the Application Name of the Financial Management application that you will be using with Oracle Financial Management Analytics.

   • Enter the User Name and Password associated with the Financial Management application. This user requires the appropriate rights and roles to access Financial Management data.

10. Click Next.

    The Configuration Utility connects to the Financial Management application for which you have provided details and extracts metadata information only, based on the user's credentials. No data is extracted. This information is used to configure the dashboards in the next several steps.

    Note:

    For returning users, if the application name is the same, the original defaults are retained. Modify defaults as required.

    • If you receive an error message stating that the server is unavailable, perform the following steps:

      1. Check the last line in the OFMA.log to determine the exact cause of the error.

      2. Check the status of the Financial Management or Oracle BI EE server to verify that you are logged in and the server is up and running. If you are connecting to a cluster, ensure all servers in the cluster are up and running independently.

      3. Check that Shared Services is up and running.

      4. For each server, select Start, then Programs, then Administrative Tools, and then Services.

      5. Verify the connection details to the server or cluster, including machine name, port number and login credentials.

      6. Modify the Admin or HFM Server Details, if required.

      7. Retry step 9.

11. On the Entity Dimension screen, select the regional entities to be displayed on the dashboards, using the following steps:

    1. Click Expand All to view the entire list of entities under Entity Hierarchy.

       

    2. Under HFM Entity Dimension, select the regional entities to be displayed on the dashboards, and use the arrow buttons to move them to the Regions column.

       Dashboard	Reports or Elements
       Balance Sheet	Point of View Selector regions
       Cash Flow	Point of View Selector regions
       Executive	Income by Regions Gross Profit By Product By Region Profit and Loss Indicators By Products Net Cash Flow
       Gross Profit	Point of View Selector regions
       Performance Indicators	Point of View Selector regions
       Profit and Loss	Point of View Selector regions

    3. Click Next.

12. On the Accounts Dimension screen, select the nine account types to be displayed on the dashboards, using the following steps:

    1. Under Account Group, select an account group, such as Balance Sheet Accounts, Income Accounts, or Performance Indicators Accounts.

       

    2. Click Expand All to view the entire list of accounts under Account Hierarchy.

    3. Under Account Hierarchy, select the accounts that you want to display for the selected Account Group, and use the arrow buttons to move them to the Accounts column. The accounts that you select are displayed when you view the dashboards in Oracle Financial Management Analytics.

       You must select at least one account for each Account Group, but you may select as many as you require.

       Note:

       For the Performance Indicator account group only, you must select at least four indicators. The configuration utility will not proceed until at least four are selected. If more than four Performance Indicator selections are made, the additional choices are not displayed on the pie charts on Performance Ratio graphs, although they are available on other reports in the Performance Indicator dashboard.

       The following dashboards and reports are affected by your Accounts selections:

       Account Group	Displayed on Dashboard	Displayed in Reports
       Balance Sheet Accounts	Balance Sheet Balance Sheet Currency Analysis	Balance Sheet Variance Analysis Balance Sheet Trend Analysis Consolidating Balance Sheet
       Balance Sheet Metrics Accounts	Balance Sheet	Balance Sheet Metrics
       Cash Flow Accounts	Cash Flow Cash Flow Currency Analysis	Summary Cash Flow Consolidating Cash Flow Cash Flow Variance Analysis
       Executive Dashboard - Cash Flow Accounts	Executive	Net Cash Flow
       Gross Profit Accounts	Gross Profit	Gross Profit By Product By Region Gross Profit Trend Analysis Gross Profit Variance Analysis
       	Executive	Gross Profit By Product By Region
       Income Accounts	Executive	Income by Region
       Performance Indicator Accounts	Performance indicators Note: If you are assigning accounts to the Performance Indicator account group, you must choose at least four accounts to ensure the dashboard reports contain sufficient data. If more than four performance indicators are selected, the additional choices will not be displayed on the pie charts of the Performance Indicator reports.	Performance Indicators Year-over-Year Key Performance Indicators Rolling Twelve
       Executive Dashboard - Profit and Loss Indicators Accounts	Executive	Profit and Loss Indicators By Products
       Profit and Loss Accounts	Profit and Loss Currency Analysis dashboard	Trend Profit and Loss Report Variance Analysis Summary Income Statement
       		Profit and Loss Currency Analysis Table Profit and Loss Currency Analysis Graph Balance Sheet Currency Analysis Table Cash Flow Currency Analysis Table
       	Schedule Period to Period Analysis	Schedule Summary for Financial Close Management
       	Workflow

    4. Repeat step a to step 12.c for each Account group on the drop-down list to assign accounts for every account group.

13. On the Performance Indicators screen, associate accounts with each of the four performance indicators, as outlined in the following steps:

    1. Select a performance indicator account from the drop-down list.

    2. Under Account Hierarchy, select the accounts to be associated with the performance indicator, and use the arrow buttons to move them to the Performance Ratio column.

       

    3. Repeat step a to step c for each performance indicator.

14. On the Product Dimension screen, select the products that are to be associated with each product dimension, as outlined in the following steps:

    1. From Select Product, select a custom dimension that has a Product hierarchy. These products are set in Financial Management.

       

    2. Select Expand All to view the entire hierarchy of the custom dimension member selected.

    3. From the Product Hierarchy, select the products that you require and use the arrow buttons to move them to the Products column. You can choose multiple products, or you may select [None]. The Product dimension and its member selection are required. The products that you choose are displayed when you view the dashboards in Oracle Financial Management Analytics.

       Caution!

       Product data in multiple dimensions is not supported by Oracle Financial Management Analytics.

       The following dashboards and reports are affected by your Products selections:

       Dashboard	Reports
       Executive	Gross Profit By Product By Region Profit and Loss Indicators By Products
       Gross Profit Dashboard	Gross Profit By Products

    4. Click Next.

15. On the Currency Constant Rate Dimension screen, select the custom dimension or Scenario to be used for the Currency Constant Rate dimension:

    1. From the Select Currency Rate drop-down list, select either a custom member or the Scenario dimension to be used as the currency constant rate dimension for the application.

    2. Optional: If a custom dimension was selected, complete the following steps:

       1. Click Expand All to display all members for the selected custom dimension.

       2. Select the members of the custom dimension that you want to display on the report.

       3. Under Custom Dimension Hierarchy, select the members of the custom dimension that you want to display on the report, and then use the arrow buttons to move the member to the Constant Rate column.

          

    3. Optional: If a Scenario dimension is selected, the Custom Dimension Hierarchy pane is disabled. You do not need to select any members.

       

    4. Click Next.

16. In Default Dimension Member, set the default Point of View (POV) for the dashboards, as outlined in the following steps:

    1. From the Default Dimension drop-down list, select a dimension.

       

    2. Click Expand All to view the entire list

    3. Under Dimension Hierarchy, select the default member for each POV dimension, and then use the arrow buttons to move the member to the Default Member column. Only one member is allowed in the Default Member column.

    4. Repeat step a to step c for each of the POV dimensions:

       • Scenario, for example, Actual, Plan, Forecast, Global, Budget

       • Year, for example, 2011

       • Period, for example, months, quarters, and so on

       • View, for example, YTD, QTD, Periodic

       • Entity, for example, a geographic region

       • Value, for example, the selected currency, such as USD.

    Note:

    You can rerun the Configuration Utility to change the default dimension members for the POV.

17. Click Next.

18. Complete the following information to enable connection between Financial Management and Oracle BI EE:

    • Check OPMN Changes for connecting to Hyperion Financial Management Data Source, and enter the full path to the opmn.xml file, or click the Browse icon to navigate to the location of the opmn.xml file.

      By default, the file is located at C:\obiee\instances\instance1\config\OPMN\opmn\opmn.xml. For returning users, this step is not required if the OPMN path was already set as it is a one-time process for a machine.

      

      Caution!

      As a best practice, Oracle recommends that you create a backup copy of the opmn.xml file in case you need to restore the file.

    • Check Upload Repository, to upload the new repository. Enter the RPD password and Confirm Password that you used to open the selected OFMA Repository (RPD).

      Note:

      For returning users, this step is not required if no changes have been made to the RPD file since the last configuration.

    • Check Upload Catalog to upload the Oracle Financial Management Analytics catalog to the BI Server.

    

19. Click Next.

    The Summary screen displays the selections that you have just made using the utility.

    

20. On the Summary screen, review the changes. If necessary, select Back to review and change the selections and entries that you have made on each screen of the Configuration Utility.

    Note:

    A list of all configuration settings is also available in the OFMA.log file. By default, the log file is located in C:\OFMAHome_1\OFMA.

21. After reviewing your selections, click Submit to apply the changes.

    When the configuration is submitted, the following actions are initiated:

    • The account, region, product, constant rate and dimension default selection are updated to the catalog (filters and report definitions)

    • If any of the following changes were selected during configuration, a lock is immediately acquired to the BI Server and the server is stopped:

      • If changes to opmn.xml is selected, the opmn.xml is edited to include the path to ADM drivers, Financial Management Client, and so on.

      • If upload repository is selected, the selected RPD file is loaded to the BI Server.

      • If upload catalog is selected, the selected catalog file is loaded to the BI Server.

    • The BI Services are restarted and the Configuration Utility exits.

    A confirmation dialog box advises when all changes have been successfully submitted. This operation will take a few minutes to complete.

22. Click OK to complete the configuration.

23. Complete the manual configuration steps. See Performing Manual Configuration Steps.