question

INES avatar image
INES asked

User friedly (drag and drop) OLAP reporting services

Hi, I have one question. Can you suggest me which is the best OLAP user friedly report builder?
olap
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The best it may not be but I would definitely say Report builder/ Visual Studio from Microsoft to build the reports against Reporting Services. The reason being that you may not have to buy any license as Reporting services come along with SQL Server. Another popular tool is Crystal Reports.
1 Like 1 ·
Hi, I have one question. Can you suggest me which is the best OLAP user friedly report builder for SQL?
0 Likes 0 ·
something like "kyubit olap analysis and visualization"....
0 Likes 0 ·
Thank`s but we try that and it`s not so bad but we want something that customers of our aplication can just drag and drop and report is created like in this videos [ http://www.kyubit.com/OLAP-tool-videos][1]. [1]: http://www.kyubit.com/OLAP-tool-videos
0 Likes 0 ·

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
Depends what are your reporting needs. **Excel** is really user friendly and brings an easy drag and drop features including slicers etc. In combination with SharePoint and Excel services it is very powerful. Also as @Usman Butt mentioned, SSRS and Report builder are relatively good, but not so Drag&Drop as Excel. In case of MS SQL 2012 EE (BI) and Tabular Model, in combination with SharePoint 20120 EE you have PowerView (Project Crescent) which is fully interactive reporting and analytical solution. The only drawback or PowerView is that it can only works with Tabular Model and not with Multidiensional model. The issue is that current implementation of BISM doesn't contain DAX to MDX translation and PowerView is using DAX for querying.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.