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
there are ton's of BI\OLAP front ends and all of them do have their advantages.
In my point of view it really depends on the strategy of your company:
* how much money would you like to spend (the cheapest would probably be excel with Pivot tables)
* do you need an additional user rights Management despite secuirty in ssas (e.g. who should be allowed to create and publish reports) (not possible with excel)
* do you need writeback (some frontends doesn't support writeback)
* do you need some automatic distribution process (send a report once a month to specific users)
* should your front end also support relational reports
If it's really "just" access to cube and drag&drop some dimensions/hierarchies to rows/columns go for excel (or at least start) I don't think there is any easier and cheaper tool anywhere. If you do need more feautures go for a "Commercial" front end. I do have experience with cubeware (german based company) and think it does a pretty good job.
P.s. it would be easier to give feed back to specific front ends then giving a "general" advise.
please mark helpful posts, and answers. It helps others to find relevant posts to the same question.
- Edited by Gregor Prohaska Wednesday, July 27, 2016 8:21 PM