Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSAS and Sharepoint Expand / Collapse
Author
Message
Posted Thursday, March 22, 2012 4:35 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:40 PM
Points: 159, Visits: 454
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 ?
Post #1271286
Posted Thursday, March 22, 2012 10:37 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 12:58 AM
Points: 1,904, Visits: 2,771
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.


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1271374
Posted Friday, March 23, 2012 3:45 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:40 PM
Points: 159, Visits: 454
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
Post #1272149
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse