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:
1 :: Is it possible to see the data in dataset?
Yes
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.
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.
2 :: What are the advantages of dataset compare to fileset?
Dataset Contains attributes,metrics of the particular Report Only.
Fileset Contains total tables and information
Fileset Contains total tables and information
3 :: 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.
DATA>>REPORT DATA OPTION>>DISPLAY>>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.
report than we have some display property in report data
option which we can change according to the replacement of
null values.
DATA>>REPORT DATA OPTION>>DISPLAY>>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.
4 :: 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.
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.
5 :: 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.
report data set. it is olap. view filter main use viewing
purpose for custmoers.
6 :: 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.
But we can access one project source at a time in Microstrategy 8x.
7 :: 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.
Example:
When a user runs a Prompted report containing an attribute
element Prompt or a hierarchy prompt,an element is created...
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.
Example:
When a user runs a Prompted report containing an attribute
element Prompt or a hierarchy prompt,an element is created...
8 :: 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.
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.
9 :: 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.
Use:
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.....
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.
Use:
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.....
10 :: In document how to create metrics?
we can create only derived metrics in document
by click insert-> new metric
by click insert-> new metric