Filters in Framework Manager - ease the frustration
Creating a filter in IBM Cognos is normally straight forward. Most people are familiar with creating them in Report Studio and Query Studio. For more advanced folks, you might even know how to create a slicer in Analysis Studio that works just like a filter but for dimensionally modeled relational (DMR) data. However, if you have ever tried to create filters in Framework Manager you might be ready to pull your hair out and jump off a tall building. Okay, maybe a short building, but you are definitely losing your hair over it.

Well, you are not really stuck because you Google “How to make filters in Framework Manager” and you arrived here … ok, happy dance - someone is going to give me the steps and end my madness.
1. What you filter on must be in the query subject – this will ensure that the parameterized filter will show up no matter what your end user picks from the query subject.
2. You must use question mark enclosures – the syntax looks like this [query subject item] = ?Parameter1?
3. You must use the prompt info – on the item that you are filtering by, you will set the prompt info to be a drop down, date, search type … etc. You will also input the display values and the use values.
4. Publish – publish the package
This little post has been a service announcement sponsored by a frustrated framework manager modeler. You can simply pay thanks by sharing this post with someone else that might be standing on the ledge of a short building.
If you need help navigating framework manager or training on more advanced techniques please contact us at services@lodestarsolutions.com
If you like this blog on filters in framework manager, please check out this blog on IBM Cognos Report Studio: Bursting Cognos Reports by clicking here.