Microstrategy Interview Questions

Concepts of Microstrategy:

1) Difference between View Filter,Report Filter and Report Limit.

2).Difference between consolidation and custom groups.

3)What are the level metrics and conditional metrics and their use?

4)What are the VLDB properties ? What properties you have used?

5)Parent Child Relationship of attributes and its use?

6)Report execution flow?

7)Task of the analytical engine.

8)Prompts types and uses.

9)Pass Through functions.

10)Security Role And Security Filter.

11)Questions Related to document formatting like grouping ,sorting,linking,thresholds etc.

12)Questions related to Microstrategy Admin like database instance,scheduling,users etc.

13)What is compound key attribute?

14)Intelligent cube ?

15)What is the logical size of a table and how it is calculated?

16)why we use heterogeneous mapping in MSTR?

17) What is a fact less fact table? And Why we use?

SQL And Data warehouse: 

a)joins in SQL like outer join ,inner join etc

b)Normalization

c)Difference between Snowflake and Star Schema

d)Indexing and its importance

e)Different functions of SQL like coalesce

f)How to find the second highest row.

Business Knowledge: 

a) What is Business Intelligence?

b) Characteristics of a project ?

c) Best Technology to use for the project.

d) What improvement you want in Microstrategy tool.

These questions are asked to check one's interest and in-depth knowledge of the subject and platform on which he/she is working