Tuesday, June 04, 2013

Performance Point Services from scratch

Symptoms:
When trying to access sharepoint from Dashboard Designer error is thrown.
image or
image
Solution:
Make sure these are installed:
From SQL Server 2012 Feature pack:
 -  Microsoft® SQL Server® 2012 ADOMD.NET and
 -  Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012
From SQL Server 2008 R2:
 -  Microsoft® SQL Server® 2008 R2 ADOMD.NET and
 -  Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2

Make sure all these things are configured.
1. Start Secure Store Service
a. Central Administration> Application Management> Manage Services on Server> Secure Store Service > Start
2. Run iisreset
a. Cmd > iisreset
3. Create new Secure Store Service
a. Central Administration>Application Management> Manage Service Applications > New Secure Store Service (default settings)
4. Generate Key for Secure Store Service.
a. Central Administration>Application Management>Manage Service Applications> Secure Store Service (created above) Generate New Key
i. Use passphrase: P@ssw0rd! (optional)
5. Refresh Key for Secure Store Service.
a. Central Administration>Application Management>Manage Service Applications> Secure Store Service (created above)>Refresh Key
6. Create domain user :adventureworks\sp_unattend
a. Using Active Directory Users and Computers>New User sp_unattend with password: P@ssw0rd!
7. Create SQL Login, add db_datareader perm for sp_unattend
a. Using SQL Management Studio >Security>Logins>New Login> Loginname: Sp_unattend (or search for it)
b. User Mapping> db_datareader for all databases needed
8. Create new Performance Point Service
a. Central Administration>Application Management>Manage Service Application>New Performance Point Service Application
i. Add this service applications proxy to farm default
ii. Other Default or new application pool if needed.
9. Configure Performance Point Service, add Unattended Account.
a. Central Administration>Application Management>Manage Service Application>Performance Point Services(created above)>PerformancePoint Service Application Settings> Add adventureworks\sp_unattend as unattended service account
10. Optional Restart Server or IISReset again if any problems.
Note that if server has less than 4GB available this might not work and result in eventid3 >WebhostFailedToProcessARequest
References:
http://technet.microsoft.com/en-us/library/ee748643.aspx
http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx - good site for config .secure services

http://www.microsoft.com/en-us/download/details.aspx?id=1697 - SQL Server 2008 R2 Feature pack

http://www.microsoft.com/en-us/download/confirmation.aspx?id=29065  - SQL Server 2012 Feature pack

http://bhavikmerchant.wordpress.com/2012/12/08/setting-up-a-sharepoint-2013-bi-demo-vm/ - more detailed guide













No comments: