Filter in Framework Manager

[itsan713]

Hello Everyone -

I'm just new with Cognos 8 and have some tickets working on. Our report uses a business unit field in the parameter page. However, this drop down button only shows several values (i.e 5 out of 12) from the list. This has the same scenario with all of our reports using business unit. So I suspect, there should be a filter somewhere in the Framework Manager. However I was not able to locate. Can someone please show me how to locate this filters? I need to modify them to include the new business unit.

Thanks everyone.
-Ian

[blom0344]

Take the model.xml of the framework and scan this xml for :

filters><filterDefinition>

This should take you directly to the query subject involved.

[wyconian]

Hi

I had a similar situation.  The query used to populate the drop down prompt list was coming from a table that only showed the values being used and not the values that hadn't been used. 

I would check the propt query to make sure it is retrieving all the possible values you are looking for.  If it's not try using a different query and even get a standalone query subject in fm that just holds the values you're looking for