Abhay

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

praveen

• Dec 22nd, 2015

By using dynamic aggregation also we can direct the SQL to use a particular table

Answer Question  Select Best Answer

Explain what is the difference between a Fact and an Attribute.

Jayadev

• May 6th, 2016

Attibute is a schema object which typically maps the descriptive data in the data warehouse

Pritika

• Apr 11th, 2013

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

Answer Question  Select Best Answer

Name the different types of testing that can be done on MicroStrategy Reports?

Chetana

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

souvik

• May 31st, 2018

Using selenium you can automate

Answer Question  Select Best Answer

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

nikhil

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

yanli

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

Answer Question  Select Best Answer

Shikha Sood

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

Suresh

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

Answer Question  Select Best Answer