Share

Página Principal > Software > Development Tools: Architect > MicroStrategy Architect Product FAQs

MicroStrategy Architect™

Features | Benefits | FAQs

MicroStrategy Architect Product FAQs

  1. What is MicroStrategy Architect?
  2. What does MicroStrategy Architect allow users to do?
  3. What are the benefits of using MicroStrategy Architect?
  4. How easy is it to create new BI applications using MicroStrategy Architect?
  5. What happens if there are changes to my business definitions?
  6. Can I test my business model by running reports?
  7. What documentation capabilities are available in MicroStrategy Architect?
  8. What are the minimum requirements for MicroStrategy Architect?
  9. What database platforms can be mapped using MicroStrategy Architect?
  10. Is MicroStrategy Architect available in other languages?
  11. How long does it take to get MicroStrategy Architect up and running?
  12. How does MicroStrategy Architect integrate with the rest of the MicroStrategy platform?
  13. What types of schemas does MicroStrategy Architect support?
  14. Does MicroStrategy Architect provide the ability to join keys that do not follow any sort of standard naming conventions across tables?
  15. How can I define complex business terms using MicroStrategy Architect?
  16. How do I model aggregate tables in MicroStrategy Architect?
  17. Does MicroStrategy Architect recognize partitioned fact tables?
  18. What are the VLDB (very large database) drivers?
  19. What are fact extensions?
  20. How are transformations used?
  21. What is special about MicroStrategy’s hierarchies?
  22. Does MicroStrategy Architect support modeling of heterogeneous data sources?

1. What is MicroStrategy Architect?

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.

2. What does MicroStrategy Architect allow users to do?

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.

3. What are the benefits of using MicroStrategy Architect?

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.

4. How easy is it to create new BI applications using MicroStrategy Architect?

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.

5. What happens if there are changes to my business definitions?

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.

6. Can I test my business model by running reports?

MicroStrategy Architect integrates directly with MicroStrategy Desktop. Business terms can be defined and tested without leaving the Desktop application.

7. What documentation capabilities are available in MicroStrategy Architect?

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

8. What are the minimum requirements for MicroStrategy Architect?

Minimum requirements are a computer with at least a 1GHz Pentium-compatible CPU, 1GB of RAM and 1GB of hard disk.

9. What database platforms can be mapped using MicroStrategy Architect?

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.

10. Is MicroStrategy Architect available in other languages?

MicroStrategy Architect is available in English, French, German, Spanish, Korean, Italian, Swedish, Chinese, Japanese and Portuguese.

11. How long does it take to get MicroStrategy Architect up and running?

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.

12. How does MicroStrategy Architect integrate with the rest of the MicroStrategy platform?

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.

13. What types of schemas does MicroStrategy Architect support?

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.

15. How can I define complex business terms using MicroStrategy Architect?

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.

16. How do I model aggregate tables in MicroStrategy Architect?

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.

17. Does MicroStrategy Architect recognize partitioned fact 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.

18. What are the VLDB (very large database) properties?

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.

19. What are fact extensions?

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.

20. How are transformations used?

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.

21. How do I model hierarchies or dimensions?

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.

22. Does MicroStrategy Architect support modeling of heterogeneous data sources?

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.