Tricky Micro Strategy Interview Preparation Guide
Download PDF

Micro Strategy job interview preparation guide. Number of Micro Strategy frequently asked questions(FAQs) asked in many Micro Strategy interviews

23 Micro Strategy Questions and Answers:

Table of Contents:

Tricky  Micro Strategy Job Interview Questions and Answers
Tricky Micro Strategy Job Interview Questions and Answers

1 :: In Microstrategy, how can you direct the sql generated to use a specifc table?

This can be acheived by decreasing the logical size of the
desire table in a such a way that it should be less than
other tables. AS Microstrategy will look the tale having
the least logical size and will make a join with that table.

2 :: In Microstrategy, what are Logical Views used for?

Logical view is just a table(logical table) but it is
create in deskop by writing our own SQL as per Our
requirement based on the physical tabes what we import from
our database.Once if it is create itacts as a physicaltable
as other phisical tables.

3 :: In Microstrategy, how can we direct the sql generated to use a specifc table?

we can use alias name of that table and change the logical
size of that alias table dnt modifies main table and use the
alias table..

4 :: Is that possible to Insert and Update a record in the Database through Microstrategy?

you can do so by ODBC test tool one of the component of
microstrategy through wich u can update delete or even alter
the table specification as per your need

5 :: What are the roles & responsibilities of microstrategy developer?

developer should know follow things:
i)how to create public objects(metrics,filters...ect)
ii)how to create shema objects(attributes,facts)
iii)how to trouble shoot reports/dashboards
Besides these if a candidate how to write and execute system
test case is well and good :)

6 :: How to optimize a report in microstrategy environment?

VLDB properties allow you to customize the SQL that
MicroStrategy generates, and determine how data is
processed by the Analytical Engine.

7 :: How to use value prompt and drag it on to report editor?

Eg: if you want to display top 5, 10 or 15 ranks.

1.Create a value prompt which will prompt the user to enter
the value( to display top n rankers)
2. create a filter to calculate rank and in value field
just drag and drop the prompt created above.

Prompt will be tagged to the filter and user will be
prompted during execution. Depending on the input provided
by the user top n rankers will be displayed

8 :: Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor?

You can do it without using value prompt with below steps.
Create a filter on day attribute qualified on ID operator >
and set value to resolve dynamically today – last 10 days.

9 :: Difference between standard, absolute and ignore condition in metrics?

Standard filtering allows the report filter to affect the

Absolute filtering raises the report filter to the level of
the target, so all subcategories in the categories included
on the report are added together.

Ignore filtering disregards filtering criteria based on the
attribute in the target and its related attributes (both
parents and children).

10 :: How to do performance tuning on reports?

For performance tuning there some areas where you need to look and work accordingly.

1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)

its better if go go in the same order....

11 :: How to increase logical sige of a table in microstrategy?

Go to tables in the MSTR .,select the table which u want
to increase the logical size dbl click on the table in the
table editor at the bottom you have option Logical size
there increase logical size and check preserve logical size
when updating schema

12 :: what is the difference between documents and dashboards in mstr?

explain the difference between documents and dashboards in mstr your self

13 :: What is the difference b/w the public object&schema object?

difference between schema objects n public objects is
schema objects can be created by using architect permission
and public objects can be created in desktop and by using
schema objects only we can create public objects. schema
obj ex is attributes, facts,hierachies, transpermations
public objects ex is metrics, filters,prompts and so on.

14 :: In document how to create metrics?

we can create only derived metrics in document
by click insert-> new metric

15 :: How to use consolidations in microstrategy report?

Consolidations :
Consolidations are used to Specify the data you want to view in your report,and it allows you to group attribute elements in New ways without changing the metadata and warehouse definitions.

When the client want to view profit values as per season wise for a particular region, in this situation season attribute not available in data so we can create the season consolidation as SEASON = {(SUMMER = FEB+MAR+APR+MAY)+ (SPRINT = JUNE+JULY+AUGUST+SEPTEMBER) + (WINTER = OCTOBER+NOVEMBER+DECEMBER+JAN) };

The above consolidation we can insert into report then it will displays the season wise profit values.....

16 :: How we can create the Intelligent cubes in Microstrategy?

Intelligent Cubes can be created in microstrategy in public
objects folder or in a particular user folder. We can create
a report and point the report to a cube or right click in a
folder and click on cube option to create a new cube. once
the cube is created, choose the report objects (attributes
and metrics) which is required and save the cube. once the
cube is saved and ran to check without any errors, one can
create multiple reports out of a cube. also, you can add new
attributes and metrics when ever necessary and those will be
readily available when you run the reports next time.

17 :: What is Element cache and give me one example?

Element cache:

Most recently used lookup table elements that are stored in
memory on the intelligence server or MSTR desktop machines.
So they can be retrieved more quickly.


When a user runs a Prompted report containing an attribute
element Prompt or a hierarchy prompt,an element is created...

18 :: How many project sources we can create in Metadata?

We can create number of project sources in Metadata.
But we can access one project source at a time in Microstrategy 8x.

19 :: What is view filter?

Apply specfic filter condition then after we can get the
report data set. it is olap. view filter main use viewing
purpose for custmoers.

20 :: What is static prompt in microstrategy?

Static prompted reports :-
when report is executed and than we saved that report than
it become static with those prompt.
it means when report executed again than it will not ask for
the promts which are present in it.

21 :: What are the nulls on microstrategy report and how to mask them?

1)If in this question we want to deal with null in MSTR
report than we have some display property in report data
option which we can change according to the replacement of
null values.
2)if we want to deal with sql geration of report than there
is an option of VLDB property according to you requirment u
can deal with sql query of report.

22 :: What are the advantages of dataset compare to fileset?

Dataset Contains attributes,metrics of the particular Report Only.
Fileset Contains total tables and information

23 :: Is it possible to see the data in dataset?

Open Warehouse Catelog from Architect.Select that particular
DSN.Then it will display available tables in that DSN.Select
the particular table and right click on that,select SHOW
SAMPLE DATA.then it will show sample data in that data set.
Micro Strategy Interview Questions and Answers
23 Micro Strategy Interview Questions and Answers