SSAS and Sharepoint

• kevin_nikolai

  SSCarpal Tunnel

  Points: 4343

  More actions

  March 22, 2012 at 4:35 pm

  #266174

  Would like to access an SSAS cube from Performance Point or Sharepoint to create a Sharepoint version of a report. I have heard about webparts, would like to use them to make sharepoint report interactive. Can anyone assist or give me some pointers ?

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  March 22, 2012 at 10:37 pm

  #1463156

  Its as easy as pie...

  here are a few setup references...

  http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?ID=337

  http://technet.microsoft.com/en-us/sharepoint/ee692578

  http://blogs.devhorizon.com/reza/2010/05/03/bi-center-and-data-connection-errors-when-using-performancepoint-dashboard-designer/

  http://technet.microsoft.com/en-us/library/ee748644.aspx

  In essence, you will need the following:

  1. SSAS Cube

  2. Sharepoint with performance point service

  3. Unattended service account

  4. Secure Store Proxy with Generated Key

  5. Associate the unattended service account with your new application pool.

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

• kevin_nikolai

  SSCarpal Tunnel

  Points: 4343

  More actions

  March 23, 2012 at 3:45 pm

  #1463843

  Thanks Henrico. Already checked the URL's you posted.

  4. Secure Store Proxy with Generated Key:

  Configure the Secure Store Service (SharePoint Server 2010) -

  http://technet.microsoft.com/en-us/library/ee806866.aspx