StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGet PowerView to work with existing cubes on SQL Server 2008 R2
primarykey
Id
20660720
data
AcceptedAnswerId
20696199
AnswerCount
1
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-12-18T14:24:32.047
FavoriteCount
0
LastActivityDate
2013-12-20T04:18:51.617
LastEditDate
2013-12-19T15:45:01.130
LastEditorUserId
1168920
OwnerUserId
1168920
ParentId
0
PostTypeId
1
Score
0
ViewCount
967
LastEditorDisplayName
text
Body
I've been doing some research into the setup required to get PowerView to connect to existing cubes sitting on a SQL Server 2008 R2 instance. Can anyone confirm that the following is right (or correct me if I'm wrong)? I believe I need the following: <ul> <li>SharePoint Server 2010 Enterprise Edition with 'Reporting Services Add-in for SharePoint Products' installed from SQL Server 2012 or SQL Server 2008 R2</li> <li>My existing SQL Server Analysis Services 2008 R2 Enterprise Edition running in 'SharePoint Integrated' mode</li> <li>SQL Server 2012 Reporting Services installed in 'SharePoint Integrated' mode updated with SQL Server 2012 Service Pack 1 Cumulative Update 4</li> </ul> I have been trying to put together the information I have found in the following places: <a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/95a31c10-f558-48b1-ab1f-ee7cf56741e9/powerview-along-with-sql-server-2008-r2?forum=sqlreportingservices" rel="nofollow">http://social.msdn.microsoft.com/Forums/sqlserver/en-US/95a31c10-f558-48b1-ab1f-ee7cf56741e9/powerview-along-with-sql-server-2008-r2?forum=sqlreportingservices</a> <a href="http://blogs.msdn.com/b/analysisservices/archive/2013/05/31/power-view-connectivity-for-multidimensional-models-released.aspx" rel="nofollow">http://blogs.msdn.com/b/analysisservices/archive/2013/05/31/power-view-connectivity-for-multidimensional-models-released.aspx</a> but it's extremely possible I may be getting things confused.
Tags
<sharepoint><sql-server-2008-r2><sql-server-2012><olap-cube><powerview>
Title
Get PowerView to work with existing cubes on SQL Server 2008 R2
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USKatie
UserOwnerUserId
1. USKatie
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.