Create the staging database

PerformancePoint Server 2007

This topic describes how you can create a staging database in either 规划管理控制台 or 规划业务建模器 when you create your application.

You must be a member of the Global Administrator role to create a staging database in 规划业务建模器 or 规划管理控制台, or use 规划命令实用工具. For more information, see Security roles.

The following procedures describe how to create a staging database in the 规划管理控制台 and 规划业务建模器 respectively. To learn more about how to create an application, see the 规划管理控制台 or the 规划业务建模器 documentation. To learn how to create a staging database using the 规划命令实用工具 see Scriptable data integration.

To create a staging database in Planning Administration Console

  1. Connect to the 规划服务器 system in the 规划管理控制台.

  2. Click the Applications link on the navigation panel.

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

  4. Enter information in the Application name, Label, Root site name, and Root site label box that is appropriate for your new application. Refer to the PerformancePoint 规划管理控制台 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 规划管理控制台 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.

显示: