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 front end tools Expand / Collapse
Author
Message
Posted Tuesday, October 30, 2012 2:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 11, 2014 9:38 AM
Points: 17, Visits: 407
Hi,

I built a dimensional model with the fact and dim tables populated and created a cube using SSAS 2008.

Now I would like to give the end user's the ability to drag and drop and slice and dice the data like you can using SSAS, however I'm not sure what tools are best for this.

I know Excel has powerpivot which can connect to cubes and/or to the dimensional model. I would like to create a template for them with all of the fields that they will need, publish it to sharepoint and then refresh the data as needed on a scheduled basis. This way, each time they open the workbook the measures/dimensions will be available for them to drag and drop and the data will be refreshed as well.

Are there any good sites that explain this process using excel powerpivot or does anyone have a different or better solution?

thanks

Scott
Post #1379035
Posted Tuesday, October 30, 2012 11:03 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 11:07 AM
Points: 1,187, Visits: 1,222
scottcabral (10/30/2012)
Hi,

I built a dimensional model with the fact and dim tables populated and created a cube using SSAS 2008.

Now I would like to give the end user's the ability to drag and drop and slice and dice the data like you can using SSAS, however I'm not sure what tools are best for this.

I know Excel has powerpivot which can connect to cubes and/or to the dimensional model. I would like to create a template for them with all of the fields that they will need, publish it to sharepoint and then refresh the data as needed on a scheduled basis. This way, each time they open the workbook the measures/dimensions will be available for them to drag and drop and the data will be refreshed as well.

Are there any good sites that explain this process using excel powerpivot or does anyone have a different or better solution?


Doing a quick Bing search I see:

SSAS & Powerpivot
http://technet.microsoft.com/en-us/library/gg399165.aspx
http://www.microsoft.com/en-us/bi/powerpivot.aspx
http://blogs.msdn.com/b/analysisservices/archive/2010/03/12/comparing-analysis-services-and-powerpivot.aspx

Data refresh:
http://technet.microsoft.com/en-us/library/ee210651.aspx
http://blogs.msdn.com/b/analysisservices/archive/2009/11/20/powerpivot-data-refresh.aspx

HTH,
Rob
Post #1379149
Posted Wednesday, October 31, 2012 12:33 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 12,966, Visits: 10,742
You can use a pivottable in Excel to connect to the SSAS datasource.
It works pretty much the same as the cube browser.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1379161
Posted Tuesday, November 27, 2012 6:53 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 531, Visits: 448
I'm a fan of Pivot Grid Designer.

http://www.kropka-olap.com/PGD.htm
Post #1389168
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse