Explore topic-wise InterviewSolutions in .

A materialized view is a database object that contains the results of a query. They are local copies of data LOCATED remotely, or are used to create summary tables BASED on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots. A materialized view caches the query result as a concrete table that may be updated from the original base tables from time to time. Materialized views were implemented first by the ORACLE database. In IBM DB2, they are called “materialized query tables”; Microsoft SQL SERVER has a similar FEATURE called “indexed view”.

A materialized view is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots. A materialized view caches the query result as a concrete table that may be updated from the original base tables from time to time. Materialized views were implemented first by the Oracle database. In IBM DB2, they are called “materialized query tables”; Microsoft SQL Server has a similar feature called “indexed view”.

VLDB SETTINGS

VLDB settings

The MSTR calculates the table KEY and based on the key value it would use the appropriate FACT table. If it doesn't use the appropriate FACT table for some reason, we can include the reference called FACTID within the METRIC formula expression to indicate which FACT table to be used in that PARTICULAR metric.

The MSTR calculates the table key and based on the key value it would use the appropriate FACT table. If it doesn't use the appropriate FACT table for some reason, we can include the reference called FACTID within the Metric formula expression to indicate which FACT table to be used in that particular metric.

REMOVE ACCESS to the METRICS in ACL for the user/user-group

Remove access to the metrics in ACL for the user/user-group

SECURITY FILTERS

Security Filters

Cross-Joins can be prevented by SETTING the VLDB property that does not ALLOW to EXECUTE a cross-join

Cross-Joins can be prevented by setting the VLDB property that does not allow to execute a cross-join

Cross Joins OCCUR when unrelated attributes(attributes that are not RELATED to a METRIC or another ATTRIBUTE) are placed in a report

Cross Joins occur when unrelated attributes(attributes that are not related to a metric or another attribute) are placed in a report

Views are created in such SCENARIOS where we need a "Distinct attribute LOOKUP table" or "Attribute FORM expression across multiple tables" or "Slowly Changing Dimensions" ETC

Views are created in such scenarios where we need a "Distinct attribute lookup table" or "Attribute form expression across multiple tables" or "Slowly Changing Dimensions" etc

Datamarts to create aggregate/summary tables at higher levels of a hierarchies. Addition of Indexes to tables for faster execution of queries. Factors to DECIDE on aggregate tables If a large SET of reports need to be viewed at a level(a level that is higher than that of the existing Fact tables USED by those reports) then it is worth creating aggregate tables at that level. Or if a report is huge and it is critical for the business DECISIONS then it is worth creating the aggregate tables for that report

Datamarts to create aggregate/summary tables at higher levels of a hierarchies. Addition of Indexes to tables for faster execution of queries. Factors to decide on aggregate tables If a large set of reports need to be viewed at a level(a level that is higher than that of the existing Fact tables used by those reports) then it is worth creating aggregate tables at that level. Or if a report is huge and it is critical for the business decisions then it is worth creating the aggregate tables for that report

MicroStrategy offers out-of-the BOX TEMPLATES that provide a great starting point for dashboard DESIGNERS. Each template contains a series of containers, or panel stacks, that ENABLE users to quickly ADD components to each panel stack, such as: text boxes, shapes, reports, grids, graphs, panel stacks, HTML containers, selectors, and widgets. Also, pre-formatted customized templates can be created to place the design experience in the hands of end-users. These pre-formatted templates can include the corporate logo and color layout. Users can simply drag, drop, and select dashboard components to quickly design a dashboard in the matter of minutes.

MicroStrategy offers out-of-the box templates that provide a great starting point for dashboard designers. Each template contains a series of containers, or panel stacks, that enable users to quickly add components to each panel stack, such as: text boxes, shapes, reports, grids, graphs, panel stacks, HTML containers, selectors, and widgets. Also, pre-formatted customized templates can be created to place the design experience in the hands of end-users. These pre-formatted templates can include the corporate logo and color layout. Users can simply drag, drop, and select dashboard components to quickly design a dashboard in the matter of minutes.

Only one design of the DASHBOARD is required. FLASH-ADVANCED visualizations have flash plug-ins that are maintained within the container of the advanced visualization. Flash-advanced visualizations can be rendered in both Flash and DHTML, and the same controls are made available to users, ENABLING a seamless integration between Flash and DHTML design.

Only one design of the dashboard is required. Flash-advanced visualizations have flash plug-ins that are maintained within the container of the advanced visualization. Flash-advanced visualizations can be rendered in both Flash and DHTML, and the same controls are made available to users, enabling a seamless integration between Flash and DHTML design.

