To try to make my question a little better look at it like this:
MyTable:
Server / User / DateTime / Action
Row 1: miami1 / carlosj / 05-04-2010 11:23:31 / Exported source
Row 2: miami1 / davidc / 05-04-2010 11:24:41 / Ran DB import
Row 3: denver7/ carlosj / 05-04-2010 11:27:29 / Exported source
Row 4: miami / carlosj / 05-04-2010 11:41:21:21 / Ran DB import
I need to have all of the servers grouped in my report grouping in the header.
Under each grouping I need several totals for exampe: total count of action where action = Exported source
But I don’t want to write a separate query for each total for each server, I want the query based on action=exported source AND where server=whatever group we are on
Can Cognos know that I am on the server group miami and pull the count for action where = exported source?