MicroStrategy Reporting Suite for Microsoft Analysis Services (Free)

User-friendly BI interface to make better decisions from your SQL Server Analysis Services data

An End User Interface to Microsoft SQL Server Analysis Services (SSAS)
MicroStrategy Reporting Suite serves as an ideal end user interface for business users to leverage actionable information effortlessly from all Microsoft SQL Server relational and cube data sources. The award-winning Web interface included with MicroStrategy Reporting Suite is intuitively used by business users and easily deployed by IT. Cross-tab grid reports, graphs, first order dashboards (grid-and-graph displays), and performance scorecards – for comprehensive business intelligence (BI) reporting – are available to business users via simple point-and-click actions. 

MicroStrategy Reporting Suite for SSAS – A Powerful, Free Solution
MicroStrategy Reporting Suite provides organizations with easy-to-use reporting and analysis tools that allow business users to interface with Microsoft SQL Server Analysis Services cubes, enabling everything from basic and advanced analysis to ad hoc reporting and data visualization.  MicroStrategy Reporting Suite is ideal for small to mid-sized businesses, as well as departments in any size organization, that need a proven BI solution for SSAS.

MicroStrategy Reporting Suite is available via a free download and the license is perpetual, providing Web-based reporting of your SSAS data for up to 100 users in your department or small to mid-sized business… at no charge. Free online training, free online support, and other free resources help ensure your rapid development and deployment. Start reporting against SSAS today!

Features

• Build reports and performance scorecards against SQL Server Analysis Services data
• Report, analyze, and monitor SSAS data via intuitive Web-based interface
• Visualize data using impactful graphs and performance scorecards
• Create rankings, time-based comparisons, and predictive models
• Discover data patterns and forecast using sophisticated data mining algorithms
• Perform a complete range of business calculations and build advanced analytics and forecasts against SSAS data
• Schedule reports to run to a personalized history list
• Full range of interactivity from sorting, filtering, and drilling to formatting, thresholding, and graphing
• Export to Microsoft Excel and PDF
• Drill seamlessly to detailed data in SQL Server relational database when data in SSAS cube lacks sufficient detail
• Ad hoc query and parameterized, self-service reporting of relational and cube data
• Support multiple concurrent requests from both Web and Windows users to report against SSAS data
• Examine SSAS cube dimensions, hierarchies, attributes, measures, members, calculated members, and other components
• Import SSAS cube structures automatically into the MicroStrategy metadata repository
• Run MDX queries against SSAS cubes without writing any code or scripts
• Map individual users’ security credentials to SSAS roles from within MicroStrategy
• Integrate into Microsoft Office SharePoint Server and other portals
• Leverage MicroStrategy reporting capabilities directly against SSAS (no data warehouse is required)
• Built on the MicroStrategy BI platform for flexible and scalable extensibility

Benefits for Business Users and IT Professionals

• Perform statistical and advanced analysis, run performance scorecards, drill through to investigate details all from the same tool, satisfying all users’ needs
• Extend SSAS data analysis to all users, empowering even novice users to discover trends and anomalies in convenient Web-based reports
• Answer business questions via quick and efficient access to any size SSAS cube
• View detailed information in tabular grid reports or visualize in graphs and grid-and-graph reports in a single click
• Maintain a single centralized metadata for both SQL Server relational data and SSAS multidimensional data sources
• View data from all OLAP data sources within the organization from the same Web interface
• Easy and fast deployment of thin-client Web interface; simultaneous availability of reports from Desktop and Web interfaces
• Improved system performance and faster queries by minimizing client-side processing and data traffic via multi-layer caching
• Lower total cost of ownership (TCO) gained by free license, free online training, free online support, 60 days of free email support, self-service empowerment of end users, and low IT overhead

Technical Details
Use MicroStrategy Reporting Suite to join data from different MDX cube sources:

• Microsoft SQL Server 2008 Analysis Services
• Microsoft SQL Server 2005 Analysis Services
• Microsoft SQL Server 2000 Analysis Services
• SAP BW / SAP BI
• Oracle Essbase / Hyperion Essbase

… and relational databases:

… to bring your data into one cohesive reporting application.  See the MicroStrategy Reporting Suite architecture diagram for a graphical representation.  For specific version support information, please reference the Readme file included in the free MicroStrategy Reporting Suite download. 

Integration with Microsoft
The MicroStrategy BI platform integrates with Microsoft SQL Server Analysis Services 2008, 2005, and 2000, as well as Windows, Microsoft Office SharePoint Server, and Microsoft Office.

More info...