Users have the ability to DRILL within the document, drill ANYWHERE, or disable drilling. Drilling capabilities can be applied to a grid or graph, enabling users to perform an investigative analysis directly on a dashboard, scorecard, or ENTERPRISE REPORT. Users can drill out of the dashboard to investigate across the data warehouse or multiple data sources and generate new information-rich reports.Using the multi-select feature, business users can dynamically select any group of elements and create derived ELEMENT groups on the fly. Elements can be removed or added dynamically and users can create their own calculations between various groups or individual items

Users have the ability to drill within the document, drill anywhere, or disable drilling. Drilling capabilities can be applied to a grid or graph, enabling users to perform an investigative analysis directly on a dashboard, scorecard, or enterprise report. Users can drill out of the dashboard to investigate across the data warehouse or multiple data sources and generate new information-rich reports.Using the multi-select feature, business users can dynamically select any group of elements and create derived element groups on the fly. Elements can be removed or added dynamically and users can create their own calculations between various groups or individual items

Users have the ability to maintain SEPARATE documents and combine them into a SINGLE, FINALIZED document (report book, statement, or dashboard book). The individual documents can be maintained by different users and they can have the following unique qualities:
• Page groupings
• LAYOUT
• Page Orientation
• Vertical or horizontal repeating sections
• Conditional formatting
• Pagination
• Datasets
Enabling users to group together multiple documents into one makes it significantly easier to develop and maintain individual pieces of the unified document

Users have the ability to maintain separate documents and combine them into a single, finalized document (report book, statement, or dashboard book). The individual documents can be maintained by different users and they can have the following unique qualities:
• Page groupings
• Layout
• Page Orientation
• Vertical or horizontal repeating sections
• Conditional formatting
• Pagination
• Datasets
Enabling users to group together multiple documents into one makes it significantly easier to develop and maintain individual pieces of the unified document

Yes. MicroStrategy INTELLIGENCE Server uses XML to TRANSFER data. This enables organizations to present information from Intelligence Server to end users through multiple mediums INCLUDING the Web, email and web services

Yes. MicroStrategy Intelligence Server uses XML to transfer data. This enables organizations to present information from Intelligence Server to end users through multiple mediums including the Web, email and web services

Yes. MicroStrategy INTELLIGENCE Server can execute multiple reports SIMULTANEOUSLY. When REPORT results are READY they are saved in a personal HISTORY folder

Yes. MicroStrategy Intelligence Server can execute multiple reports simultaneously. When report results are ready they are saved in a personal History folder

MicroStrategy Intelligence Server can access data in all major databases including Oracle®, IBM DB2®, Microsoft® SQL Server, Microsoft Access®, Microsoft Excel®, Teradata®, Sybase®, Red Brick®, Informix®, HP NeoView, HP NonStop SQL/MP, Netezza®, MySQL, PostgreSQL, GREENPLUM, Kognito, Vertica, Aster nCluster, text files, and other ANSI-92 compatible RELATIONAL databases. It can also access multidimensional data SOURCES such as SAP BW, HYPERION Essbase, and Microsoft Analysis Services. Additionally, Intelligence Server can access data from EII sources including Composite, Oracle Transparent Gateways, IBM WebSphere Information Integrator, and MetaMatrix

MicroStrategy Intelligence Server can access data in all major databases including Oracle®, IBM DB2®, Microsoft® SQL Server, Microsoft Access®, Microsoft Excel®, Teradata®, Sybase®, Red Brick®, Informix®, HP NeoView, HP NonStop SQL/MP, Netezza®, MySQL, PostgreSQL, Greenplum, Kognito, Vertica, Aster nCluster, text files, and other ANSI-92 compatible relational databases. It can also access multidimensional data sources such as SAP BW, Hyperion Essbase, and Microsoft Analysis Services. Additionally, Intelligence Server can access data from EII sources including Composite, Oracle Transparent Gateways, IBM WebSphere Information Integrator, and MetaMatrix

MicroStrategy INTELLIGENCE Server is the ANALYTICAL server that processes all requests from all MicroStrategy end users. Intelligence Server is the central PRODUCT that links all MicroStrategy COMPONENTS to the data warehouse

MicroStrategy Intelligence Server is the analytical server that processes all requests from all MicroStrategy end users. Intelligence Server is the central product that links all MicroStrategy components to the data warehouse

