Create the staging database
This topic describes how you can create a staging database in either 계획 관리 콘솔 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 계획 관리 콘솔, or use 계획 명령 유틸리티. For more information, see Security roles.
The following procedures describe how to create a staging database in the 계획 관리 콘솔 and Planning Business Modeler respectively. To learn more about how to create an application, see the 계획 관리 콘솔 or the Planning Business Modeler documentation. To learn how to create a staging database using the 계획 명령 유틸리티 see Scriptable data integration.
To create a staging database in Planning Administration Console
Connect to the 계획 서버 system in the 계획 관리 콘솔.
Click the Applications link on the navigation panel.
Click Create. The Create an Application dialog box appears.
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.
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.
In the Application Database Name text box, type the name of the SQL Server application database that you want to create.
In the Staging Database Name text box, type the name of the SQL Server staging database you want to create.
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
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.
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.
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).
(Optional) In the Description text box, enter a description of the application. The description can be up to 512 characters.
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.
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.
(Optional) In the Root site description text box, enter a description of the root site. The description can be up to 512 characters.
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.