This article has been archived. It is offered "as is" and will no longer be updated.
When you publish a report as a form template in PerformancePoint Add-in for Excel, you receive the following error message:
Form submission failed: form template URL was not set for the application. Please contact your global administrator to correct the issue then retry submission.
This problem occurs because the location of the form templates is not specified.
To resolve this issue, follow these steps:
Open PerformancePoint Planning Administration Console. To do this, use one of the following methods:
Open a local Web browser.
In the address bar, type the URL of PerformancePoint Planning Administration Console, and then press ENTER.
Click Start, click Run, type inetmgr, and then click OK.
In the Internet Information Services (IIS) Manager window, expand ComputerName, expand Web Sites, right-click PPSPlanningAdminConsole, and then click Browse.
On the Connection page, specify the path of PerformancePoint Planning Server in the Location text box, and then click Connect.
On the Applications page, click the option button that is next to the application that you want to edit, and then click Edit.
On the Edit Application page, locate the Locations section.
In the Form templates location text box, specify the location for the form templates.
Note The location that you specify is the URL or URI for the network share or for the Microsoft SharePoint Products and Technologies Web site. Form templates are stored in this location.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem is most likely to occur if you create an application in PerformancePoint Planning Business Modeler. When you create an application in PerformancePoint Planning Business Modeler, the Create Application dialog box has no field that you can use to specify the locations for the following document types:
Assignment master forms
However, if you create an application in PerformancePoint Planning Administration Console, you can specify these document locations on the Edit Application page.
You may deploy Microsoft Office PerformancePoint Server 2007 on multiple servers. In this situation, if you are a member of the Global Administrator role, we recommend that you perform tasks that are related to the Global Administrator role in PerformancePoint Planning Administration Console. Therefore, potential database problems can be avoided.
To use PerformancePoint Planning Business Modeler, members of the Global Administrator role must also belong to other administrative roles.