MicroStrategy Reporting Suite is a free, commercial reporting tool for developing and delivering operational and analytical

Analytics

Analytics is the application of computer technology, operational research, and statistics to solve problems in business and industry. Analytics is carried out within an information system: while, in the past, statistics and mathematics could be studied without computers and software, analytics has...

 reports. Report outputs are HTML

HTML

HyperText Markup Language is the predominant markup language for web pages. HTML elements are the basic building-blocks of webpages....

, PDF

Portable Document Format

Portable Document Format is an open standard for document exchange. This file format, created by Adobe Systems in 1993, is used for representing documents in a manner independent of application software, hardware, and operating systems....

, Microsoft Excel

Microsoft Excel

Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications...

, and text. Data can be presented in tabular grid reports, graphs and charts, and combination grid-and-graph displays.

The package is composed of server

Server (computing)

In the context of client-server architecture, a server is a computer program running to serve the requests of other programs, the "clients". Thus, the "server" performs some computational task on behalf of "clients"...

 software for core analytical processing and job management, an end-user

End-user

Economics and commerce define an end user as the person who uses a product. The end user or consumer may differ from the person who purchases the product...

 Web interface, Web-based

World Wide Web

The World Wide Web is a system of interlinked hypertext documents accessed via the Internet...

 reporting software, desktop

Application software

Application software, also known as an application or an "app", is computer software designed to help the user to perform specific tasks. Examples include enterprise software, accounting software, office suites, graphics software and media players. Many application programs deal principally with...

 reporting software, and a data architecting product. It is part of the unified MicroStrategy

MicroStrategy

MicroStrategy, Inc. , is a business intelligence software vendor. MicroStrategy's software enables leading organizations worldwide to analyze the vast amounts of data stored across their enterprises to make more strategic business decisions...

 business intelligence

Business intelligence

Business intelligence mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes....

 architecture. The package includes a license for 100 users, and two free licenses for the other MicroStrategy products, including MicroStrategy Mobile

Mobile business intelligence

Mobile Business Intelligence refers to the distribution of business data to mobile devices such as smartphones and tablet computers...

, OLAP

OLAP

In computing, online analytical processing, or OLAP , is an approach to swiftly answer multi-dimensional analytical queries. OLAP is part of the broader category of business intelligence, which also encompasses relational reporting and data mining...

, and Distribution Services.

MicroStrategy Reporting Suite can also integrate with Microsoft Analysis Services

Microsoft Analysis Services

Microsoft SQL Server Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services and Analysis Services...

 (SSAS).

Features

• Design environment
• Centralized metadata
  Metadata
  The term metadata is an ambiguous term which is used for two fundamentally different concepts . Although the expression "data about data" is often used, it does not apply to both in the same way. Structural metadata, the design and specification of data structures, cannot be about data, because at...
  
   builder
• Web interface
• Ad hoc
  Ad hoc
  Ad hoc is a Latin phrase meaning "for this". It generally signifies a solution designed for a specific problem or task, non-generalizable, and not intended to be able to be adapted to other purposes. Compare A priori....
  
   reporting
• Analytic engine
  Analytical engine
  The Analytical Engine was a proposed mechanical general-purpose computer designed by English mathematician Charles Babbage. It was first described in 1837 as the successor to Babbage's difference engine, a design for a mechanical calculator...
  
  
• Parameterization
  Parametrization
  Parametrization is the process of deciding and defining the parameters necessary for a complete or relevant specification of a model or geometric object....
  
   engine
• Dynamic SQL
  SQL
  SQL is a programming language designed for managing data in relational database management systems ....
  
   engine
• Security engine for user, data and object level security
• Runs on Windows
  Microsoft Windows
  Microsoft Windows is a series of operating systems produced by Microsoft.Microsoft introduced an operating environment named Windows on November 20, 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces . Microsoft Windows came to dominate the world's personal...
  
  , UNIX
  Unix
  Unix is a multitasking, multi-user computer operating system originally developed in 1969 by a group of AT&T employees at Bell Labs, including Ken Thompson, Dennis Ritchie, Brian Kernighan, Douglas McIlroy, and Joe Ossanna...
  
  , and Linux
  Linux
  Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
  
   operating system
  Operating system
  An operating system is a set of programs that manage computer hardware resources and provide common services for application software. The operating system is the most important type of system software in a computer system...
  
  s and is optimized for all major database platforms, Web server
  Web server
  Web server can refer to either the hardware or the software that helps to deliver content that can be accessed through the Internet....
  
  s, and application server
  Application server
  An application server is a software framework that provides an environment in which applications can run, no matter what the applications are or what they do...
  
  s, including open source
  Open source
  The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
  
   operating systems (Linux), databases (mySQL
  MySQL
  MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
  
   and PostgreSQL
  PostgreSQL
  PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
  
  ), Web servers (Apache HTTP Server
  Apache HTTP Server
  The Apache HTTP Server, commonly referred to as Apache , is web server software notable for playing a key role in the initial growth of the World Wide Web. In 2009 it became the first web server software to surpass the 100 million website milestone...
  
  ), and application servers (Apache Tomcat
  Apache Tomcat
  Apache Tomcat is an open source web server and servlet container developed by the Apache Software Foundation...
  
   and JBoss)

End-user features

• Formatting tabular grid reports using a choice of built-in styles
• Converting tabular grid reports to graphs and charts
• Conditional formatting of data and visual indicators
• Prompting or parameterized reporting
• Drilling down into granular level data
• Exporting to Microsoft Excel, HTML or text formats
• Multi-key sorting
• Printing

Further reading

• "Can a Leopard Change Its Spots? MicroStrategy Revamps Positioning, Pricing and Packaging" by Rita L. Sallam, Gartner, May 2009.

External links

• MicroStrategy Reporting Suite