If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

filter question

Started by jmoore, 27 Jun 2007 08:52:17 AM

Previous topic - Next topic

jmoore

This is probably simple but I think I'm brain dead today. I modified one of the audit reports to show user logons for the past 7 days. It works fine. But now I want to narrow the results to certain users. I don't want to use a prompt since this will run weekly at midnight. Any ideas on a filter for this?

sir_jeroen

have you tried conditional filtering? With a condition like
Case when (?prompt? = '7 days') then ('....')
when (?prompt? = 'Weekly') then ('....')
else ('...')
end

jmoore

Thanks. I wrote a filter to handle the weekly part and it works fine using the add_days function. I'm looking to write one to handle the other piece. I'm using the audit package. I only want a subset of the users not all of them. I.e. monitor just say the group A users who logged in not the IT admins. I found a workaround by using prompts and specifying certain users in the report schedule. It would be nice to be able to write a filter for it.