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.
|Published (Last):||26 November 2016|
|PDF File Size:||14.72 Mb|
|ePub File Size:||10.13 Mb|
|Price:||Free* [*Free Regsitration Required]|
Threshold testing 9 Explain what is Microstrategy Narrowcast server? 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.
File set consists of total tables and information while data-set consists of attributes, metrics of a particular report only. 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 security and with Novell directory. Due to that users who have logged into these systems does not have to log on again.
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.
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. 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.
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. 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. Microstrategy Microstrategy is based on single meta-data repository Microstrategy can be operated as web based and a desktop tool There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically Microstrategy reporting is fast Cognos has two meta-data repository based database It can be used as web-base reporting tools Cognos has a cube dataset which needs to be refreshed in order to get current repository values before reporting Compare to Microstrategy, Cognos reporting is slow 19 Explain how you can create the intelligent cubes in Microstrategy?
Intelligent cubes can be made in Microstrategy in the public folder or a particular user folder We can make a report and point the report to a cube or right click in a folder and select the cube option to make a new cube Once the cube is created, select the report objects which is required and save the cube Once the cube is stored and ran to check, one can create multiple reports out of a cube You can also add new attributes and metrics, whenever necessary, and those will be readily available when you run the reports next time 20 Explain how you can optimize a report in Microstrategy?
Various types of attributes in Microstrategy desktop include, Implicit Attributes.
Top 42 Microstrategy Interview Questions & Answers
A friend forwarded some more interview questions regarding MicroStrategy, but this time with answers. What are Logical Views used for? Once these Logical views are created, they are available to the report designer in a way similar to any other table. This allows developers to model attributes and facts whose expressions span multiple tables. By editing the projectsources. Difference between standard, absolute and ignore condition in metrics? Standard filtering allows the report filter to affect the metric.
MicroStrategy Interview Questions
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.
Top Microstrategy Interview Questions And Answers
Threshold testing 9 Explain what is Microstrategy Narrowcast server? 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. File set consists of total tables and information while data-set consists of attributes, metrics of a particular report only. 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 security and with Novell directory.
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.