Yes. MICROSTRATEGY INTELLIGENCE Server easily integrates with your EXISTING data structure with its support for the major types of schemas like Star, SNOWFLAKE, Hybrid, Denormalized, NORMALIZED and Aggregated Schema. MicroStrategy Intelligence Server also integrates with SAP® BW InfoCubes and QueryCubes.

Yes. MicroStrategy Intelligence Server easily integrates with your existing data structure with its support for the major types of schemas like Star, Snowflake, Hybrid, Denormalized, Normalized and Aggregated Schema. MicroStrategy Intelligence Server also integrates with SAP® BW InfoCubes and QueryCubes.

MicroStrategy Intelligence SERVER installs in MINUTES and automatically presents a configuration wizard to CONNECT to the database. Within an hour, the INSTALLATION and setup can be completed

MicroStrategy Intelligence Server installs in minutes and automatically presents a configuration wizard to connect to the database. Within an hour, the installation and setup can be completed

MicroStrategy Intelligence Server wins over its competitors because it solves all issues that corporations FACE when implementing a QUERY, reporting and analysis solution. MicroStrategy Intelligence Server provides the solutions required for a successful enterprise business intelligence SYSTEM: full range of analysis, SUPPORT for any number of USERS, support for any amount of data, iron-clad security, world-class reliability, easy administration and maintenance, and high performance.

MicroStrategy Intelligence Server wins over its competitors because it solves all issues that corporations face when implementing a query, reporting and analysis solution. MicroStrategy Intelligence Server provides the solutions required for a successful enterprise business intelligence system: full range of analysis, support for any number of users, support for any amount of data, iron-clad security, world-class reliability, easy administration and maintenance, and high performance.

YES, MicroStrategy Intelligence Server SUPPORTS time-based and event-based SCHEDULES. These schedules automatically trigger report execution and place a notification MESSAGE in the user's History folder UPON completion.

Yes, MicroStrategy Intelligence Server supports time-based and event-based schedules. These schedules automatically trigger report execution and place a notification message in the user's History folder upon completion.

YES. MicroStrategy Intelligence Server integrates with other system management software. In fact, all inner statistics of Intelligence Server are PUBLISHED to Performance Monitor and DIAGNOSTIC logs. As a result, third-party system management software such as IBM® Tivoli® or CA's Unicenter® can REMOTELY monitor these statistics

Yes. MicroStrategy Intelligence Server integrates with other system management software. In fact, all inner statistics of Intelligence Server are published to Performance Monitor and diagnostic logs. As a result, third-party system management software such as IBM® Tivoli® or CA's Unicenter® can remotely monitor these statistics

MicroStrategy INTELLIGENCE Server is AVAILABLE in ENGLISH (US and UK), French, German, Spanish, Italian, Portuguese (BRAZILIAN), Swedish, Chinese (Simplified and Traditional), Korean and Japanese

MicroStrategy Intelligence Server is available in English (US and UK), French, German, Spanish, Italian, Portuguese (Brazilian), Swedish, Chinese (Simplified and Traditional), Korean and Japanese

MicroStrategy has both Windows- and UNIX-based ADMINISTRATION tools. UNIX and Linux administration is provided through a Java-based CONTROL CENTER. Both the Windows administration tools and the Java-based Control Center provide local or remote administration and monitoring of all INTELLIGENCE Servers in the BI implementations

MicroStrategy has both Windows- and UNIX-based administration tools. UNIX and Linux administration is provided through a Java-based Control Center. Both the Windows administration tools and the Java-based Control Center provide local or remote administration and monitoring of all Intelligence Servers in the BI implementations

Yes. MicroStrategy Intelligence Server's CENTRALIZED architecture PROVIDES one console from which all maintenance and administration can be performed. In addition, a standardized data dictionary for enterprise reporting and OLAP analysis is stored in a metadata REPOSITORY and ENABLES REUSABLE reporting objects and business rules.

Yes. MicroStrategy Intelligence Server's centralized architecture provides one console from which all maintenance and administration can be performed. In addition, a standardized data dictionary for enterprise reporting and OLAP analysis is stored in a metadata repository and enables reusable reporting objects and business rules.

Yes. MICROSTRATEGY Intelligence Server integrates with LDAP and Windows security systems. Users will only NEED to login with their LDAP or Windows login to ACCESS MicroStrategy PROJECTS through Intelligence Server

Yes. MicroStrategy Intelligence Server integrates with LDAP and Windows security systems. Users will only need to login with their LDAP or Windows login to access MicroStrategy projects through Intelligence Server

