MicroStrategy Interview Questions

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

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.

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

Report Filter: This filter condition is directly thrown into SQL directly when we first run the report and fetches data according to the filter condition. This filter directly communicates with the Da...

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.

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.

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

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.

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.

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

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

Filters are of two types

1. View Filter
2. Report Filter.

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.

1. Report Data testing against wareHouse
2. Report formatting testing against requirement.
3. Drilling and hyperlinks testing
4. SQL generation Validation.
5. Performance Testing.

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

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.

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.

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

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.

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

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

Use FACT ID in the metric

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