%EPM_ORACLE_HOME%\products\hsf\cfg\DB

Subtopics

Table 36. ..\Hyperion\StrategicFinance\<release>\Server\DB

Subdirectories and Files

Contains

Oracle\New

Scripts for creating export databases in Oracle.

Oracle\Upgrade

Scripts for upgrading Alcar 6.x export databases in Oracle to Strategic Finance 3.x.

DB\SQL Server\New

Scripts for creating export databases in SQL Server.

DB\SQL Server\Upgrade

Scripts for upgrading existing Alcar 6.x export databases in SQL Server to Strategic Finance 3.x.

Oracle\New

Table 37. ..\DB\Oracle\New Scripts

File Name

Description

step1_tables_viewsql

Creates the base and ancillary Strategic Finance database schema, including: tables, sequences, indexes, and keys.

step2_defaultspcreate.sql

Creates defaults and substitution procedures.

step3_pkgcreate.sql

Contains package definitions and bodies for the base Strategic Finance database export and the customer interface table.

step4a_optional
auditcreate.sql

Creates an optional audit table for defaults and substitutions.

step4b_optional
audittrigger.sql

Creates an optional trigger for defaults and substitutions.

Oracle\Upgrade

This directory contains upgrade scripts.

SQL Server\New

Table 38. .SQL Server\New Scripts

File

Description

step1alt_remove_
objects.sql

Alternative to step_1. Removes objects for reinstallation.

step1_create_
alcar_database.sql

Creates the Strategic Finance SQL Server database as hsfsvr.

step2_security.sql

Sets up logins and permissions. The default are hsfsvr_user, password = null.

step3_tables_grants.
sql

Contains the base Strategic Finance database schema, including: tables, indexes, and keys with default grants.

step4_procs_funcs.sql

Contains stored procedures and functions.

SQL Server\Upgrade

This directory contains upgrade30.sql to upgrade Oracle staging databases from 6.x to Strategic Finance 3.x.