MicroStrategy Intelligence Server provides a highly robust security model at four different layers in your system:

1. User level - Login and ID authentication ensure USERS have authorization to access the MicroStrategy system.
2. Application level - Access control lists and user PRIVILEGES ensure proper access to MicroStrategy objects and FUNCTIONALITY.
3. Data transmission level - ENCRYPTION and dual firewall configuration ensure safe transmission of data.
4. Data level - Security filters ensure users access only the data they have authorization to view.

MicroStrategy Intelligence Server provides a highly robust security model at four different layers in your system:

Yes. MicroStrategy Intelligence Server allows enterprises to integrate their HOMEGROWN FUNCTIONS as well as third-party software using an advanced plug-and-play architecture. Predictive Models created by third-party data mining software can also be imported using PMML (Predictive Markup LANGUAGE).

Yes. MicroStrategy Intelligence Server allows enterprises to integrate their homegrown functions as well as third-party software using an advanced plug-and-play architecture. Predictive Models created by third-party data mining software can also be imported using PMML (Predictive Markup Language).

MicroStrategy Intelligence Server users can easily perform SIMPLE to sophisticated analysis such as BASIC PERFORMANCE indicators, market basket, churn, retention and decile analysis. Users can make use of a complete library of statistical, mathematical, FINANCIAL and OLAP functions. Other types of analysis include HYPOTHESIS testing, regressions, neural networks, decision tress, clustering and bond calculations

MicroStrategy Intelligence Server users can easily perform simple to sophisticated analysis such as basic performance indicators, market basket, churn, retention and decile analysis. Users can make use of a complete library of statistical, mathematical, financial and OLAP functions. Other types of analysis include hypothesis testing, regressions, neural networks, decision tress, clustering and bond calculations

Yes. MicroStrategy Intelligence Server maximizes system performance at all layers of your system. Intelligence Server:
• Leverages the unique strengths of each database software and hardware using VLDB drivers.
• Uses four levels of REPORT and dataset CACHING to optimize performance for documents, reports, analyses and prompt lists.
• Increases analytic performance with its INTELLIGENT Cubes. Users or administrators can schedule creation or refreshing of Intelligent Cubes during low usage time PERIODS.
• Minimizes network traffic by sending users only the result sets they want to VIEW.

Yes. MicroStrategy Intelligence Server maximizes system performance at all layers of your system. Intelligence Server:
• Leverages the unique strengths of each database software and hardware using VLDB drivers.
• Uses four levels of report and dataset caching to optimize performance for documents, reports, analyses and prompt lists.
• Increases analytic performance with its Intelligent Cubes. Users or administrators can schedule creation or refreshing of Intelligent Cubes during low usage time periods.
• Minimizes network traffic by sending users only the result sets they want to view.

YES. MicroStrategy Intelligence Server PROVIDES complete fault TOLERANCE and fail-over support to MAXIMIZE the uptime of your application

Yes. MicroStrategy Intelligence Server provides complete fault tolerance and fail-over support to maximize the uptime of your application

Yes. MicroStrategy INTELLIGENCE Server provides out-of-the-box clustering CAPABILITIES that ALLOW corporations to leverage their initial investments and gradually scale as more users and DATA are added to the system, or when different styles of BI are REQUIRED

Yes. MicroStrategy Intelligence Server provides out-of-the-box clustering capabilities that allow corporations to leverage their initial investments and gradually scale as more users and data are added to the system, or when different styles of BI are required

Yes. MicroStrategy Intelligence SERVER can SCALE to any AMOUNT of data by leveraging your database's STRENGTHS. Using Very Large Database (VLDB) drivers, MicroStrategy Intelligence Server automatically tunes its operations to LEVERAGE the unique strengths of your database software and hardware.

Yes. MicroStrategy Intelligence Server can scale to any amount of data by leveraging your database's strengths. Using Very Large Database (VLDB) drivers, MicroStrategy Intelligence Server automatically tunes its operations to leverage the unique strengths of your database software and hardware.

INTELLIGENT Cubes are in-memory caches STORED by the Intelligence Server. While accessing an Intelligent Cube, USERS can easily add or remove report objects (such as attributes and METRICS), add NEW metric calculations and filter their view of the data -- all in an ad hoc fashion with speed-of-thought response times. Data stored outside an Intelligent Cube is automatically accessed using the ROLAP engine when drilling to more details

