Creating Applications

  To create applications:

  1. Access the FDM Logon page by launching the Web client or Workbench:

    • Web Client—Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Web Server Components > Web Logon.

    • Workbench—Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Workbench > Workbench Client.

  2. From Application, select <New Application>.

  3. Enter your FDM name and password.

  4. Click Logon (Web client) or OK (Workbench).

    The New Application dialog box is displayed. It features two tabs—General and Database .

  5. On the General tab, enter application information.

    You use the General tab to create the application name and description and to define where the application architecture is stored.

    • Name—The name can contain up to twenty alphanumeric characters. Do not use spaces. Underscores (_) are acceptable.

    • Description—Description of the application.

    • Path—Path to the new application. If users access the application through multiple Web and application servers, it is recommended to use the UNC naming convention to avoid problems with inconsistent drive letter mapping.

    When an application is created, a directory of the same name is created. The application name is added to the HyperionFDMApplications.xml file, which is stored in the FDM installation directory.

  6. Select the Database tab, and enter database information.

    You use the Database tab to define the properties of the RDBMS database that stores the FDM transaction data.

    • OLE DB Provider—The database used by FDM. The default database is SQLOLEDB. SQLNCLI (SQL Server 2005 Native Client) and Oracle are also supported. If SQLNCLI is used, Microsoft SQL Server 2005 Native Client is required on all FDM application servers, load balance servers, and any computer where FDM Workbench is installed.

    • Database Server—The location of the database used by FDM. This option is visible only when OLE DB Provider is set to SQLOLEDB or SQLNCLI.

    • Database Name—Typically, the same as the application name. This option is available only when OLE DB Provider is set to SQLOLEDB.

    • Service—The Oracle service used for connecting to the Oracle database. This option is available only when OLE DB Provider is set to ORAOLEDB.

    • Username—The database administrator user name, for example, the SQLOLEDB administrator user name.

    • Password—The database administrator password.

    • Options—An override of the default table space where the application is created. This option is available only when OLE DB Provider is set to ORAOLEDB.

  7. Click OK.

    Note:

    If override table spaces is not selected, all tablespaces default to Users. Use of the default can severely degrade performance. See the Financial Data Quality Management DBA Guide for detailed tuning instructions prior to creating the FDM application.