Reporting 

Analyzer makes building new reports easy. Working in a familiar Windows®-style environment, users drag and drop components to create new reports. Analyzer’s one-click functionality with context sensitive menus make Analyzer easy to learn.

Users, report designers, and administrators each access Analyzer through their web browser, which provides them with full functionality to view, create, manage, and share information based on their role. Analyzer works in a single browser instance using tabs to let users access multiple reports.

Components are the building blocks of reports and there are many components to choose from. Users can build reports using tabular data in pivot tables, visually-compelling charts and graphs, business process diagrams, web pages, or Reporting Services® reports, allowing them to choose the best way to present the information.

 
Analyzer: Pivot table report with KPI's.


Each page is made up of one or many components, giving the user the flexibility to display multiple metrics. Each component is based on data from cube-based dimensions, measures, named sets, and key performance indicators, as well as the underlying data from the relational database.  By integrating tightly with Microsoft’s SQL Server® Analyzer allows users to take advantage of Reporting Services reports by embedding them into their reports and passing parameters back to Reporting Services directly. Users can also drag-and-drop between an Analyzer report and Reporting Services report.

In addition to building custom reports, users can also add conditional formatting for the highest impact. In-table visualization features bring the reports to life. KPI images and data bars can be easily added on the fly alongside the values in each report cell for quick, visual analysis.