Filtering a folder

[CArnold40]

 ??? While I've worked with Cognos 8 Framework Manager in the past, and know this is a pretty easy task in Cog 8, I'm having immense trouble trying to figure out how to do this in Cognos Impromptu:

--I have a table called 'Sales'.
--I created 3 aliases for this table called 'Sales1', 'Sales2', and 'Sales3'
--From here I want to have each alias filtered as such:
Sales1 will only return rows where Sales_Dept = '01'
Sales2 will only return rows where Sales_Dept = '02'
Sales3 will only return rows where Sales_Dept = '03'

I can't seem to figure out WHERE to do this. I go to Catalog>Folders and I see that the 3 new aliases I created are 3 new folders. I'd just like to filter each one of those folders, but I don't see any way to do that from there.

Can anyone point me in to where I can filter these table aliases (or folders)?

Any help would be greatly appreciated.

[ianderson]

You've got a couple of options:

1) Select User Profiles from the Catalog drop down menu, and then click the filters tab. You can apply a filter per user, so if you want it to apply for everyone, add the filters to the Creator class and it will filter down all user classes. Alternatively, add the filters to the required user classes individually.

2) When you join the tables to other tables, hard code the filter in the join using the 'definition' rather than the diagram. (so your join will be table1.fielda = sales1.fielda and sales1.sales_dept = '01')

Depends on whether you need outer joins or not in your reports. The first one will not work if you need an outer join as it will effectively add in a filter to the report, which is evaluated after the joins. The second one will allow you to still have outer joins as it's evaluated as part of the join, BUT if you don't include the linked table in the report, then the '01' 'filter' won't actually be applied and you'd still get everything.

Hope this helps.