July 9, 2009 at 1:43 am
Can anyone suggest the best tool to allow end-users to "explore" data in an SSAS cube. Ideally I'm looking for a tool that acts similar to the "browse" tab of the cube designer in BIDS where you drag dimensions onto a display area to form the rows and columns, apply filters, set heirachy etc.
Or is the apporach most people take to point Excel at the data source?
July 9, 2009 at 5:38 am
Excel 2007 is a good tool if that is all you can use for the time being.
Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
Here is a good list of tools here - http://ssas-info.com/analysis-services-client-tools-frontend
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 6, 2011 at 1:25 am
Late comment, but for people looking at this post.... Pyramid Analytics is the best Analysis Serivces (SSAS) client tool on the market today for browsing OLAP cubes.
😎
November 18, 2014 at 2:22 am
Kyubit AnalysisPortal seems to be perfect OLAP web based client for data exploration and analysis.
Cheers
November 18, 2014 at 2:29 am
Power View works pretty fine as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply