I'm looking for good OLAP UI Reporting tool - web based or client based. Our business users needs to access&use OLAP cubes like a report generator and allow users to select some dimensions and measures of the cube. Our business users are not too computer savy, and plain excellent excel or PowerPivot may scare them away (with too many options). what lightweight tools could be used to develop business user friendly OLAP UI? Thank you
- Edited by BrBa Thursday, January 16, 2014 4:35 PM
Im interested to see why you've jumped into Power Pivot when your referring to OLAP access. The standard MS way of analysis to a cube is through Excel and a Pivot Table.
There is a good listing of client tools on the ssas-info web site http://www.ssas-info.com/analysis-services-client-tools-frontend
According to your description, you are looking a friendly OLAP UI tool for end users who are not too computer savy, right? If you want to generate a report using the OLAP cube, then you can create a report model as the datasource, and then deploy it to report server, and then end users can use it to gengrate a report by draging and droping. For the detail information about it, please see:
Report Models (Report Builder 3.0 and SSRS)
Besides, here is similar thread for your reference.
UI for SSAS cubes
TechNet Community Support