Performance Point Services 2013 - Score card error when creating KPIs in SharePoint 2013

When importing KPIs as part of creating score cards in PPS designer 2013, we may get following error
An unexpected error occurred.  Error 47205

Following is the event log entryException details:
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.AnalysisServices, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
   at Microsoft.PerformancePoint.Scorecards.Server.ImportExportHelper.GetImportableAsKpis(DataSource asDataSource)
   at Microsoft.PerformancePoint.Scorecards.Server.PmServer.GetImportableAsKpis(DataSource dataSource)

Strangely GAC has this assembly….

But the answer is we should install analysis Management objects (AMO ) package. NOT the ADOMD.net

The AnalysisServices.DLL will not be installed as part of AMDO.Net installation. Hence, we should install AMO package. Please mind that when you download the AMO package based on you SQL server version like 2008 R2, 2012, 2014.

For SQL Server 2008 R2

http://www.microsoft.com/en-gb/download/details.aspx?id=16978

Click ‘Install Instructions’ and search for ‘AMO’
For SQL Server 2012

http://www.microsoft.com/en-gb/download/details.aspx?id=29065

Click ‘Install Instructions’ and search for ‘AMO’

For SQL Server 2014

http://www.microsoft.com/en-gb/download/details.aspx?id=42295

Click ‘Install Instructions’ and search for ‘AMO’

After installing the AMP package, you can see AnalysisServices.DLL in GAC..

Note: Install the respective package in all SharePoint web front end servers and reset IIS

Cheers!

Mohan

 

Update SharePoint 2010/2013 - Claims to Windows token - service identity(account) using PowerShell Commands

Sometimes it is required to update/modify identity (account) for services in SharePoint 2010/2013.

In this article, I will show you - how to update the identity of 'Claims to Windows token service' using PowerShell

Note:

1. Replace <Account Name> with your own account (identity)

2. Replace "Claims to Windows Token Service" with your own service name

3. Run the script in windows PowerShell console

----------------------------------------------------------------------------------------------------------------------------------

#SharePoint PowerShell SnapIn Required Add-PSSnapin Microsoft.SharePoint.PowerShell   [string] $Identity = "<Account Name>" [string] $ServiceTypeName = "Claims to Windows Token Service"   #Get Reference to Service $Service = (Get-SPFarm).services | where {$_.typename -eq $ServiceTypeName}   #Get Reference to Managed Account $IdentityManagedAcct = Get-SPManagedAccount -Identity $Identity   #Get Reference to Process Identity and Update Identity $SvcProcessIdentity = $Service.ProcessIdentity $SvcProcessIdentity.CurrentIdentityType = [Microsoft.SharePoint.Administration.IdentityType]::SpecificUser $SvcProcessIdentity.Username = $IdentityManagedAcct.UserName $SvcProcessIdentity.Update() $SvcProcessIdentity.Deploy() -------------------------------------------------------------------------------------------------------------------------------- Tip1: Following command let to view all services in the farm Get-SPServiceInstance Tip2: Confirm your Id by running the following cmdlet Get-SPServiceInstance -identity <Paste the Id> Another way of doing the same job from Central Administration CA--> Security--> Configure Service Accounts   Select the service, which you want to update       Update the account and click ‘OK’     Cheers! Vamsi