Intelligent Cubes are in-memory caches stored by the Intelligence Server. While accessing an Intelligent Cube, users can easily add or remove report objects (such as attributes and metrics), add new metric calculations and filter their view of the data -- all in an ad hoc fashion with speed-of-thought response times. Data stored outside an Intelligent Cube is automatically accessed using the ROLAP engine when drilling to more details

A cache CONTAINS the properties and data of a report once a report has been run. Caches can be stored in memory and/or on disk. When users ask for a report that is cached, the Intelligence Server will retrieve the data from disk or memory instead of running a query on the data source. Cache creation and usage securely LEVERAGES other users' work, INCREASES query performance and reduces the workload on the data WAREHOUSE

A cache contains the properties and data of a report once a report has been run. Caches can be stored in memory and/or on disk. When users ask for a report that is cached, the Intelligence Server will retrieve the data from disk or memory instead of running a query on the data source. Cache creation and usage securely leverages other users' work, increases query performance and reduces the workload on the data warehouse

Yes. MicroStrategy MultiSource Option is a new and fully integrated add-on component of MicroStrategy Intelligence SERVER. It ALLOWS users to seamlessly report, analyze, and monitor DATA across multiple SOURCES through a single business model

Yes. MicroStrategy MultiSource Option is a new and fully integrated add-on component of MicroStrategy Intelligence Server. It allows users to seamlessly report, analyze, and monitor data across multiple sources through a single business model

Yes. Every component of a BI APPLICATION can be TRANSLATED and presented in multiple languages, including all MicroStrategy user interfaces, metadata objects such as the NAMES of REPORTS and documents, and data within a data WAREHOUSE.

Yes. Every component of a BI application can be translated and presented in multiple languages, including all MicroStrategy user interfaces, metadata objects such as the names of reports and documents, and data within a data warehouse.

No, business users can RUN any query without learning any programming languages or DATABASE syntax. MicroStrategy Intelligence Server automatically and appropriately PROCESSES all business questions by accessing a report cache or Intelligent CUBE, or by generating DYNAMIC SQL or MDX that is optimized to each data source platform

No, business users can run any query without learning any programming languages or database syntax. MicroStrategy Intelligence Server automatically and appropriately processes all business questions by accessing a report cache or Intelligent Cube, or by generating dynamic SQL or MDX that is optimized to each data source platform

A BI application can access much greater memory resources when running on a 64-bit systems than it could on a 32-bit system. More addressable memory RESULTS in more BI applications, more sophisticated applications, more reports, larger reports, better performance and more users -- all with fewer servers. Organizations can combine MicroStrategy's industry leading SCALABILITY with the advantages of 64-bit UNIX to deploy the RICHEST BI applications, with the HIGHEST performance and the most users

A BI application can access much greater memory resources when running on a 64-bit systems than it could on a 32-bit system. More addressable memory results in more BI applications, more sophisticated applications, more reports, larger reports, better performance and more users -- all with fewer servers. Organizations can combine MicroStrategy's industry leading scalability with the advantages of 64-bit UNIX to deploy the richest BI applications, with the highest performance and the most users

Yes. MICROSTRATEGY Intelligence Server provides an industry first -- a common code BASE architecture for all supported 32- and 64-bit OPERATING systems. This single code base ensures that the latest functionality is always AVAILABLE on all these operating systems at the same time.

Yes. MicroStrategy Intelligence Server provides an industry first -- a common code base architecture for all supported 32- and 64-bit operating systems. This single code base ensures that the latest functionality is always available on all these operating systems at the same time.

MICROSTRATEGY Intelligence SERVER is engineered to be platform-independent on a single code base and is simply compiled appropriately for each certified operating system. As a RESULT, MicroStrategy can release Intelligence Server on all certified operating systems at the same time with the same FEATURES

MicroStrategy Intelligence Server is engineered to be platform-independent on a single code base and is simply compiled appropriately for each certified operating system. As a result, MicroStrategy can release Intelligence Server on all certified operating systems at the same time with the same features

MicroStrategy INTELLIGENCE Server is certified on Windows, UNIX, and Linux operating systems. MicroStrategy Intelligence Server has been designed to be a completely open architecture BUILT on industry standards and COMPILED to RUN on multiple operating systems

MicroStrategy Intelligence Server is certified on Windows, UNIX, and Linux operating systems. MicroStrategy Intelligence Server has been designed to be a completely open architecture built on industry standards and compiled to run on multiple operating systems

MicroStrategy Intelligence Server PROVIDES one centralzed architecture for all users' monitoring, reporting and analysis requirements. MicroStrategy Intelligence Server ALSO provides SCALABILITY to analyze any amount of data, SUPPORT for any number of users and a 24 X 7 operating environment, with robust security

