Ans: There are actually three products that are highly useful for this approach and they are Microstrategy Desktop, Microstrategy Web and Microstrategy Office. Generally, they are deployed together but the users are free to keep up the pace whenever they want to utilize the individual one. Ans: Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. It is capable to deal with the high formatted reports and this is one of the best things about this application. In addition to this, many businesses are adopting it because of no other reason than having some of the effective and interactive dashboards in it. Ans: The Report Limit defines the total criterion which is considered when it comes to imposing a limit on the data which is generally returned in the date set.
|Published (Last):||7 September 2015|
|PDF File Size:||15.12 Mb|
|ePub File Size:||20.13 Mb|
|Price:||Free* [*Free Regsitration Required]|
Question The main thing that is achieved by the trimming is the removal of the unwanted cross joins and the other complex operations Question Answer : The Cognos has the two metadata repository based database, while the microstrategy is based on single metadata repository. The Cognos has only a web based reporting tool, while the microstrategy can be operated as a webbased and a desktop tool.
Cognos has a cube dataset which has to be refreshed to get latest repository values before reporting. The microstrategy has no cube dataset and we get the latest data from the data warehouse automatically available. The Cognos reporting can be considerably slow in performance than the microstrategy reporting. Answer : Compound metrics are the ones that are derived by some specific expression involving the different simple metrics.
Smart metrics is when the compound metric is calculated with the help of subtotal calculations for every element inside the compound metric. What Are Logical Views? How Are They Useful? Answer : The logical views help in establishing a specific view based on the combination of facts, attributes and expressions that are based on values from multiple tables.
This can be done without the actual modification to the actual physical database or the DBA involvement. This way the reporting can be altered at the highest level of application and can be very quick way to alterations for reporting. Answer : The MSTR operates in such a way that the incoming queries and data retrievals are done from the table which has the least logical size.
Thus if we prefer a specific table to be the center of activity then we should try to reduce the logical size of that specific table so that it becomes considerably lesser than the other tables.
Answer : Report filters: report filters are the conditions that accompany the report generating SQL statements. The report definitions have the filters as part of their definition. View Filters: View Filters are the conditions that come into play before a specific result is presented to the user.
Thus the view filters are not part of the SQL statements like report definitions, rather they are the filters applied after the execution of the SQL statements, after the data is retrieved from the data warehouse. Answer : The parent-child relationship helps in establishing the hierarchical structure to the entire logic and business model.
For example, you can have the quarter to be a child of a specific year attribute. This will help us in having a modularized approach in the design and will help in establishing common usage semantics. The various types of relationships can be one to one, many to one, many to many, one to many relationships. Answer : The number of passes represents the number of times the SQL query has to be parsed and different parts of the query is handled for every pass.
The fewer passes we have the more efficient the query executes and faster the reports are generated. Answer : The custom groups are the made up of what are called as custom group elements and together they act as a special filter that can be implemented over a specific template.
Consolidations refer to the way in which you group or order the data in your report. The different attributes can be gathered together without changing the underlying metadata and ware housing structure Question How Are Reports Optimized?
Answer : The objects maps are the ones that are used to select the group of microstrategy objects that are used to generate the report. This can serve as the template or filter. Then optimizations to the various reports can be done by analysis of the VLDB properties and the customizations can be monitored by the processing path taken up by the Anlytical engine Question What Are Attribute Roles?
Answer : The attributes that are single in definition but the instances of the attribute can behave differently according to the role they take. Example for this can be a database of airports around the world. The attribute of airport name is always based on the same database table but can be seen as a destination airport or source airport.
Such roles are resolved by having aliases for the same table, one alias for destination and one for source airports. We can also enable the automatic attribute role recognition by configuring it properly.
Answer : The command manger is the one through which you can manage the applications, user accesses, security and databases of the microstrategy. The command manager allows us to save the text commands that can be executed as scripts. Thus it can help in automation of the entire management process. Answer : The object manager is the one that copies groups of objects with all the attributes that are associated with it.
The project merge is used for copying the entire project along with all the objects. This is why it does not have to check for the attribute constraints before copying. The Object manager however has to make sure of the object attribute matches before copying the objects. The object manager cannot be run from the command prompt directly whilst the project merge can be run directly Question What Are Level Metrics?
Why Are They Needed? Answer : The level metrics are the metric calculation that are carried out over the specific attribute but at the different levels or dimensions. For example, the number of units sold is an attribute that we keep a count on. That metric can be calculated across time and region. Say number of units sold in last month and the number of units sold in specific region of the country.
Here the region and time are two different levels. Such level based metric give analytical inference as to the performance of the organization etc. Answer : The pass-through functions are the specific database oriented SQL statements and constructs that are executed by the microstrategy without checking semantics of the actual construct. They are called pass-through as they are not checked for correctness by the microstrategy as such. ApplySimple, Applycomparison are two pass through functions that microstrategy usually applies.
Answer : Column level security established by the imposing user specific access permissions in the database and having user specific connections. Entire set of objects can be secured by imposing folder and object level security. Row level security is imposed by having user specific security filters for various records. What Are The Vldb Properties? Answer : The Very Large Data Base properties is the configuration set that manages the overall way in which the database behaves and generates reports.
There are many such settings like check for cross joins, intermediate table creation and type etc. The highest precedence is given to the report level of configurations.
Microstrategy Advanced Interview Questions
Learn more about MicroStrategy Interview Questions in this blog post. What is star schema and snowflake schema? Star Schema is a highly denormalized schema whereas snowflake schema is highly normalized schema. Star schema is characterized by large number of rows in a table and less number of joins between tables. Snowflake schema is characterized by less number of rows in a table while more number of joins between tables. What are the advantages and disadvantages of star and snowflake schema?
Top Microstrategy Interview Questions And Answers
MicroStrategy platform can conceive multiple aspects like interactive dashboards, thresholds, and alerts, automated report distribution, highly formatted reports etc. Internal and external data can be analyzed thoroughly to make business decisions and helping with the development of mobile applications. Significant benefits with MicroStrategy is that it uses a single common metadata for consistency and streamlined maintenance. Metrics and attributes can be created only once, and then can be utilized across several types of reports. All required changes can be done at a single place, and concerned reports are updated automatically.
Microstrategy Interview Questions & Answers
Question The main thing that is achieved by the trimming is the removal of the unwanted cross joins and the other complex operations Question Answer : The Cognos has the two metadata repository based database, while the microstrategy is based on single metadata repository. The Cognos has only a web based reporting tool, while the microstrategy can be operated as a webbased and a desktop tool. Cognos has a cube dataset which has to be refreshed to get latest repository values before reporting. The microstrategy has no cube dataset and we get the latest data from the data warehouse automatically available. The Cognos reporting can be considerably slow in performance than the microstrategy reporting.