Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Limitations

Status
Not open for further replies.

mstruser

Programmer
Joined
Mar 14, 2004
Messages
2
Location
US
Hi all,
i am new to MSTR and in my recent interview i was asked the following question
" What are the Report Limitations in MSTR",

Please help me in knowing the answer....

thanks for the help


kris
 
I believe your interviewers were referring to Report Limit functionality in MicroStrategy reports. It's limit set on the report using Metrics and it is translated in to a Having clause in the SQL. For example, you can set the report limit with a Metric called Total Revenue > 5000. In the SQL, this limit will be translated in to a Having clause like 'having Sum(TotalRevAmt) > 5000. This can be set under Data/Report Data Options/Calculations/Report Limit.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top