MicroStrategy Intelligence Server provides one centralzed architecture for all users' monitoring, reporting and analysis requirements. MicroStrategy Intelligence Server also provides scalability to analyze any amount of data, support for any number of users and a 24 X 7 operating environment, with robust security

MicroStrategy Intelligence Server provides reporting and OLAP analysis for the WHOLE enterprise. All BUSINESS users can obtain scorecards and dashboards, operational reports, queries and OLAP and predictive ANALYSES without learning any PROGRAMMING or database syntax.

MicroStrategy Intelligence Server provides reporting and OLAP analysis for the whole enterprise. All business users can obtain scorecards and dashboards, operational reports, queries and OLAP and predictive analyses without learning any programming or database syntax.

There is no technical hard limit on the maximum NUMBER of cluster NODES that can be supported by MicroStrategy Intelligence SERVER 7.0. However, when the number of nodes increases, there is increasing overhead put on the SYSTEM by the clustering software. So, there will be practical limits related to the hardware CONFIGURATION of the users' system

There is no technical hard limit on the maximum number of cluster nodes that can be supported by MicroStrategy Intelligence Server 7.0. However, when the number of nodes increases, there is increasing overhead put on the system by the clustering software. So, there will be practical limits related to the hardware configuration of the users' system

MicroStrategy 7.0 does not support running multiple instances of MicroStrategy Intelligence Server on the same Microsoft Windows NT MACHINE. This is because MicroStrategy Intelligence Server can support running multiple projects with different prioritization and CONFIGURATION settings on one server. This functionality was not available in MicroStrategy DSS Server 5.x and THUS, required running multiple instances of MicroStrategy Intelligence Server to ACCOMPLISH the same functionality

MicroStrategy 7.0 does not support running multiple instances of MicroStrategy Intelligence Server on the same Microsoft Windows NT machine. This is because MicroStrategy Intelligence Server can support running multiple projects with different prioritization and configuration settings on one server. This functionality was not available in MicroStrategy DSS Server 5.x and thus, required running multiple instances of MicroStrategy Intelligence Server to accomplish the same functionality

MICROSOFT Cluster Server (MSCS) can be used for failover of MicroStrategy Intelligence Server. HOWEVER, MSCS and other third-party clustering software will not PROVIDE the load-balancing and some of the failover capabilities of MicroStrategy Intelligence Server's NATIVE clustering solution

Microsoft Cluster Server (MSCS) can be used for failover of MicroStrategy Intelligence Server. However, MSCS and other third-party clustering software will not provide the load-balancing and some of the failover capabilities of MicroStrategy Intelligence Server's native clustering solution

WHENEVER a MicroStrategy INTELLIGENCE Server cluster node is stopped in any way besides EXPLICITLY shutting down the MicroStrategy Intelligence Server service, the node will automatically rejoin the cluster when the MicroStrategy Intelligence Server service is restarted. So, if the node crashes, then the node will rejoin the cluster automatically upon startup

Whenever a MicroStrategy Intelligence Server cluster node is stopped in any way besides explicitly shutting down the MicroStrategy Intelligence Server service, the node will automatically rejoin the cluster when the MicroStrategy Intelligence Server service is restarted. So, if the node crashes, then the node will rejoin the cluster automatically upon startup

MicroStrategy Intelligence Server 7.0 and MicroStrategy Intelligence Server 7.0 SP1 use TCP/IP when communicating between clusters. MicroStrategy Intelligence Server 7.1 will provide the option of using TCP/IP or UDP/IP (Universal Datagram PROTOCOL). In 7.2, UDP support was removed as packet loss AFFECTS cluster SYNCHRONIZATION

MicroStrategy Intelligence Server 7.0 and MicroStrategy Intelligence Server 7.0 SP1 use TCP/IP when communicating between clusters. MicroStrategy Intelligence Server 7.1 will provide the option of using TCP/IP or UDP/IP (Universal Datagram Protocol). In 7.2, UDP support was removed as packet loss affects cluster synchronization

Yes this is possible, using caution because users can configure DIFFERENT nodes at different settings. For example, differences in memory allocation for the cache, time out settings, ETC can RESULT in uneven performance ACROSS cluster nodes.

Yes this is possible, using caution because users can configure different nodes at different settings. For example, differences in memory allocation for the cache, time out settings, etc can result in uneven performance across cluster nodes.