PerformancePoint Planning CTP2 comes with a sample application which is a fictitious multinational corporation called Alpine Ski House. In order to install the sample application you will need the following files which are available on the connect site:
- PPLSASHSampAppInst.chm (Install Guide)
- PPPSampleAppGde CTP2.doc (Walkthrough of the application)
- PPS_Core_Questionnaire_Alpine_Ski_House.doc (Requirments gathering/Design doc)
- PLSample.msi (Install/Config files)
I recommend reading through the PPLSASHSampAppInst.chm document before installing the sample application (PLSample.msi). PLSample.msi does not fully install it. It copies the necessary configuration files, database files and install scripts to:
%ProgramFiles%\Microsoft Office PerformancePoint Server\2007\Samples\Alpine Ski House
First, confirm that the DeploymentPaths.xml configuration file is set up properly. This file provides the location of osql.exe and ppscmd.exe. The file is located at
%ProgramFiles%\Microsoft Office PerformancePoint Server\2007\Samples\Scripts
<DeploymentPaths>
<Parameter Name="OSQL" Type="Path">"%ProgramFiles%\Microsoft SQL Server\90\Tools\binn\osql.exe"</Parameter>
<Parameter Name="PPSCMD" Type="Alias">"%ProgramFiles%\Microsoft Office PerformancePoint Server\2007\BizModeler\PPSCmd.exe"</Parameter>
</DeploymentPaths>
Next, set up the DeploymentConfig.xml which is located at:
%ProgramFiles%\Microsoft Office PerformancePoint Server\2007\Samples\Alpine Ski House
Below is an example of the DeploymentConfig.xml. This config file is for a standalone install of PerformancePoint server. It could be used for a test or dev server. PerformancePoint Planning, SQL Server 2005 and the file shares are all on the same server. I also used the same user over and over again for the different roles. To make the sample application more realistic it would be a good idea to have more than one user on in the system.
DeploymentConfig>
<!-- Replace each instruction below with the information requested for each parameter. For information on how to use this file to install the Alpine Ski House sample application, refer to the Alpine Ski House Sample Application for Microsoft Office PerformancePoint Server 2007 document. -->
<!-- Servers and Services -->
<Parameter Name="DataSourceServer" Type="Server">whistler</Parameter>
<Parameter Name="DatasourceServerDataPath" Type="Uri">C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data</Parameter>
<Parameter Name="ReferenceDatabaseServer" Type="Server">whistler</Parameter>
<Parameter Name="AnalysisServicesServer" Type="Server">whistler</Parameter>
<Parameter Name="PerformancePointWebService" Type="Uri">http://localhost:46787</Parameter>
<!-- Storage Locations -->
<Parameter Name="FormTemplatesLocation" Type="Uri">\\whistler\Workflow\FormTemplates</Parameter>
<Parameter Name="ReportsLocation" Type="Uri">\\whistler\Workflow\Reports</Parameter>
<Parameter Name="AssignmentFormsLocation" Type="Uri">\\whistler\Workflow\FormAssignments</Parameter>
<Parameter Name="AssignmentMasterFormsLocation" Type="Uri">\\whistler\Workflow\FormMasterAssignments</Parameter>
<!-- Users -->
<Parameter Name="SystemAccount" Type="Account">WHISTLER\ppsplanning</Parameter>
<Parameter Name="SeniorAccountantAccount" Type="Account">WHISTLER\Administrator</Parameter>
<Parameter Name="SeniorAccountantAccountEmail" Type="Email">admin@whistler.com</Parameter>
<Parameter Name="BackOfficeAccount" Type="Account">WHISTLER\Administrator</Parameter>
<Parameter Name="BackOfficeAccountEmail" Type="Email">admin@whistler.com</Parameter>
<Parameter Name="SeniorAnalystAccount" Type="Account">WHISTLER\Administrator</Parameter>
<Parameter Name="SeniorAnalystAccountEmail" Type="Email">admin@whistler.com</Parameter>
<Parameter Name="CFOAccount" Type="Account">WHISTLER\Administrator</Parameter>
<Parameter Name="CFOAccountEmail" Type="Email">admin@whistler.com</Parameter>
<Parameter Name="HRManagerAccount" Type="Account">WHISTLER\Administrator</Parameter>
<Parameter Name="HRManagerAccountEmail" Type="Email">admin@whistler.com</Parameter>
<Parameter Name="ResortManagerAccount" Type="Account">WHISTLER\Administrator</Parameter>
<Parameter Name="ResortManagerAccountEmail" Type="Email">admin@whistler.com</Parameter>
<Parameter Name="ControllerAccount" Type="Account">WHISTLER\Administrator</Parameter>
<Parameter Name="ControllerAccountEmail" Type="Email">admin@whistler.com</Parameter>
</DeploymentConfig>
Once the config files are setup the application can be installed. Simply goto the command line and goto:
C:\Program Files\Microsoft Office PerformancePoint Server\2007\Samples\Alpine Ski House
Type install and sit back while the install scripts run
Troy
performance point
business intelligence
sql server 2005
21 comments:
Many thanks for this Troy - I'd already spent a day trying to get these settings right. I'd add that whilst not impossible you should avoid trying to set up the sample data using remote desktop as it seems to get in a mess with profiles
Tim K
This is killing me - it keeps crashing out at the Processing model with label of 'Strategic Plan' with a Nullreference exception. I've applied all the fixes I though necessary and I just can't seem to get by this. Any tips?
Thanks,
Alex
I tried installing the application following the steps as suggested by Troy, but I am getting the error
C:\Documents and Settings\manishv\Local Settings\temp\2007-10-15_14-46-33>"C:\Program Files\Microsoft Office PerformancePoint Server\2007\BizModeler\PPSCmd.exe" importXML -Server http://localhost:46787 Metadata\Application.xml
Performing import to server 'http://localhost:46787' using file 'Metadata\Application.xml'
====================Connecting to http://localhost:46787
Retrieving the existing metadata for comparision.
::: 0.0781255 seconds.
Validating import file ...
************** Import Failed
Can anybody guide ne how to remove this error ?
alex: I would guess this isn't the first time you'r runnning the install. What I did (facing the same message) was:
# delete the application (from the web console)
# delete the database (from SQL Server Management Studio)
# restart the installation procedure
'hope this helps.
SR
Now here's a question of my own... In this case, the installation script fails when "Processing [Report] with label of [ECR_Input_Shares_Owned]". It seems to be attempting to load files (ECR_Input_Shares_Owned.xls is the first one on the list) at the UNC path that I've specified for Form Templates instead of looking for them in the samples installation directory. It's also actually looking for ASH_Corporate_ECR_Input_Shares_Owned.xls (note the ASH_Corporate_ prefix) instead of ECR_Input_Shares_Owned.xls. Any tips?
Does anybody have an idea what my problem is here? My installation is failing at the same step as it does for manu, and the output is:
C:\Documents and Settings\Podoprigora\Local Settings\Temp\1\2007-11-06_16-01-06>
"D:\Microsoft Office PerformancePoint Server\3.0\BizModeler\PPSCmd.exe" importXML -Server http://localhost:46787 Metadata\Application.xml
Performing import to server 'http://localhost:46787' using file 'Metadata\Application.xml'
====================Connecting to http://localhost:46787
Retrieving the existing metadata for comparision.
::: 0.1250048 seconds.
Validating import file ...
Deserialized: 'Microsoft.PerformancePoint.Planning.Client.Tools.Metadata.Root'.
Creating application ...
Exception during processing: Cannot create application due to failure to create application database. Please check the server log for more details.
System.Web.Services.Protocols.SoapException: Cannot create application due to failure to create application database. Please check the server log for more details.
at Microsoft.PerformancePoint.Planning.Client.Common.ErrorHandler.HandleSoapException(WebServiceCallBlock webServiceCall)
at Microsoft.PerformancePoint.Planning.Client.Common.MetadataManager.Request(PerformancePointRequest performancePointRequest)
at Microsoft.PerformancePoint.Planning.Client.Common.MetadataManager.CreateApplication(String applicationLabel, String applicationName, String referenceDBSer
verName, String referenceDBName, String applicationScriptLocation, String rootSiteName, String rootSiteLabel, String rootSiteOlapServerName, String rootSiteFile
Group, Boolean autoExecuteCreationScript)
at Microsoft.PerformancePoint.Planning.Client.Common.MetadataManager.CreateApplication(String applicationLabel, String applicationName, String rootSiteLabel,
String rootSiteName, String referenceDBServerName, String referenceDBName)
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ProcessApplication(Application app)
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ProcessRoot(Root root)
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ImportMetadata(Root root, String importFolderPath)
************** Import Failed
The web console shows no installed applications.
Hi,
I'm having issues getting this to run as well.
I have the same error as Alex.
Processing [Model] with label of [Strategic Plan]
Exception during processing: Object reference not set to an instance of an objec
t.
System.NullReferenceException: Object reference not set to an instance of an obj
ect.
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ProcessJobTempl
ates(BizModelSite bizSite, Collection`1 jobTemplates)
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ProcessModelSit
e(Application importedApplication, BizApplication currentBizApplicationOnServer,
Application currentExportedApplication, ModelSite site)
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ProcessApplicat
ion(Application app)
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ProcessRoot(Roo
t root)
at Microsoft.PerformancePoint.Planning.Client.Tools.BizImport.ImportMetadata(
Root root, String importFolderPath)
************** Import Failed
not sure where to go from here?
any help is appreciated.
I had the same problems that Alex and Justin have/had? and Stephane is correct, I completely removed what had been loaded from previous attempts and removed the temp folders that the process creates. Now I am getting the same problem that Stephanie is having (I think it's the same) It goes to process the first report which is looking for it in my new folder directory that I created but the file isn't there yet and I get an access denied to that specific document?
Justin, what kind of topology are you using? Do you have a standalone installation or a distributed environment? I myself was having null reference errors coming up unexpectedly, and I had a distributed environment with SQL Server installed on another machine. I was getting the error, was uninstalling the app, deleting its database and was launching the installation again - that were my iterations. After I tried to perform my installation overnight when the net traffic wasn't that busy, everything installed fine.
I don't know the *real* root cause of this but if you have a distributed environment as well, could it be your case too?
Yay, I got it to work, I removed all traces on the server, as suggested. and then reinstalled.
I also kept the XML config files, as i stuffed these up a few times before they getting them right.
in response to the previous comment, i was building on a single server. I was actually using the Win2k3 VHD.
looking forward to seeing what it can do when i get into the office tomorrow
Thank you for the write up. It was helpful.. I do have a very stupid question, however. Do I install the sample on the Server or on the Client? I'm not real clear on that
There's a good TechNet thread dealing with similar issues. The suggestion to specify drive:\path\ instead of \\server\path\ did it for me.
hi troy
i already installed with this procedure.
but when i tried to reinstall, am unable to delete ASH from the planning console.
but i deleted all databases.
varya,
It helped for me to delete the databases.
Hi.
I know this is a year old post, but anyway...
I really need some help with this sample application. When I publish the Sample Dashboard that comes with the Monitoring Server it looks fine in the Preview site, but when I publish to SharePoint all cells values are set to ERROR!
I have no idea of why this is happenig...
Thanks
Hello,
I keep getting the following error, although i doublechecked all configuration files and believe them to be correct:
"C:\Program Files\Microsoft Office PerformancePoint Server\2007\BizModeler\PPSCmd.exe" importXML -Server http://localhost:46787 Metadata\Application.xml
Performing import to server 'http://localhost:46787' using file 'Metadata\Application.xml'
====================Connecting to http://localhost:46787
Retrieving the existing metadata for comparision.
::: 0.0781255 seconds.
Validating import file ...
************** Import Failed
Any help is greatly appeciated.
Best Regards,
Matthias
Hello,
I try to get the ASH demo application running. I doublechecked all configuration files, but i keep getting the error:
C:\Program Files\Microsoft Office PerformancePoint Server\2007\BizModeler\PPSCmd.exe" importXML -Server http://localhost:46787 Metadata\Application.xml
Performing import to server 'http://localhost:46787' using file 'Metadata\Application.xml'
====================Connecting to http://localhost:46787
Retrieving the existing metadata for comparision.
::: 0.0781255 seconds.
Validating import file ...
************** Import Failed
Any help is greatly appreciated.
Best Regards,
Matthias
Hi Guys,
Digging out the old thread here ! I had same error as that of Stephane. Has anyone resolved the issue ? Kindly post the solution if possible.
cheers,
Ganesh
Dears,
I faced the same problem, kindly if anybody solveing this problem , post the solution
Hi to all,
i got rid of my import error, after giving my virtual machine more RAM (4GB instead of 1,5GB). After thad all errors vanished - seems the setup script is not too happy with an overloaded (=swapping) sql server.
Sometimes things can be so simple ;-)
Regards,
Matthias
Post a Comment