Benefits:

Lowest Total Cost of Ownership through managing comprehensive security, data analysis and definition, report distribution all from one central server. Eliminate the need to support multiple application servers.

Proven User and Data Scalability ensures that your business intelligence infrastructure can grow incrementally to meet increasing numbers of users and data. Advanced clustering and VLDB features ensure that you do not lose your initial investment in hardware.

One consistent data view - You can maintain one data dictionary for the company. Consistent report, query and analytic definitions eliminate confusing discrepancies and disagreements.

Easy ad hoc query, analysis and reporting - Allow all business users to obtain reports, queries and analyses without learning any programming or database syntax. Consequently each department obtains the vital business information they need for everyday activities.

Features:

Dynamic SQL Generation. MicroStrategy Intelligence Server stores information about the database tables in metadata. MicroStrategy Intelligence Server uses this metadata to generate optimized SQL for the database. Because the metadata is schema independent, these reports, queries and analyses are generated from your current physical schema without any modifications.

Advanced Caching. MicroStrategy Intelligence Server caches all user requests. Not only are reports cached, but the individual report pages requested by users are also cached. As a result, no redundant processing occurs on the MicroStrategy Intelligence Server or on the database.

Built-in Software-level Clustering and Failover. MicroStrategy Intelligence Server lets you cluster many different individual servers together without any additional software or hardware components. Built-in failover support ensures that if a server experiences a hardware failure, the remaining MicroStrategy Intelligence Servers will pick up failed jobs.