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

madhuchandra

 Profile Answers by madhuchandra Questions by madhuchandra

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

Answer Question  Select Best Answer

What is the command for executing reports in UNIX environment?

Vivek Jain

 Profile Answers by Vivek Jain Questions by Vivek Jain

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

Answer Question  Select Best Answer

Hi ,
Can anybody Please share a sample test case format for microstrategy report .

yanli

• 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

Answer Question  Select Best Answer

bhulakshmi

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

Answer Question  Select Best Answer

What is the difference between Conditional formatting and Threshold?

Aniket Vishwakarma

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

Answer Question  Select Best Answer

How to Create Dashboard Report in MicroStrategy, Step by Step?

Suresh

• 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

Jayadev

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

Answer Question  Select Best Answer

How complex is compount metrics?

tyssan4u

 Profile Answers by tyssan4u Questions by tyssan4u

• Jun 28th, 2010

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

tyssan4u

 Profile Answers by tyssan4u Questions by tyssan4u

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

Answer Question  Select Best Answer

How are Absolute and Standard Filters used in different scenarios? How do they differ from one another?

Mahipal

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

ashu_eureka

 Profile Answers by ashu_eureka Questions by ashu_eureka

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

Answer Question  Select Best Answer

ch nagaraju

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

praveen

• 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

Answer Question  Select Best Answer

sudhanspecial

 Profile Answers by sudhanspecial Questions by sudhanspecial

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

Senthil

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

Answer Question  Select Best Answer

How to tune report in MSTR for better performance? What are General steps.

Soumya Sharma

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

Aafia K

• 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
d) others....

Answer Question  Select Best Answer

wasim

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

chandru

• 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

Answer Question  Select Best Answer

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

Mahipal

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

vidhya

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

Answer Question  Select Best Answer

Mahipal

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

Vivek Jain

 Profile Answers by Vivek Jain Questions by Vivek Jain

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

Answer Question  Select Best Answer

What is the primary need for maintaining the Parent-Child relationship for attributes?

Abhay

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

anandvishnu2010

 Profile Answers by anandvishnu2010 Questions by anandvishnu2010

• Aug 22nd, 2015

Yes,
1. Defining Parent child relationship is important for proper joins between related dimensions &
2. Also it helps in creating proper (system) hierarchy.

Answer Question  Select Best Answer

Explain What are Level Prompt and Value Prompt.

Paramesh

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

Pavan

• 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

Answer Question  Select Best Answer

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