Creating scorecard error

I am following some tutorials in SQL training kit for creating scorecards. When I do create > scorecard >> chose adevnture works OLAP >>> then chose Import SQL server AS KPIs, I get a message box indicating "Unexpected error system error has occured, Additional details has been logged to administrator".

I checked my Sharepoint server event viewer and saw the following :

An unexpected error occurred.  Error 47205.

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)

Whic is very strange as I have already done some other tutorials and I can access my AS for other things

Thanks for your help

 

June 20th, 2010 6:12pm

Hello eliassal,

Is this PPS 2007 or PPS 2010? What version of SQL are you attempting to Import SQL Server AS KPIs from?

Thanks,
Jon Thomas

Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2010 12:00am

It is 2010 and SQL 2008 R2
June 22nd, 2010 12:34am

Do you have this setup in a distributed environment?  Do you have ADOMD.NET installed on your SharePoint server?

http://social.technet.microsoft.com/Forums/en-US/ppsmonitoringandanalytics/thread/433ebc3e-1c6d-4918-acb9-22e4f1ba0a99/

Try downloading and installing the ADOMD.NET from the SQL Server 2008 R2 Feature Pack on the SharePoint server and try again (make sure you install the correct version - 32 or 64 bit)

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52

Once installed you should find this in the following location (drive location might be different) - C:\Program Files\Microsoft.NET\ADOMD.NET\100

Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2010 3:01pm

Ok, I will try this. Dan, I am not receiviung alerts when you respond. Is there any issues with alerts?
June 23rd, 2010 12:25pm

I downloaded the ADOMD.NET for R2 from feature pack, ran setup, rebooted, I have exactly the same error.

 

Free Windows Admin Tool Kit Click here and download it now
July 1st, 2010 12:26am

Hello eliassal,

Out of curiousity do you have SSRS running in Integrated mode on the SharePoint 2010 servers?

Thanks,
Jon Thomas

July 1st, 2010 1:17am

Hello! I get the same error when try to import kpi list from SSAS via Performance Point 2010 Dashboard Designer. I have almost the same configuration SQL Server 2008 R2 and  SharePoint  2010

I copied Microsoft.AnalysisServices dll from SQL server to SharePoint server and installed it into GAC but still have the same error.  Microsoft.AnalysisServices has reference to   Microsoft.AnalysisServices.SharePoint.Integration but I can't find it.

I have both version of Adomd.net (100 & 90).

what is wrong and should I do to resolve this problem?

Free Windows Admin Tool Kit Click here and download it now
July 1st, 2010 9:50am

No, I don't think so. Anyway, how can I double check this?
July 1st, 2010 10:39am

Just thought I'd revive the thread here since I too have the same issue.

Let's detail our setup and maybe we'll get somewhere and maybe help a few other in the process.

The issue: Whenever we try to import a KPI that has been defined in a SSAS cube, we get an unknown error that drops a event similar to this:

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)

What we know:

  • We can access the KPI manually with an MDX command (i.e. KPIVALUE("Name of KPI")) so access right and security is pretty much not a problem.
  • This is a brand spanking new install of Sharepoint and nothing has been added except for the performancePoint 2010 specific setup.
  • We have tried installing the ADOMD.NET from the SQL server 2008 R2 feature pack, it installed successfully and it did not work.
  • The SQL server 2008 R2 SP1 CU5  is on another computer and security seems to be fine since we can access our datasource and cubes and so forth

What I think is going on:

Since the SSAS instance is on a remote computer, my guess is that we're indeed missing something on the sharePoint server machine. Now I know that the ADOMD.NET is not the missing link here since we just installed it and rebooted the server with no results.

So what could possibly be missing here? I am thinking we need to install SQL server 2008 on the sharePoint server itself eventhough the actual data is on a remote computer. The thing is that it all seems like colossal waste of time considering we're not sure it'll fix the issue.

So if anyone who has gotten the problem and managed to fix it, please do share your solution.

Thanks a lot

Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2010 9:33pm

Completely agree with you Rancorbeast, I am waiting for a fix since 1 month and a half.

I think MS folks now should take care of this seriously. Since my last response to Dan, nothing happened

August 3rd, 2010 9:49pm

Thanks for keeping the thread alive with me!

I think what I'll do when I get the time is to go ahead and install SQL-Server 2008 R2 on the SharePoint Server. Call me crazy but like I said in my first post it sounds like a lot of work for something quite simple really. Not to mention that there are licensing concerns ( I think so anyway). We chose to install the SQL Server instance on a separate machine because, well it's our data wahrehouse... not going to pay another licence of SQL server just to get a darn DLL on there.

Anyway, I'll run some test and see what happens. I'll make sure to update the thread as soon as we're done.

I gotta say that this PerformancePoint server sure is a lot of work for what it's worth...

Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2010 10:03pm

VICTORY !!

The solution was to install the analysis Management objects (AMO ) package. NOT the ADOMD.net in fact the AnalysisServices.DLL that was missing is not in the ADOMD.net package so AMO is the way to go.

The installation needs to be done on the machine running SharePoint. Be mindful of your SQL version and platform though. In our case we have SQL server 2008 SP1 so I downloaded the AMO package from the SQL server 2008 feature pack from april 2009 available here http://www.microsoft.com/downloads/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4&displaylang=en

After the installation, confirm that the AnalysisServices.DLL in present in the GAC on the machine running SharePoint. You can do this by browsing to C:\windows\Assemby and look for Microsoft.AnalysisServices.Dll.

If it's there, you can simply restart IIS on the SharePoitn server and voila !! I can now import my KPI from SSAS.

Good luck and if you need more info let me know!

August 4th, 2010 9:40pm

Congratulation Ran, well done.

I have SQL 2008R2

Free Windows Admin Tool Kit Click here and download it now
August 4th, 2010 10:17pm

Lovely, it is working for me as well now but I downloaded the Microsoft® SQL Server® 2008 R2 Analysis Management Objects at http://www.microsoft.com/downloads/details.aspx?FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52&displaylang=en

Question, how did you come to the conclusion that this was missing?

August 4th, 2010 10:55pm

Well, I wasn't convinced that the ADOMD.NET was the culprit as it was suggested on this thread. The reason why was the fact that ADOMD.net is installed by default with a Sharepoint2010. The error log specifically mentions Microsoft.AnalysisServices as the file that was missing and sure enough if I did a search on the SharePoint server the file was nowhere to be found.

So I set out to find on the web what was the name of that package that did contain that specific DLL and it turned out to be the AMO package. After that is was just a matter of installing the package and restarting IIS on the sharepoint server.

The leason here is that Microsoft installs the bare minimum when it comes to interacting with your cubes. The way I understand things, the ADOMD.NET component lets you read the content of the cube but you need the AMO package to read the metadate surrounding the cube data. That would explain why we were able to access the KPI using MDX but not using their importKPI wizard... my guess is that specific part of the code absolutly needs the AMO package.

cheers!

Free Windows Admin Tool Kit Click here and download it now
August 5th, 2010 2:55pm

I tried installing both the x86 and x64 package for AMO, and refreshing \windows\assembly but the Microsoft.AnalysisServices.SharePoint.Integration file still is not there!
March 8th, 2013 6:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics