09 October, 2020
Ans: Microstrategy is a business enterprise application software that supports interactive dashboards, highly formatted reports, scorecards, threshold, ad hoc queries, alerts, and automated report distribution.
Ans: Microstrategy stores all the information about all Microstrategy objects in a repository called Metadata which is created in the Database.
Ans: Microstrategy objects are categorized into 3 kinds
I. Configuration objects: Configuration objects enable us to connect with warehouse databases using MicroStrategy architecture. This object contains crucial project information that is generated and maintained by managers.
II. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and metrics. This object helps to analyze relevant information that is maintained by developers.
III. Schema objects: Schema objects directed to warehouse database structures and the essential aspects of business intelligence application such as facts, attributes, and hierarchies are stored in schema objects.
Ans: A Compound key attribute is a primary key that is made up of two or more columns and these columns are joined with other attributes. It helps to merge or concat two columns in the same group.
Ans: In Microstrategy, facts are the numeric data and attributes are contextual data for the facts which are necessary to define a project. Facts are the data values stored in database columns which attribute define the data.
Ans: Online Analytical Processing (OLAP) is a multi-dimensional analysis of business intelligence. It helps to improve performance and analysis. It uses the concept of in-memory business intelligence.
Ans: The end products of OLAP service that delivers are:
Ans: Smart metric allows the user to change the default evaluation order of the metric. It calculates the subtotal elements of a compound metric.
Ans: Joint child helps to maintain the composite keys which are constituted with more or more columns as unique identifiers. The joint child helps to make a set of these columns constituting composite keys.
Ans: The algorithms which are supported by MicroStrategy are:
Ans: Different types of testing can be done in MicroStrategy are:
Ans: Logical views allow application architects to create the desired view of tables using MicroStrategy without DBA involvement. When a table is imported from the database to MicroStrategy through an architect tool, the table consists of a logic form which is known as a logic view.
Ans: The process for generating BI reports in Microstrategy as follows:
Ans: Architect is the data modeling tool used in MSTR
Ans: Very Large Database (VLDB) is the way of conducting database particulars preferences while creating SQL reports. The properties of VLDB are:
Ans: Intelligent cube is a set of data that can be shared as a single in-memory data among different reports created by users. The reports accessing intelligent cubes can use the features of OLAP services for analyzing and reporting.
Ans: Features that are not supported by intelligent cubes are:
OLAP services: Derived metrics and viewed filters cannot be supported
Ans: The advantages of cubes are:
Ans: Prompt allows us to determine how the reports return to the database from the warehouse. Prompt helps to apply filtering conditions to a report, a metric on the report, or a custom group on the report. It also helps to choose what objects such as attributes and metrics are included in the report.
Ans: In Microstrategy, there are three different fact extensions. They are:
Ans: Fact Degradation is designed to allow the user to lower the level of facts in the database.
For column level security, putting user specific restriction at the end of the database and using user-specific connection mapping
Applying folder level and object level security to restrict the access for a certain set of reports
Applying security levels to the filters provides row-level security
Ans: Filters are used to limit the data of the report. Different types of filters are:
Ans: The different types of cache are as follows:
Ans: Report filter is an object that appears before the report executes. It affects the SQL and appears in the Where clause.
Whereas, View filter is an OLAP feature which is an object that appears after the report execution. The results can be viewed in the database warehouse.
Ans: In-memory ROLAP is an Architectural extension of MicroStrategy tools in which the ROLAP cubes reside in-memory within virtual cubes.
In-memory= ROLAP Architecture+Cube Architecture.
Ans: The advantages of in-memory ROLAP are:
It improves user wait time. It free-up the database capacity.
Ans: Element cache is the table elements that are stored in memory on the intelligent server or Developer machines so that they can retrieve more quickly.
Ans: Microstrategy Desktop installs in minutes and automatically presents a list of available Microstrategy Intelligence Servers. Within an hour, the installation and setup are completed.
Ans: Microstrategy Desktop is the intuitive client-server interface used by business analysts and application developers. Microstrategy Desktop interacts with the Intelligence Server to build metrics, create and format reports, and retrieve timely, accurate information to the desktop to enhance the decision-making process.
Ans: Yes. This new Dynamic MDX Engine generates optimized MDX syntax that is fully certified with SAP BW using SAP’s high-performance BAPI interfaces.
Ans: Yes. Users can use Microstrategy Desktop to create reports that access SAP data and join data across SAP BW Info Cubes and Query Cubes as well as access multiple instances of SAP BW at once.
Inclined to build a profession as MicroStrategy Developer? Then here is the blog post on, explore MicroStrategy Training
Ans: Each Microstrategy Desktop user has a security profile defined by their administrator. This profile controls access to application functionality, specific reports, or particular data for individual users or groups of users. The Desktop interface will adapt and display only what this user is allowed to see
Ans: Yes. Microstrategy 8 extends the Microstrategy data modeling flexibility to include integrated views of data across heterogeneous data stores. By mapping conforming dimensions from different sources, Microstrategy Desktop can automatically join data from multiple different sources in the same report document. Data can come from any source accessible by Microstrategy 8, including the data warehouse, data marts, SAP BW, and any number of operational system databases.
Ans: Yes. Microstrategy 8 has extended its analytic engine with “Data Mining Services” capability that allows reports and analyses to include predictive capabilities in every Microstrategy report or analysis. Microstrategy 8 includes the new ability to import data mining models directly from best-of-breed data mining products from vendors like IBM, Teradata, SAS, and SPSS using the new PMML or predictive modeling mark-up language standard.[/sociallocker]
Ans: Microstrategy Narrowcast Server is a software product that monitors and delivers individualized information to users via email, web portals, and wireless devices such as PDAs, pagers, and phones. Through an easy-to-use web page, users specify what information they want, when and how they want to receive it.
Ans: Yes, with the appropriate version of Microstrategy Web or Desktop, certain functions leverage the Intelligent Cubes. These functions include: report formatting down to cell level, column aliasing, drilling, pivoting, page-by, adding metric thresholds, adding subtotals, ranking, and sorting. Please see the Web and Desktop version comparisons to determine exactly which Web or Desktop version includes the desired functionality.
Ans: Yes, OLAP Services is sold as a separate product that is installed with Microstrategy Intelligence Server. It is licensed either on a per-user or per-CPU basis.
For an in-depth understanding of MicroStrategy click on
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .