Tuesday, April 9, 2013

SharePoint 2013: Dashboard Designer Not Showing Databases from Analysis Services - Resolution

Scenario
Currently only 1 WFE
PPS Service running on 1 Application Server
Unattended Service Account entered via the PPS Service Application
Same service account belongs to a Role in SSAS (2012) with Read permissions on a cube
BI Center Site Collection created


Problem
Launch Dashboard Designer
Create New Data Source from Analysis Services
Enter Analysis Services Server
Database drop-down shows Loading... but then nothing appears in drop-down list.


Resolution

  1. Install  Microsoft® SQL Server® 2012 ADOMD.NET and Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012 from the Microsoft® SQL Server® 2012 Feature Pack on the WFE and the server running the PPS Service
  2. Install  Microsoft® SQL Server® 2008 R2 ADOMD.NET and Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2 from the Microsoft® SQL Server® 2008 R2 Feature Pack on the WFE and the server running the PPS Service
  3. IISRESET on the WFE and the server running PPS.
  4. Refresh the BI Center Site Collection
  5. Launch Dashboard Designer again from BI Center Site Collection
  6. Enter SSAS Server Name
  7. Database drop-down loads with the databases now!


I wouldn't be suprised if I need to install ADOMD.NET on any new WFEs that I build out but I will update this post when that time comes.

UPDATE 5/28/2013: I built out a new WFE and suprisingly I did not have to install ADOMD.NET. Everything appears to be working correctly.



 
 
Posted by Steve Mann at 4:16 PM
Labels: , , , , ,

20 comments:

  1. RobMay 6, 2013 at 8:43 PM

    Ran into the same problem and this fixed my issue. Thanks!

    ReplyDelete
  2. AnonymousJune 21, 2013 at 10:52 AM

    Thank you!!! Strange that you need the SQL2008R2 bits too...

    ReplyDelete
  3. AnonymousSeptember 4, 2013 at 10:57 AM

    Great post, really useful. How come ADOMD.NET 2008 R2 is needed? Do you have any idea?

    Thanks again :)

    Gabriel

    ReplyDelete
    Replies
    1. Steve MannSeptember 4, 2013 at 12:35 PM

      I believe I needed it in our environment since we had cubes running under SQL Server 2008 R2. You may not need it if you are solely on SQL Server 2012 but I don't have a way of testing that theory.

      Delete
    2. boyboyjcFebruary 17, 2014 at 3:33 AM

      Hi Steve,

      first of all, thanks for the good post.
      I tested in SQL Server 2012 and I didnt install ADOMD.NET 2008 R2.
      and it still shows 'Loading...'
      *I just wanted to confirm this issue.

      and because it just show 'Loading...' -> then I install the ADOMD.NET 2008 R2 as you mentioned above.
      and it works :)

      thank you.

      Delete
  4. AnonymousNovember 14, 2013 at 12:34 PM

    Hi Steve,

    Thanks!!!! you save my day...

    Cheers, Luis

    ReplyDelete
  5. AnonymousNovember 29, 2013 at 9:21 AM

    Thanks!! You saved my day!

    ReplyDelete
  6. goliasseJanuary 26, 2014 at 7:24 AM

    Thanx it resolves my issue with accuracy ...

    ReplyDelete
  7. Wilfredo SanchezJanuary 30, 2014 at 11:02 AM

    I have the same issue... I installed as you said but not work :( Is possible to use some command in Power Shell to check my Sharepoint settings? Do you know?
    Thanks

    ReplyDelete
    Replies
    1. Steve MannJanuary 30, 2014 at 2:43 PM

      I don't know what setting you can check. Did you install both 2008 and 2012 drivers?

      Delete
  8. UnknownJuly 11, 2014 at 4:09 AM

    i installed both versions of adomd.net.it is populating me database but not showing me cubes .please help me out.i spent almost 1 day but couldnot fix it

    ReplyDelete
    Replies
    1. Steve MannJuly 11, 2014 at 8:09 AM

      Make sure the SharePoint service account has read permissions on the cubes.

      Delete
    2. UnknownJuly 13, 2014 at 9:40 AM

      iam very new to sharepoint.can u explain me in detail about how to do that

      Delete
    3. Steve MannJuly 13, 2014 at 2:41 PM

      You need to go into SQL Server Analysis Services or SQL Management Studio and modify the security of the cubes. Whatever service account is running the SharePoint app pools needs to have read access.Here is a good tutorial: http://msdn.microsoft.com/en-us/library/cc304417.aspx

      Delete
    4. Steve MannJuly 13, 2014 at 2:43 PM

      The service account should be the one that was entered as the Unatrended Service Account. Ours is the same as the app pool account.

      Delete
    5. UnknownJuly 14, 2014 at 4:39 AM

      thank you.i already tried that way.my unattended account is domain/administrator and i created a role with domain name in analysis service.but still iam not finding cube in dashboard desginer :(

      Delete
  9. AnonymousJuly 30, 2014 at 11:56 AM

    Thank you very much, we are building a new SharePoint 2013 server and had this exact problem. Your solution worked beautifully.

    ReplyDelete
  10. AnonymousOctober 17, 2014 at 1:46 PM

    Thanks so much. I saved my day.

    ReplyDelete
  11. AnonymousMay 22, 2015 at 2:44 AM

    Überthanks!!!

    ReplyDelete

Subscribe to: Post Comments (Atom)

Matched Content