Ans: Microstrategy is an enterprise business intelligence application software vendor. It supports scorecards, interactive dashboards, ad hoc query, high formatted reports, etc.
Ans: With OLAP services users can create a unique report views by removing or adding attributes and metrics contained within the intelligent cube. Without submitting a new request to the data warehouse, the new calculation is performed.
Ans: Intelligent cubes are generated automatically when a new report is run against the data warehouse. Users don’t have to mention the cube to which they want to connect. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Subsequently the requests made by other users can seamlessly hit this new intelligent cube.
Ans: End user product that delivers OLAP services includes
They all leverage the functionality enabled by OLAP services
Ans:
Ans:
Ans: Smart metric is referred when a compound metric is defined with other metric objects using arithmetic operations like sum M1/M2.
For example: Simple or Compound Metrics Total (profits/unit sold) Smart Metrics: Total (profit)/ Total (sold)
Ans: Microstrategy can carry out test like
Ans: Microstrategy Narrowcast Server is a software product which monitors and delivers individualized information to users through e-mails, web portals and wireless devices like pagers, PDAs, and phones. Users determine what information they want, when and how they want to receive it, through an easy to use web page.
Ans: File set consists of total tables and information while data-set consists of attributes, metrics of a particular report only.
Ans: Microstrategy provides many security options to make sure that data is kept private and confidential. To make easy access and minimum maintenance, Microstrategy desktop synchronize with Windows NT and 2000 security and with Novell directory. Due to that users who have logged into these systems does not have to log on again.
Ans: Schema objects are availed to create Application objects like Attributes, functions & operators, Hierarchies, Tables, etc. While, Public objects are used to create other application objects like Filters, Metrics, Consolidations, etc. Using architect permission schema object can be created while public object can be created by using a schema object only.
Ans: Listeners allows us to view the result of samplers in the form of trees, graphs, tables or simple text in some log files. They offer visual access to the data collected by JMeter about the test cases as a sampler component of JMeter is executed.
Ans: By creating separate table alias for the same or enabling the automatic attribute role recognition, you can resolve the attribute roles.
Ans: Microstrategy can calculate four of the primary data mining functions including network algorithm, regression algorithm, clustering algorithm and tree algorithm.
Ans: We can use alias name of that table and alter the logical size of that alias table dnt then modifies main table and use the alias table.
Ans: 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.
Ans:
| Microstrategy | Cognos |
|
|
Ans:
Ans: VLDB properties enable you to customize the SQL that Microstrategy produces, and determine how data is processed by the Analytical engine.
Ans: The process or roadmap that Microstrategy used for generating BI reports
Step 1) Connect to Database
Step 2) Create Metadata
Step 3) Create Databases ( in-memory ROLAP)
Step 4) Schedule ETL (Query Schedule)
Step 5) Create Reports and Dashboards
Ans: Various types of attributes in Microstrategy desktop include,
Ans:
| Custom group | Consolidations |
|
|
Ans: Intelligent Cubes are created automatically when a new report is run against the data warehouse. Users don’t have to determine the cube to which they want to connect. The logic to match user requests with the appropriate Intelligent Cube is automatically handled within the Microstrategy platform.
Ans: 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.
Ans: Yes. 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.
Ans: The algorithm supported by Microstrategy are,
Ans: Features that are not supported in Intelligent Cubes are,
Ans: The types of Report Cache include,
Ans: 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.
Ans:
A MicroStrategy is a ROLAP tool.
Ans: The difference is that,
Ans: 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.
Ans: 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.
Ans: The types of fact extensions in Microstrategy are,
Ans: When the fact is at a higher level than the report display level, then you can use fact degradation attribute to state how the Engine degrades the data to the lower level. When you lower the level at which a fact should be reported, you are using degradation.
Ans: You can restrict the number of elements in a prompt using a filter.
Ans:
Ans: The prompt is nothing but an attribute through which you can modify the contents of a report dynamically.
Ans: Different types of prompts are,
Ans:
| In memory ROLAP = ROLAP Architecture + Cube Architecture. |
In-memory ROLAP is an architectural extension of ROLAP in which physical ROLAP cubes resides in-memory within the Global Virtual Cube.
Ans: The advantage of in-memory ROLAP is that it improves user wait time and free up database capacity.