If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Running fuzzy searches in Analysis Studio?  (Read 7778 times)


  • Guest
Running fuzzy searches in Analysis Studio?
« on: 18 Apr 2012 11:14:36 am »
Hi All - I'm putting togehter an Analysis Studio training, and one of the sections covers searching on long lists of members, i.e. clicking on By Dimension (X of Y) > Search (By Dimension) when a full list isn't displayed in the Insertable Objects pane.  I've noticed in playing around with the search that it only appears to do exact match searches.  I've tried using % * ? (with and without quotes around the search term), and I get 0 results back each time.

Is this function in Analysis Studio capable of doing fuzzy searches?  If it makes a difference, our databases are Oracle 11g.

Thank you!!

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,635
  • Forum Citizenship: +676/-10
  • Cognos Software Muppet
Re: Running fuzzy searches in Analysis Studio?
« Reply #1 on: 19 Apr 2012 06:49:46 am »

This is controlled by the options next to the Serch field - ie Starts With, Contains etc. You do not need to enter any kinds of wildcard characters. For example, if you enter a search term of "E" using the "Contains" behaviour, you will return all members with a letter E anywhere in the caption.