What is the difference between microstrategy 8 and 9

MicroStrategy desktop users can use the new operational SQL engine that includes data from any OS, with the help of entirely free-form SQL, which provides for stored procedures and views. Metadata in MicroStrategy is a repository that stores the MicroStrategy object definitions and data or information about the data warehouse. The information here is stored in a proletariat format within the relational database.

The metadata maps the MicroStrategy objects that are used to build and analyze reports to the data warehouse structure. Heterogeneous mapping in MicroStrategy allows the intelligence server to perform joins on different column names.

When you define more than one expression, heterogeneous mapping occurs automatically. For creating intelligent cubes, you need to use intelligent cube editor privilege, which is a part of OLAP services. The Degradation which lowers the fact-value is called Fact degradation. In order to view the Fact data at a lower logical level than the Fact is stored, you have to degrade the Fact to a lower level. For example, you have stored a Fact at a level, which is commonly used in reports.

At the same time, you should also support the users who want to view and analyze the same Fact data at a lower level. A key performance indicator in MicroStrategy is a visual representation of a performance indicator. In MicroStrategy 2 tier architecture, the MicroStrategy desktop queries, against the data warehouse and metadata itself, without the Intelligence Server intermediate tire.

The 3 tier structure in MicroStrategy consists of an Intelligence server between the MicroStrategy desktop, data warehouse, and the metadata.

The 4 tier architecture in MicroStrategy is the same as that of the 3 tier structure, where an additional Microstate Web component is included. Formula join type is defined as a metric that consists of multiple expressions or metrics, and it lets you determine how to join these elements. A view filter in MicroStrategy is used to restrict the amount of data that is displayed on the report by providing a different view of data. MicroStrategy object manager helps us to move objects across projects in MicroStrategy.

Standard filtering in MicroStrategy allows the report filters to interact in the metric calculation as usual. Here the metric calculates only for the elements that are found in the filtered definition. Absolute filtering in MicroStrategy changes the filters on the descendants of the targets.

If possible, it raises it to the level of the target. Ignore filtering in MicroStrategy. As the name suggests, it omits the filtering criteria. Based on the target attributes and their related attributes, i. With this setting, the report filter does not appear anywhere in the SQL. The project sources for MicroStrategy Web Services are described in the projectsources.

The project sources defined here also define which project sources the MicroStrategy Office users can connect to. Logical views in MicroStrategy are created manually to return the data from multiple physical tables as one standard logical table. You can resolve attribute Roles in MicroStrategy by creating separate table alias names for the same.

You can also enable automatic attribute Role recognition to determine the attribute Roles. Statistics tables are the tables that contain data on the MicroStrategy system usage and performance. They offer visual access to the data collected by JMeter about the test cases as a sampler component of JMeter is executed.

By creating separate table alias for the same or enabling the automatic attribute role recognition, you can resolve the attribute roles. Microstrategy can calculate four of the primary data mining functions including network algorithm, regression algorithm, clustering algorithm and tree algorithm.

You can insert and update or even a delete a record by using one of the components of Microstrategy known as an ODBC test tool. You can also alter table specification as per your need. Intelligent Cubes are created automatically when a new report is run against the data warehouse. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform. The business benefits of Microstrategy Narrowcast Server is that it provides an inexpensive way to send corporate information to untrained partners, employees, and customers.

Due to which decision makers have enough information to streamline a business process that will cut the operating costs. Microstrategy 8 have extended the data modeling flexibility to include integrated views of data across heterogeneous data stores. Data can come from anywhere- data warehouse, SAP BW, data marts, and any number of operational system databases.

By mapping conforming dimensions from various or different sources, Microstrategy Desktop can join data automatically from multiple unlike sources in the same report document. An Element Cache is most recently used lookup table elements that are stored in memory on the intelligence server or MSTR desktop machines.

So that it can be fetched more easily. Heterogeneous mapping enables the engine to perform joins on unlike column names. If the user determines more than one expression for a given form, the heterogeneous mapping will automatically take place when tables and column names require it. An Implicit attribute has its own expression. It is a virtual or constant attribute that does not physically exist in the database because it is created at the application level.

Filter Feed Refresh this feed. Skip Feed Nothing here yet? Author Paul Bradley Inactive. Number of Views 1. Number of Views 2. P12 certificate and key file into a.