Series: Subject: Topic:

MicroStrategy Interview Questions

Showing Questions 1 - 20 of 20 Questions
Sort by: 

What is advance reporting concept in micro strategy?

Asked By: vkrishna | Asked On: Dec 9th, 2013

Answered by: bhulakshmi on: May 26th, 2014

Advanced Reporting covers the more features about different types of metrics ,consolidations,custom groups,banding,pass through functions,drill maps,report data options etc. here in this you will ge...

What is the difference between view filter and report filter?

Asked By: sabari | Asked On: Jul 3rd, 2007

Answered by: mohit bhutani on: Mar 31st, 2014

Report Filter is handled at database level and view filter is handled by analytical engine. Report filter affects SQl and View filter doesn't affect

Answered by: Olex on: Jan 24th, 2013

Report filter limits data at query level when report executes, view filter slices data without running any sql queries.

What is the use of alias table?

Asked By: vkrishna | Asked On: Dec 9th, 2013

Answered by: praveen on: Jan 4th, 2014

Table alias are used for the purpose to resolve attribute roles.
Two attributes have the same name with same defination but playing different role in business system.
ex: origin airport id and destination aiport id having the same name with same meaning.
but their id are separated in table

Microstrategy filter question

Asked By: getmein2410 | Asked On: May 1st, 2011

1.What is a filter and their types? 2.Why do we use filters ? 3.What are the filtering options?

Answered by: praveen on: Nov 29th, 2013

Report filter: this filter applies a where clause in a sql query and sent to the datawarehouse to fetch the results. view filter: this filter applies after the excution of the report once the data is...

Answered by: sivaleela prasad on: May 30th, 2012

Filter is used to restrict the data retrieved by the report from the data warehouse. there are seven types 1)Report filter (center right) : report filter is before execution of the report include in ...

Attributes and facts

Asked By: kanchi101284 | Asked On: Oct 1st, 2008

Explain what is the difference between a fact and an attribute.

Answered by: Pritika on: Apr 11th, 2013

Attribute is descriptive part of database. like Name,City etc.
Fact is measure part of database. like sales,Commission etc.

Answered by: Mahipal on: Oct 19th, 2012

Attribute: An attribute is a schema object, an actual data holder of the organizations data. For example, customer name, city, Payment type etc.

Fact: Fact is also a schema object which is numeric most of the times. For example, revenue, profit, number of stores etc.

Security testing in microstrategy report

Asked By: sangram.nayak | Asked On: Nov 14th, 2012

Please guide me step by step to test security testing in a microstrategy report .

Test case format for microstrategy report test

Asked By: sangram.nayak | Asked On: Nov 14th, 2012

Hi , can anybody please share a sample test case format for microstrategy report .

In microstrategy, what are logical views used for?

Asked By: KPIZME | Asked On: May 21st, 2006

Answered by: Mahipal on: Oct 19th, 2012

Logical views in MSTR are created by the application architect and mainly intended to provide a level and combination of columns that does not exist in the ware house. These type of views makes developer life easier in situations where the existing data warehouse does not support the requirement.

Answered by: Vivek Jain on: Jan 17th, 2011

Logical views are the views which can create in microstrategy without any involvment of the DBA's. by using these view we can modal atttributes and fact according to requirement.

Significance of pass in SQL

Asked By: bforbi | Asked On: Sep 11th, 2008

What is the significance of 'number of pass' es in a SQL?

Answered by: Mahipal on: Oct 19th, 2012

Passes in SQL lets the developer understand the report from SQL stand point. The more the passes the more the excecution time and vice versa. SQL passes also lets the developer know the actual flow of...

Answered by: vidhya on: Feb 15th, 2012

Passes in mstr helps in testing the mstr query at the back end.
It gives clear idea on the calculations, levels.

From performance tuning point of view, the SQL pass option should be unchecked to avoid mstr from creating lot of temporary tables and thus reducing the performance of the report.

Absolute and standard filters

Asked By: Krazy | Asked On: Apr 16th, 2009

How are absolute and standard filters used in different scenarios? How do they differ from one another?

Answered by: Mahipal on: Oct 19th, 2012

Standard Filter: This type of filtering option let the report filter to be applied to that particular metric.

Absolute Filter: This type of filtering option let the report filter to be applied at the category level, if it has sub-categories on the template.

Answered by: ashu_eureka on: Jun 11th, 2009

