About Me

Having 12 years experience in Microsoft technologies.Since more than 7 years working in SharePoint technologies. Expert in providing consultation for SharePoint projects. Hands on with development and administration.

Wednesday 28 January 2015

PPS 2010/2013 - The data source no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator


When connecting to data source in PPS, you don’t find cube in the drop down. Though the account had full admin rights on cube.
The event viewer entry would be
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.


Resolution:
  1. Install ADOMD.NET for Microsoft® SQL Server® 2008 R2 Feature pack
  2. You can find the exe @
  3. Check under instructions
    Cheers!
    Vamsi
     

Perofrmance Point 2013 scorecard error - An unexpected error occurred. Error 47205

Issue: When you connect to PPS to create score card, you may get following error
Unexpected error system error has occured, Additional details has been logged to administrator
And event viewer error would be
Exception 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)



Resolution
  1. Install analysis Management objects (AMO) package. NOT the ADOMD.net
  2. You should install the exe in all SharePoint servers in the farm.
  3. You can download the package from

4. You can find the package under "Install Instructions" and search for "Microsoft Analysis Management Objects"



Cheers!
Vamsi