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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Report Limitations
- Thread starter mstruser
- Start date
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
Similar threads
- Locked
- Question
- Locked
- Question