Print Page - Adding a filter into a catalog

Title: Adding a filter into a catalog
Post by: richhol65 on 28 Apr 2015 09:15:03 AM

Hi

I want to add filters into a catalog for other users to be able to select

Is this possible as I am struggling to find the way to do this

This is Cognos Impromptu 7.5 with an Oracle database

Thanks

Rich

Title: Re: Adding a filter into a catalog
Post by: rlmarshall on 21 May 2015 04:37:01 PM

go to menu Catalog / Folder
click button Condition
enter a name "Only text with ABC"
goto the expression box and create filter like in report : txt_field = 'ABC'
save
create a report
goto filter tab
open "Catalog Columns"
find and select the condition "Only text with ABC" and click ok

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Impromptu => Topic started by: richhol65 on 28 Apr 2015 09:15:03 AM