Single Consolidated Interface for Application Design Streamlines Project Modeling and Reduces Deployment Time.

Architects can abstract tables from multiple data-sources and define the project model from a single interface. MicroStrategy Architect also provides the ability to automatically create project objects through advanced attribute and fact recognition algorithms thereby reducing application development time. The consolidated interface provides real-time access to warehouse tables and schema objects and propagates any changes instantly to all users, providing for a single version of the truth. Familiar functions such as drag-and-drop and right-click functionality make using the interface intuitive and easy to work with.
The central object-oriented metadata repository stores information about the data in data warehouses, data marts, operational databases or SAP cubes as business definitions with familiar names.

• The repository provides consistent use and reporting of information across the organization.
• Changes are easy to implement, often without needing costly changes in the data warehouse.
• Deployment is instantaneous to all users accessing the BI application.

All 5 Styles of BI can be accessed through one interface, without switching products.

Rapid Project Modeling

MicroStrategy Architect allows developers to model business intelligence applications faster than any competitor because of its highly interactive and intuitive user interface. All interaction centers on common motor functions such as right click and drag and drop reducing the time required to develop an application. Irrespective of the database, type and size, application developers can drag-and-drop the tables they need into the project. By right clicking a table, they have the option to automatically create attributes and facts. An exploded view of a selected object is provided from a Properties pane giving developers direct (or one click) access to any object property.

Heterogeneous Data-Sources are Accessible to All Users

Architect provides an abstraction layer between the database and the data consumer by translating the physical data schema into terms familiar to business users. The MicroStrategy metadata provides ultimate flexibility by supporting a broad range of databases and allowing users to create an application spanning multiple data sources. Support for a wide range of advanced business intelligence schemas such as star or snowflake ensures that systems will meet any analysis requirement.

Advanced Data Modeling 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 evaluating definitions in the logical model, supplying developers with a list of recommended tables and columns from all their databases, and automatically creating modeling objects with predefined rules.

Reduced System Maintenance

MicroStrategy Architect converts the error-prone and time-consuming task of creating metadata objects into a highly reliable, automated process. All business terms are centrally stored in the metadata repository and the MicroStrategy metadata is self-maintained, so 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 unnecessary complexity. MicroStrategy Architect’s automated error checking identifies and notifies designers to possible specification errors in the schema layer definitions. It also facilitates change management by insulating BI applications from any changes in the data sources. This lowers system maintenance and reduces costs.