MicroStrategy Architect Product FAQs
- What is MicroStrategy Architect?
- What does MicroStrategy Architect allow users to do?
- What are the benefits of using MicroStrategy Architect?
- How easy is it to create new BI applications using MicroStrategy Architect?
- What happens if there are changes to my business definitions?
- Can I test my business model by running reports?
- What documentation capabilities are available in MicroStrategy Architect?
- What are the minimum requirements for MicroStrategy Architect?
- What database platforms can be mapped using MicroStrategy Architect?
- Is MicroStrategy Architect available in other languages?
- How long does it take to get MicroStrategy Architect up and running?
- How does MicroStrategy Architect integrate with the rest of the MicroStrategy platform?
- What types of schemas does MicroStrategy Architect support?
- Does MicroStrategy Architect provide the ability to join keys that do not follow any sort of standard naming conventions across tables?
- How can I define complex business terms using MicroStrategy Architect?
- How do I model aggregate tables in MicroStrategy Architect?
- Does MicroStrategy Architect recognize partitioned fact tables?
- What are the VLDB (very large database) drivers?
- What are fact extensions?
- How are transformations used?
- What is special about MicroStrategy’s hierarchies?
- Does MicroStrategy Architect support modeling of heterogeneous data sources?
MicroStrategy Architect is a rapid development application that maps the physical structure of your database to a logical business model stored in a centralized metadata repository. MicroStrategy Architect users work through a single consolidated interface to perform all tasks in an intuitive, visual way.
With MicroStrategy Architect, developers can design and maintain sophisticated business intelligence applications, at low cost and risk, in a comprehensive environment that is powerful, intuitive and secure. Through a single interface, developers can not only design an application but also assess the impact of any modeling or databases changes in real-time.
MicroStrategy Architect streamlines the project modeling process reducing application development time while reducing maintenance costs. An interactive and consolidated interface allows application developers to visually model projects thereby reducing application building time. Features such as automatic creation of project objects reduce modeling errors.
MicroStrategy Architect allows you to create everything in one consolidated interface. Intuitive features like right-click functionality make this an easy experience for all users, from novice to advanced, while other features like the heuristics algorithm drastically reduce creation time.
Our centralized object oriented metadata instantaneously propagates all changes to all users and reports without any additional action needed. In fact, this process is completely transparent to the business users.
MicroStrategy Architect integrates directly with MicroStrategy Desktop. Business terms can be defined and tested without leaving the Desktop application.
MicroStrategy Architect can print details about the physical database schema and logical data model defined in the metadata repository. This information can also be exported to Microsoft® Excel.
Technical Questions about MicroStrategy Architect
Minimum requirements are a computer with at least a 1GHz Pentium-compatible CPU, 1GB of RAM and 1GB of hard disk.
You can access data in all the major databases including Oracle, IBM DB2, Informix, NCR Teradata, Netezza, Microsoft Access, Microsoft SQL Server, Red Brick, Sybase and Non-Stop SQL.
MicroStrategy Architect is available in English, French, German, Spanish, Korean, Italian, Swedish, Chinese, Japanese and Portuguese.
MicroStrategy Architect installs in minutes, and can automatically connect to any of the available MicroStrategy Intelligence Servers. Within an hour, the installation and setup are completed.
MicroStrategy Architect is the intuitive client-server interface used by application developers to create business intelligence applications that can be accessed by all MicroStrategy’s products.
MicroStrategy Architect provides the widest range of schema support in the industry. Star, snowflake, normalized, and de-normalized schemas can be mapped with MicroStrategy Architect.
14. Does MicroStrategy Architect provide the ability to recognize different column names for a single object?
Yes. MicroStrategy Architect provides heterogeneous column naming functionality to address this. For example, an attribute DATE could use a column called DATE_ID in one set of tables and a column called ORDER_DATE in another set of tables. The administrator can define these to mean the same attribute DATE.
Business terms can be defined using single or multiple columns, compound keys, constants, and/or user-defined expressions through editors and wizards. Expressions can use arithmetic operators to relate multiple columns, or define those using specialized functions that allow MicroStrategy to perform calculations, even if the underlying database doesn't support them.
MicroStrategy Architect automatically identifies and calculates the correct level of granularity of the aggregate tables included in your model, and the SQL Engine dynamically references them when appropriate. No manual manipulation of fact definitions is necessary when using aggregate tables.
Yes. MicroStrategy Architect uses a partition mapping definition to identify partitioned fact tables, which are used to speed up database query performance. This definition can be stored either in a database table or directly in the metadata repository.
VLDB properties adjust MicroStrategy’s ROLAP Engine to generate optimized database specific SQL used to extract information from the data-source. There are over 90 parameters that can be modified.
Fact extensions lower the granularity of a fact based on an arithmetic expression, make a fact available to unrelated attributes, or disallow a certain fact to be calculated at particular attribute levels. This introduces considerable flexibility when designing data models and reduces the amount of data that needs to be stored in the data warehouse.
Transformations enable users to perform sophisticated time-series analysis across metrics by grouping and comparing data at different time periods. Reports that include current period, prior period and period-to-date comparisons are possible using a single metric definition and without needing to redefine the report filter.
Hierarchies represent a set of attributes with paths between them. The System Hierarchy contains the true relationships (i.e., parent-child) between all the attributes in the schema. The System Hierarchy is automatically defined when attributes are created and their relationships to related attributes are specified. MicroStrategy Architect provides a unique abstraction of hierarchies above the System Hierarchy called User Hierarchies, which can contain an arbitrary number of attributes and paths between them. These User Hierarchies allow users to browse through the data and drill as required by business needs, as opposed to how the data is physically stored in the data source.
Yes. MicroStrategy Architect will work with as many databases as you have to get the correct and pertinent data on your project. The databases show on the MicroStrategy Architect interface and the necessary tables from each are jointly included. You can use any and as many of the required data sources to create a report or document that meets your needs.