Create

The Create tab enables you to run the database creation process that:

  • Creates the database.
  • Creates the data source.

By default, the data source is created with the End User Authentication option set to Database. If you want to use Integrated authentication, use the Create BOD database script only option. You can then modify the script to set up a user.

Option Description
Create BOD database and data source connection automatically Select this option to build the database and data source after you click Create.
Create BOD database script only Select this option to create a script for manual execution.
Database Server Type List of database server types. Choose Microsoft SQL Server or Oracle.
CPM Unit Members Choose the method to map source to the Unit dimension. Choose from:
  • Accounting entities. Select this option if the accounting entities referenced within the BODs correspond to the Unit dimension.
  • Accounting chart first dimension. Select this option to use the first dimension in the Accounting Chart as the Unit dimension.
BOD Database Name Specify the name for the database. This name is also used for the database owner user. This is the only user that is required for the BOD database.
BOD Database Password / Confirm Password Specify the password for the database owner.
Create SQL Script Click Create SQL Script to create a script. After the script is created, click Download to download the script to a location you select.

For Microsoft SQL Server, the script is named:

database name_BODCreate_SQLServer.sql

For Oracle, the script is named:

database nameBODCreate_Oracle.sql

The script does not create the data source. This button is enabled if you selected the Create BOD database script only option.

Host Oracle only. Name of the server computer on which the Oracle database is installed.
Service Name Oracle only. Name of the Oracle service.
Port Oracle only. Port number of the Oracle service.
TNS Service Name Oracle only. The TNS name. This name is required and must be set up in the tnsnames.ora file. The TNS name in the tnsnames.ora file includes the host name, service name, and port number for each TNS name.
Database Server SQL Server only. Name of the server computer on which the SQL Server database is installed.
Database Administrator User ID User ID to use when connecting to the database server. This user ID is used to create the database and must have database administration permissions.
Database Administrator User Password Password for the database administrator user ID.
Use default database directory Save the database files to the default directory for the database server.
Database Directory Directory name and path. This is where the database files are created. The path must be referenced in terms of the database server and the directory must be writable.
Test Connection Verifies the connection using the supplied details.
Data Source Name Specify a name for the data source. To facilitate setting up drill through to journal detail within CPM Workstation pages, the data source must be named PMSourceViews.
Create Click Create to build the database and the data source connection.