Absolute and Standard Filters are used in Level Metrics (metrics which calculate at the specified attribute level rather than the default report level).While defining the level metric, the target attr...

Dashboard report in microstrategy

Asked By: anildey001 | Asked On: Jun 18th, 2012

How to create dashboard report in microstrategy, step by step?

Executing reports in UNIX os

Asked By: kishore.micro | Asked On: Mar 31st, 2010

What is the command for executing reports in UNIX environment?

Answered by: Vivek Jain on: Jan 17th, 2011

We can only execute reports by using MicroStrategy Desktop and MicroStrategy Web. as MicroStrategy Desktop is not supported in Unix OS, so that u need to deploy micrstrategy Web  on unix machine web server, from this interface you can execute microstrategy reports from any machine web browser.

Testing microstrategy reports

Asked By: k.doshi | Asked On: Nov 2nd, 2008

Name the different types of testing that can be done on microstrategy reports?

Answered by: Vivek Jain on: Jan 17th, 2011

1. Report Data testing against wareHouse2. Report formatting testing against requirement.3. Drilling and hyperlinks testing4. SQL generation Validation.5. Performance Testing.

Answered by: ashu_eureka on: Jun 11th, 2009

Along with the above mentioned testings, you can also have a. conditional formatting testing or threshold testing

Level prompt and value prompt

Asked By: unnathisharanya | Asked On: Jan 8th, 2011

Explain what are level prompt and value prompt.

Answered by: Vivek Jain on: Jan 17th, 2011

Level Prompt: This prompt allowed user to select metric calculation level.Value Prompt: This prompt allowed user to insert a value as input to the filter. by using we can insert text, numeric and data and time values in the filter object.

Compound metrics

Asked By: jrheath01 | Asked On: Jul 17th, 2008

How complex is compount metrics?

Answered by: tyssan4u on: Jun 28th, 2010

You cannot set the level, conditionality, or transformation for a compound metric

Answered by: tyssan4u on: Jun 28th, 2010

Compound Metric is based on arithmetic operators and non-group functions. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank.

Parent-child relationship

Asked By: san4u | Asked On: Aug 11th, 2008

What is the primary need for maintaining the parent-child relationship for attributes?

Answered by: ucontactkumar on: Dec 9th, 2008

If parent child relationship is not established it results in unwanted joins. As a result of this metric values are not retrieved properly due to improper joins. And alos it results in cross join which is deeply resource intensive and affects the performance.

Answered by: bforbi on: Sep 9th, 2008

The primary need for establishing a parent child relationship is to form a hierarchy of the attribute elements.Eg: Year has a child quater, quater has a child month.In this, we can establish one-many ...

Complex metrics

Asked By: jrheath01 | Asked On: Jul 17th, 2008

What are the different types of complex metrics within microstrategy and how do I know if candidates has experience with conditional metrics/filters?

How to trim SQL in microstrategy?

Asked By: bforbi | Asked On: May 21st, 2008

I got an error in microstrategy report ...I shared the SQL with my architect...He says he has trimmed the SQL and report is now working fine... Do any of you know how trimming a SQL is done?Thanks

Answered by: madhuchandra on: Jul 11th, 2008

HI,      Trimming the SQL is nothing but Optimizing the SQL by using Various VLDB Settings in the MSTR. i.e avoiding the cross join, removing multiple passes. Hope this as answered u r query.

What is the difference b/w microstrategy and cognos reporting tool

Asked By: Madhu | Asked On: Dec 4th, 2006

Answered by: wasim on: Oct 6th, 2007

Microstrategy: It is web based as well as desktop It has only one metadata repository which is centralaised repository.It doesnt support any cube dataset so we can have only current data from dataware...

Answered by: chandru on: May 24th, 2007

1. Micro stratgy is ROLAP & Cognos is MOLAP .         2.      Micro stratgy retrives data directly from data source, whearas  in Cognos it is stored in form of cubes & does`nt require database connectivity

In microstrategy, how can you direct the SQL generated to use a specifc table. I know of using applysimple, but there are other ways too...

Asked By: KPIZME | Asked On: May 21st, 2006

Answered by: Aashish on: Nov 21st, 2006

Use FACT ID in the metric

Answered by: jpg1dmg on: Sep 26th, 2006

I would use level metrics to force the SQL generation.Remove the Report Level from the metric(s)Add Leveling to the metric(s) for each of the Deminsions/Attributes in the Fact Table you are trying to ...



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.