Pairing Microsoft SSAS and Microstrategy Report Suite

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 departments in any size organization that need a proven BI solution for SSAS.

· Build reports and performance scorecards against Microsoft SSAS

· Report, analyze, and monitor SSAS data via intuitive Web-based interface

· Visualize data using impactful graphs and performance scorecards .d Answer business questions via quick and efficient access to any size SSAS cube

· Create rankings and time-based comparisons

· Perform a complete range of business calculations and build advanced analytics 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

· Easy and fast deployment of thin-client Web interface; simultaneous availability of reports from Desktop and Web interfaces

· Maintain a single centralized metadata for both SQL Server relational data and SSAS multidimensional data sources

· Improved system performance and faster queries by minimizing client-side processing and data traffic via multi-layer caching

· Free mobile BI licenses, dashboards can be delivered through iPad, Iphone or BlackBerry

Reference : Microstrategy Report Suite Documentation, Microstrategy dot com


4 thoughts on “Pairing Microsoft SSAS and Microstrategy Report Suite

  1. Hi,

    This article is very helpful.
    Is there any similar process like ‘Cube Processing’ in Microstrategy?


Comment please...

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s