When creating a Microsoft SQL Server database for use as a repository, ensure that you set these options:

• ALTER DATABASE DATABASE_NAME COLLATE SQL_Latin1_General_CP1_CI_AS

• Set READ_COMMITTED_SNAPSHOT = ON (Oracle Hyperion Financial Management requires READ_COMMITTED_SNAPSHOT = OFF).

• Set ALLOW_SNAPSHOT_ISOLATION = ON (Financial Management requires ALLOW_SNAPSHOT_ISOLATION = OFF).

• Select the SQL Server and Windows authentication option when you set the security properties for the database.

Oracle recommends that you add a prefix to the user name that will correspond to the RCU schema prefix used during configuration.

You must also create a database to be used with the Repository Creation Utility (RCU).

For the RCU database, run these queries:

• ALTER DATABASE DATABASE_NAME SET READ_COMMITTED_SNAPSHOT ON

• ALTER DATABASE DATABASE_NAME COLLATE LATIN1_GENERAL_CS_AS