Answered by:
multi-dimensional reporting tool suggestions

Question
-
Please suggest some good multi-dimensional reporting tools that work with well with Microsoft Analysis services (SSAS).
I need something that can pickup all the dimensions and measures from the cube, to report on aggregations, have some graphing capabilities (good to have drilling capability to look at relational data).Thanks.
Friday, January 30, 2015 8:56 PM
Answers
-
- Proposed as answer by 'RajaSekhar' Monday, February 2, 2015 12:04 PM
- Marked as answer by Simon_HouMicrosoft contingent staff Tuesday, February 10, 2015 6:41 AM
Friday, January 30, 2015 9:07 PM -
Hi kvd123,
I suggest you using SQL Server Data Tools – Business Intelligence for Visual Studio(formerly known as Business Intelligence Development Studio) to work with multi-dimension tools. It can view all dimensions and measures within a cube, and drive the data to render like a report.
If you want to create a report for a cube, you can also create Reporting Services solution and use SSAS as data source in SSDT.
Reference:
SQL Server Data Tools – Business Intelligence for Visual Studio
Create First SSRS Report with SQL Server Analysis Services OLAP CubeIf you have any question, please feel free to ask.
Simon Hou
TechNet Community Support- Marked as answer by Simon_HouMicrosoft contingent staff Tuesday, February 10, 2015 6:41 AM
Sunday, February 1, 2015 1:03 PM -
for adhoc reporting user familiar tool excel(powerview ,simple pivot table) is best.
for custom based reporting SSRS and for dashbording excel and performance point are the best tools for SSAS reporting.
Thanks,
Zaim Raza.
http://zaimraza.wordpress.com/
- Marked as answer by Simon_HouMicrosoft contingent staff Tuesday, February 10, 2015 6:41 AM
Monday, February 2, 2015 8:28 AM
All replies
-
- Proposed as answer by 'RajaSekhar' Monday, February 2, 2015 12:04 PM
- Marked as answer by Simon_HouMicrosoft contingent staff Tuesday, February 10, 2015 6:41 AM
Friday, January 30, 2015 9:07 PM -
Hi kvd123,
I suggest you using SQL Server Data Tools – Business Intelligence for Visual Studio(formerly known as Business Intelligence Development Studio) to work with multi-dimension tools. It can view all dimensions and measures within a cube, and drive the data to render like a report.
If you want to create a report for a cube, you can also create Reporting Services solution and use SSAS as data source in SSDT.
Reference:
SQL Server Data Tools – Business Intelligence for Visual Studio
Create First SSRS Report with SQL Server Analysis Services OLAP CubeIf you have any question, please feel free to ask.
Simon Hou
TechNet Community Support- Marked as answer by Simon_HouMicrosoft contingent staff Tuesday, February 10, 2015 6:41 AM
Sunday, February 1, 2015 1:03 PM -
for adhoc reporting user familiar tool excel(powerview ,simple pivot table) is best.
for custom based reporting SSRS and for dashbording excel and performance point are the best tools for SSAS reporting.
Thanks,
Zaim Raza.
http://zaimraza.wordpress.com/
- Marked as answer by Simon_HouMicrosoft contingent staff Tuesday, February 10, 2015 6:41 AM
Monday, February 2, 2015 8:28 AM