Cognos Analytics

Expand all | Collapse all

Filter "Include" rather than "Beginning With"

  • 1.  Filter "Include" rather than "Beginning With"

    Posted Fri July 19, 2019 11:51 AM

    Hi folks,

    I work with a large data set of roadways and have had this consistent issue since upgrading to 11. 

    When searching for a specific roadway, I'll use Oakfield Park Road for example, if I search in "Oak", I should be able to search for any entry that includes OAK in the field. However, after digging, I found out there was an entry submitted to the database that said "Parking Lot - Oakfield Park Road" that was completely missed, as it only searched the entries that may have began with Oak instead of included Oak. 

    Prior versions would allow me to search for "beginning with" OR "included" but now searching I don't have that option, just to include or exclude the selected terms. 

    Is there any way to restore the previous function that I'm not aware of? I'm certainly not a power user of the application.

    Scrolled to bottom, no P for Parking Lot


    ------------------------------
    Devon Connellan
    ------------------------------


  • 2.  RE: Filter "Include" rather than "Beginning With"

    Posted Fri July 19, 2019 12:29 PM
    Edited by DENNY NAREZNY Fri July 19, 2019 12:44 PM
      |   view attached

    @Devon Connellan These advanced search features are now available with Cognos Analytics 11.1.3. Details on this new feature can be found in the following link -
    https://community.ibm.com/community/user/businessanalytics/blogs/rachel-su/2019/07/10/important-updates-to-1113-reporting?CommunityKey=6b10df83-0b3c-4f92-8b1f-1fd80d0e7e58&tab=recentcommunityblogsdashboard


    I've attached a screen shot of the new filter options.

    Also, here is the link to download 11.1.3.

    https://www-01.ibm.com/support/docview.wss?uid=ibm10885198



    ------------------------------
    DENNY NAREZNY
    ------------------------------