Difference between Conditional Formatting and Threshold
What is the difference between Conditional formatting and Threshold?
- Dec 1st, 2019
Conditional Formatting is the feature provided in documents where we can apply formatting (like thresholds in reports) to the following objects based on a attribute / metric in document.Objects on which conditional formatting can be applied.
Testing MicroStrategy Reports
Name the different types of testing that can be done on MicroStrategy Reports?
- Mar 8th, 2019
To validate your report data against data warehouse,please follow below some steps: 1.First write custom query(SQL) in database to get the required expected result 2.Compare no. of rows return by yo...
- May 31st, 2018
Using selenium you can automate
MSTR Performance Tuning
How to tune report in MSTR for better performance? What are General steps.
- May 24th, 2018
1. Avoid custom groups as they create multiple passes. 2. Use caching instead of live data. 3. Can use "partitioning" in case of very large table. 4. When multiple reports in a document are using same...
- Sep 16th, 2015
Several approaches can be used independently or mixed together.
a) Create a cube to improve performance
b) Pre-cache the report i.e. schedule the report
c) Ensure database level optimizations are happening like date based partition elimination and index usage
What is the use of alias table?
- Oct 25th, 2017
Alias name is nothing short name for a column we can fetch the entire row with the help of alias name. By using synonyms we can create permanent alias names.
- Jan 5th, 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
What is the difference between view filter and report filter?
- Oct 7th, 2017
View Filter: View filter works on the executed report as It is on Analytical engine level. It will on hit the database again to fetch the reuslt. It will only execute on the fetched report result set....
- Jan 13th, 2017
View filter can be applied after the metric calculations are done for a report. wherer as report filter is applied in the calculation itself i.e report filter is applied in the where clause of the Sql. view filter are local to the report and report filter can be used for other reports as well.
How do you unit test your reports in micro strategy ?
- Sep 5th, 2017
1) Need to validate the report SQL for any cross joins are occurred.
2) Need to validate the prompt value in the SQL (whether the prompt values are passed in the where condition)
3) Need to validate the row count and Metric value against to Db.
- Mar 12th, 2015
We need to pass some dummy values in the database , and need to check same values are loaded in the report or not and our conditions (Alerts,Filters etc..) are working and need to check the format of the report etc.. (nothing but we make sure report is running)
Level Prompt and Value Prompt
Explain What are Level Prompt and Value Prompt.
- Aug 30th, 2017
Level Prompt: Level Prompt is not but Object Prompt. user select objects to include in a report, such as attributes, metrics, or filters. Users select objects (such as attributes or metrics) that t...
- Jun 27th, 2017
Level prompt:at run time we want change the level dimensions we use level prompt.
Value prompt they are 4 types
Date and time,text, decimal,and numeric
Dashboard Report in MicroStrategy
How to Create Dashboard Report in MicroStrategy, Step by Step?
- Jan 13th, 2017
The main component of a dashboard is a data set. These data sets are nothing but the reports we create in microstrategy. Once we create these reports we can use it as a data set in the dash board. we can use N number of data sets in a dashboard
- Oct 25th, 2016
Dashboard is a type of Report service document which shows the data in a single view created using reports.. 1. Create a document 2. Add existing reports as datasets 3. Depending on the requirement us...
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...
- Oct 19th, 2016
For every table created in Microstrategy, there is a property called Logical Table Size. There is a formula to calculate the Logical Table size ( Level of the table in hierarchy / Total number of tab...
- Dec 22nd, 2015
By using dynamic aggregation also we can direct the SQL to use a particular table
What is the primary need for maintaining the Parent-Child relationship for attributes?
- Oct 19th, 2016
Consider Time as a Dimension. Now your data warehouse can have Facts which store data at various levels of this Time dimension. Eg: Hourly, Daily, Weekly, Monthly, Quarterly, Yearly. When you build a ...
- Aug 22nd, 2015
1. Defining Parent child relationship is important for proper joins between related dimensions &
2. Also it helps in creating proper (system) hierarchy.
Attributes and Facts
Explain what is the difference between a Fact and an Attribute.
- May 6th, 2016
Attibute is a schema object which typically maps the descriptive data in the data warehouse
- Apr 11th, 2013
Attribute is descriptive part of database. like Name,City etc.
Fact is measure part of database. like sales,Commission etc.
Get Requirement from Client
We got the requirement, how to do analysis? How to make ttd, document specification, how to analyse their business requirement?
MicroStrategy Filter Question
1.what is a filter and their types? 2.why do we use filters ? 3.what are the filtering options?
- Jul 28th, 2015
Report filters: Report filters are the conditions that accompany the report generating SQL statements. The report definitions have the filters as part of their definition. View Filters: View Filters ...
- Apr 22nd, 2015
Depends on the application scenarios, two types: report filter and view filter report filter is used to restrict data from db, filter expression can be based on attribute/metric. it can be attribute ...
Test Case Format for Microstrategy report Test
Can anybody Please share a sample test case format for microstrategy report .
- Apr 22nd, 2015
1. Try different level setting, i.e., report level/template level/metric level/attribute level to make sure the formats take the correct priority/inheritance
2. Template unit: test unit header/values, including font/color/background/alignment etc
3. Conditional formatting
MicroStrategy 9.3 vs 9.4 difference and also MicroStrategy vs cognos
What is Advance Reporting concept in micro strategy?
- 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...
Security Testing in Microstrategy Report
Please guide me step by step to test security testing in a Microstrategy Report .
In Microstrategy, what are Logical Views used for?
- 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.
- 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
What is the Significance of 'number of pass' es in a SQL?
- 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...
- 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
How are Absolute and Standard Filters used in different scenarios? How do they differ from one another?
- 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.
- 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...
MicroStrategy Interview Questions