Monday, August 13, 2012

How to search for SQL Pass-through functions and freeform sql reports?

For Free form SQL Reports:

  1. Log in to the project from Desktop and click the search button
  2. Go to Tools > Options > Enable "Show 'Contains' and 'Contained by ' tabs"
  3. Click OK > Go to "Contains" tab and select Logical Table for "Contains any object of this type" 
  4. Then go to Object Types tab and select Report as the object
  5. Click Find Now and all Freeform SQL Reports will be displayed.



For SQL Pass through function reports:

 You can look for the Applysimple function in MicroStrategy (object in Desktop and dearch for dependent objects)

1 comment:

  1. Fantastic article ! You havemade some very astute statements and I appreciate the the effort you have put into your writing. Its clear that you know what you are writing about. I am excited to read more of your sites content.

    http://www.sqlservermasters.com/

    ReplyDelete