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.
|Genre:||Health and Food|
|Published (Last):||4 June 2013|
|PDF File Size:||20.27 Mb|
|ePub File Size:||16.16 Mb|
|Price:||Free* [*Free Regsitration Required]|
Answer: Microstrategy is an enterprise business intelligence application software vendor. It supports scorecards, interactive dashboards, ad hoc query, high formatted reports, etc. Answer: MicroStrategy metadata consists of project settings, MicroStrategy object definitions and data warehouse connection information.
Answer: Firstly populate the metadata with project definition and schema objects, parameters and then make schema objects. Answer: 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. Answer: It allows the engine to do joins on unlike column names. If the user describe more than one expression for a given form, heterogeneous mapping will mechanically take place when tables and column names require it.
Answer: A compound attribute has its value resolute by an expression that join two or more columns in a database to make a new column. Answer: Report limit: It determines a set of criteria used to restrict or limit the data returned in the report data set after the report metrics are calculated Report Filter: It applies the where condition to the query sent to the warehouse to retrieve the results.
Answer : An implicit attribute is a practical or same attribute that does not actually exist in the database because it is made at the application level. Answer: A joint child is Microstrategy way of handling Composite Keys.
Composite keys are constituted of two or more columns which together act as unique identifier. To handle this case in Microstrategy we make this set of columns, constituting composite keys, as joint child. Answer: A user defines two attributes that have the same definition but play different roles in the business model. Both attributes share the same forms, or information about them Description, Location, etc.
Answer: When facts exist at a higher level than the report display level, you must specify how the Engine degrades the data to the lower level. When you lower the level at which a fact is reported, you are using degradation. Answer : Filter is used to restrict data in a report.
Answer: Security filter is used to apply security at the database data level. Whenever a users associated with security filter runs a report, a WHERE clause is always included in the report sql with the condition defined in the Security Filter. Answer : Level prompts enable you to specify the level of aggregation calculation of a metric. What are the different formatting types? Answer: 1. Font Type, Color 2. Background 3. Image 4. Text ………………. For more questions please contact us. Search for:.
Answer: Report limit: It determines a set of criteria used to restrict or limit the data returned in the report data set after the report metrics are calculated Report Filter: It applies the where condition to the query sent to the warehouse to retrieve the results 9 Write different kinds of objects in Microstrategy?
Answer : Filter is used to restrict data in a report 17 What is filtered prompt? Answer : We can restrict the number of elements in a prompt using a filter. Answer : Level prompts enable you to specify the level of aggregation calculation of a metric 20 Can Threshold be applied on attributes?
Top Microstrategy Interview Questions And Answers
Join the conversation in our Discussion forums, check the Gallery to see new content to try out, or share your thoughts in the Idea Exchange. Utilize video tutorials and product documentation to make the most of your MicroStrategy investment, or take a course and become a certified user. Utilize our case system to get in touch with Support or download the latest version of MicroStrategy products. We are so glad you are here! View our Guidelines and FAQ to learn more about how to use our site, or access quick links to helpful resources on our corporate site. Legacy User Customer asked a question. In which way you can write this type of script with the help of command manager
There are a lot of opportunities from many reputed companies in the world. According to research, MicroStrategy has a market share of about 4. So, You still have the opportunity to move ahead in your career in MicroStrategy Development. Business Intelligence is very important for any business which needs to tackle competition. It is important for deriving useful information or data for analyzing the same and deriving the most useful information to understand markets and competition.