GeekInterview.com
Series: Subject: Topic:

MicroStrategy Interview Questions

Showing Questions 1 - 20 of 21 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Microstrategy differences

Asked By: spyram | Asked On: Oct 25th, 2014

Microstrategy 9.3 vs 9.4 difference and also microstrategy vs cognos

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: praveen on: Aug 20th, 2014

Purpose of maintaining parent and child relationship is to establish joins and to make sql performance good

Answered by: Shikha Sood on: Aug 15th, 2014

If parent child relationshipship is not defined properly then it can throw fact level errors if fact is stored at lower level attribute and that attribute is not defined or joined by parent child relationship....

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: praveen on: Aug 20th, 2014

Use fact id in the metric and give filtering=none and grouping =none

Answered by: Shikha Sood on: Aug 15th, 2014

Changing the logical size of the table is not considered as a good practice as it can degrade the performance of your reporting...
So, its better to use FACT Id so or adding the lower level atrribute in the report object....

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: Shiva on: Aug 7th, 2014

Attribute is a characteristic feature of an column/ columns of the database.
Whereas Measure is the value of the attribute.

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...

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

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.

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.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

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.