locked
Creating scorecard error RRS feed

  • Question

  • 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

     

    Sunday, June 20, 2010 3:12 PM

Answers

  • 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!

    • Proposed as answer by Rancorbeast Wednesday, August 4, 2010 6:41 PM
    • Marked as answer by Heidi Tr - MSFT Thursday, August 12, 2010 6:17 PM
    Wednesday, August 4, 2010 6:40 PM
  • 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...

    • Proposed as answer by Rancorbeast Wednesday, August 4, 2010 6:31 PM
    • Marked as answer by Heidi Tr - MSFT Thursday, August 12, 2010 6:17 PM
    Tuesday, August 3, 2010 7:03 PM

All replies

  • 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


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, June 21, 2010 9:00 PM
  • It is 2010 and SQL 2008 R2
    Monday, June 21, 2010 9:34 PM
  • 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


    Dan English's BI Blog
    Tuesday, June 22, 2010 12:01 PM
  • Ok, I will try this. Dan, I am not receiviung alerts when you respond. Is there any issues with alerts?
    Wednesday, June 23, 2010 9:25 AM
  • I downloaded the ADOMD.NET for R2 from feature pack, ran setup, rebooted, I have exactly the same error.

     

    Wednesday, June 30, 2010 9:26 PM
  • Hello eliassal,

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

    Thanks,
    Jon Thomas


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, June 30, 2010 10:17 PM
  • 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?

    Thursday, July 1, 2010 6:50 AM
  • No, I don't think so. Anyway, how can I double check this?
    Thursday, July 1, 2010 7:39 AM
  • 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

    Tuesday, August 3, 2010 6:33 PM
  • 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

    Tuesday, August 3, 2010 6:49 PM
  • 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...

    • Proposed as answer by Rancorbeast Wednesday, August 4, 2010 6:31 PM
    • Marked as answer by Heidi Tr - MSFT Thursday, August 12, 2010 6:17 PM
    Tuesday, August 3, 2010 7:03 PM
  • 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!

    • Proposed as answer by Rancorbeast Wednesday, August 4, 2010 6:41 PM
    • Marked as answer by Heidi Tr - MSFT Thursday, August 12, 2010 6:17 PM
    Wednesday, August 4, 2010 6:40 PM
  • Congratulation Ran, well done.

    I have SQL 2008R2

    Wednesday, August 4, 2010 7:17 PM
  • 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?

    Wednesday, August 4, 2010 7:55 PM
  • 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!

    Thursday, August 5, 2010 11:55 AM
  • 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!
    Friday, March 8, 2013 3:21 PM