One Consistent Data View Streamlines Development & Reporting Users can maintain one data dictionary for the entire company. Consistent query, report and analytic definitions elimi-nate confusing discrepancies and disagreements.  Once the metadata repository contains the mapping of the database and the business model, system developers can quickly and efficiently create and distribute reports. Unlike our competitors that require users to set up multiple metadata repositories and create multiple mappings for multiple universes, MicroStrategy Architect sets up one single repository for streamlined development. A central metadata repository stores information about the data in data warehouses, data marts, operational databases or SAP BW cubes as business definitions with familiar names. The repository provides consistent use and reporting of information across the organization regardless of interface. Changes are easy to implement, often without needing costly changes in the data warehouse. Deployment is instantaneous to all users accessing the BI application.

Build Versatile Applications Quickly

MicroStrategy Architect is the only tool in the industry that can create business intelligence applications against terabyte-sized data warehouses based on any industry business model. Unlike other solutions that bind the database model directly to the application, MicroStrategy Architect maintains a rich abstraction layer that separates the distinct requirements of business intelligence solutions from the definition of the physical database schema.

Data is Accessible to All Users

Without an intelligent layer between the database and the data consumer, it is difficult to provide insight to a large user community. MicroStrategy Architect translates operational data into terms familiar to business users through a rich metadata layer. This allows the users to navigate through their data quickly using familiar business phrases. MicroStrategy metadata provides ultimate flexibility by supporting a broad range of physical and data schemas and operating with any relational database platform. Support for a wide range of advanced business intelligence schemas ensures that systems will meet any analysis requirement.

Simplified Development

MicroStrategy Architect’s convenient database reference utility lets developers view column names and data types for any table in the data warehouse. MicroStrategy Architect speeds application development by evaluat-ing definitions in the logical model. Database Administrators are automatically supplied with a list of recommended tables and columns from the warehouse when defining business variables. Advanced data models are simplified thanks to MicroStrategy Architect’s flexible schema support definitions. Single columns, compound keys or user-defined expressions can be used to define business intelligence objects.

Reduced System Maintenance

MicroStrategy Architect converts the error-prone and time-consuming task of creating metadata into a highly reliable, automated process. All business terms are centrally stored in the metadata repository and the MicroStrategy metadata is self-maintained, to there is no need for administrators to manage an additional database or write SQL. Application designers and report developers can centrally update the metadata, and changes are immediately and transparently propagated to all business users, eliminating unneeded complexity. MicroStrategy Architect’s automated error checking identifies and notifies designers to possible specification errors in the schema layer definitions. MicroStrategy Architect generates complete documentation of the system configuration and the data warehouse. It also facilitates change management by insulating BI applications from any changes in the data sources. This lowers system maintenance and reduces costs.