GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  MicroStrategy

 Print  |  
Question:  How to trim SQL in Microstrategy?

Answer: 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


July 07, 2008 02:09:31 #1
 madhuchandra   Member Since: September 2006    Total Comments: 2 

RE: How to trim SQL in Microstrategy?
 

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.

     

 

Back To Question