• Article

Create the staging database

This topic describes how you can create a staging database in either Planning Administration Console or Planning Business Modeler when you create your application.

You must be a member of the Global Administrator role to create a staging database in Planning Business Modeler or Planning Administration Console, or use Planning Command Utility. For more information, see Security roles.

The following procedures describe how to create a staging database in the Planning Administration Console and Planning Business Modeler respectively. To learn more about how to create an application, see the Planning Administration Console or the Planning Business Modeler documentation. To learn how to create a staging database using the Planning Command Utility see Scriptable data integration.

To create a staging database in Planning Administration Console

  1. Connect to the Planning Server system in the Planning Administration Console.

  2. Click the Applications link on the navigation panel.

  3. Click Create. The Create an Application dialog box appears.

  4. Enter information in the Applicationname, Label, Root site name, and Root site label box that is appropriate for your new application. Refer to the PerformancePoint Planning Administration Console documentation for more information.

  5. In the SQL Server name text box, type the name of the server that is running Microsoft SQL Server 2005 and that contains the application database.

  6. In the Application Database Name text box, type the name of the SQL Server application database that you want to create.

  7. In the Staging Database Name text box, type the name of the SQL Server staging database you want to create.

  8. Enter the rest of information and click OK.

    After you click OK, the Planning Administration Console creates the staging database on the application server. This database resides on the server that contains the application database.

To create a staging database in Planning Business Modeler

  1. Open the Create Application dialog box.

    • If you do not have a model site open   On the File menu, click Create Application.

    • If you already have a model site open   In the Workspace Browser click Site Summary and then click Create Application in the Site Tasks pane.

    The Create Application dialog box is displayed.

  2. In the Name text box, enter a name for the new application. The name must be from 1 to 256 alphanumeric characters, and is case sensitive. Punctuation and special characters are not permitted.

  3. In the Label text box, enter a unique label for the new application. The label must be unique to the individual application in the object of the application (in other words, the folder).

  4. (Optional) In the Description text box, enter a description of the application. The description can be up to 512 characters.

  5. In the Root site name text box, enter a name for the root site. The name must be from one to 256 alphanumeric characters, and is case sensitive. Spaces, punctuation, and special characters are not permitted.

  6. In the Root site label text box, enter a unique root site label. Unlike the root site name, the label must be unique in the object of the application. The label must be from one to 40 alphanumeric characters, must begin with a letter, and is case sensitive. Spaces, punctuation, and special characters are not permitted.

  7. (Optional) In the Root site description text box, enter a description of the root site. The description can be up to 512 characters.

  8. Click OK.

The staging database is created for you in Microsoft SQL Server 2005 with a name in the format of <application_name>_StagingDB. An error message appears if a staging database that has the same name as one that is already in the database that you are using.