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
Take the model.xml of the framework and scan this xml for :
filters><filterDefinition>
This should take you directly to the query subject involved.
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