MicroStrategy Interview Questions and Answers
Our experts providing MicroStrategy interview questions & Answers/Faqs can develop your carrier & knowledge to find the right job in a good MNC’s, doesn’t matter what kind of company you’re hired.
1) explain what is Microstrategy?
Answer: Microstrategy is an enterprise business intelligence application software vendor. It supports scorecards, interactive dashboards, ad hoc query, high formatted reports, etc.
2) Write the components MicroStrategy metadata?
Answer: MicroStrategy metadata consists of project settings, MicroStrategy object definitions and data warehouse connection information.
3) What are the programs that we can do with the MicroStrategy Architect?
Answer: Firstly populate the metadata with project definition and schema objects, parameters and then make schema objects.
4) Mention what specific features and functionality do you get with OLAP services?
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.
5) Explain heterogeneous mapping?
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.
6) Define compound attribute?
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.
7) List out the end user products that delivers OLAP Services?
Answer: End user product that delivers OLAP services includes
They all leverage the functionality enabled by OLAP services
8) Explain what is the difference between the Report filter and Report limit?
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: Public Objects
10) Define different types of attributes in Microstrategy desktop?
Answer: Compound Key Attribute
11) Describe Implicit Attribute?
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.
12) Explain what is Smart Metrics in Microstrategy?
Answer: Smart metric is referred when a compound metric is defined with other metric objects using arithmetic operations like sum M1/M2.
13) What is a joint child?
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.
14) What are attribute roles?
Answer: A user defines two attributes that have the same definition but play different roles in the business model. In this example, attribute Origin Airport and Destination Airport are defined using the same Lookup Table and Column (Airport_ID). Both attributes share the same forms, or information about them (Description, Location, etc.). In the fact table, however, a separate column exists for each of their roles (Origin_Airport_ID and Destination_Airport_ID).
15) What is fact degradation?
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.
16) What is filter?
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.
18) What is a Security filter?
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.
19) What is level prompt?
Answer: Level prompts enable you to specify the level of aggregation calculation of a metric
20) Can Threshold be applied on attributes? What are the different formatting types?
1. Font Type, Color
4. Text ……………….For more questions please contact us
For MicroStrategy Course Content Click Here