Summary Filter?

[jmills]

Hi All,

I have a need to show a report where I'd like to show all employees that didn't work on a holiday, indicated by a timecode HOL.

I've created a detail filter to exclude HOL, however it only filters the code from the results for the employee.  Ideally, I'd like to exclude the employee entirely, as if I were setting the focus for the Date Worked.

for example:
Employee A worked on Christmas day and is entitle to HOL pay, along with HOLWK (holiday worked)
Employee B worked the same day and has WRK (Work) on his profile.

When I run the report to show who didn't have HOL on Christmas Day, I would only expect Employee B to show on the report.  My current filter only removes the HOL record for employee A, however Employee A still shows on the report.

I've tried to change the aggregation rules of the filter to After, however it didn't appear to work.
I think that I need to set the focus of the filter to the Date, however am unfamiliar with how to do this in Reportnet.

How do I remove Emp B entirely from the results of the report?

[charon]

HI Jackal,

i would like to help out if i can, but to be honest i didnt understand your requirement/ situation. Would you mind to deliver some more information like
a) could you post a crosstab/ list, maybe the filter and
b) how the the fm data model modeliert concerning this attribut "hol"
c) what cognos version are you using?

In general, the way you have described to achieve your goal sounds reasonable, a detailfilter should work.
Im sry, but im better in analyzing visualizations, so a simple crosstab and some data rows would make it simpler for me to understand the situation youre in :)

ty and cheerz =)

[jmills]

Let me try and illustrate the issue:

EmployeeA     12/25/2013     WRK
EmployeeB     12/25/2013     HOLWK
EmployeeB     12/25/2013     HOL

I'd like to report on all people who don't have HOL on their profile within the date range chosen.  Therefore, my resultset should only come back with Employee A.  As it stands now, my filter only hides the HOL Row, however both Employees appear.

[MFGF]

How have you coded your filter currently?

MF.

[charon]

Hi Jackal,

what kind of data structure do you use, relational or dimensional (dmr or cube)?

[jmills]

The data source is relational, and the the filter looks like the following:

((?TCOperator? = 'Includes') AND [TimeCode] in (?Time Code?))
OR
((?TCOperator? = 'Excludes') AND [TiemCode] not in (?Time Code?))

I've created 2 prompts, one allowing the user to select a TimeCode, and an additional prompt to include/exclude the timecode from the report.  From what i'm able to tell, it's working properly, but it's filtering on the detailed data items.  Essentially, I'd like to set the focus the the employee or date.

Correct me if i'm wrong, however I think that if it were a number, vs text, I could use a For clause in the filter to define the scope (ie, sum(Dollars) FOR EMPID).  Is there a similar function when using text?

[yaculai]

Hey Jackal!
Not sure, it's the best solution, but I would add another query, get list of all employees, that ever worked on weekend, and then added a filter to your main query, to exclude all those employes.

[MFGF]

The data source is relational, and the the filter looks like the following:

((?TCOperator? = 'Includes') AND [TimeCode] in (?Time Code?))
OR
((?TCOperator? = 'Excludes') AND [TiemCode] not in (?Time Code?))

I've created 2 prompts, one allowing the user to select a TimeCode, and an additional prompt to include/exclude the timecode from the report.  From what i'm able to tell, it's working properly, but it's filtering on the detailed data items.  Essentially, I'd like to set the focus the the employee or date.

Correct me if i'm wrong, however I think that if it were a number, vs text, I could use a For clause in the filter to define the scope (ie, sum(Dollars) FOR EMPID).  Is there a similar function when using text?

It's not clear from this expression how you are filtering out anything to do with HOL in the profile column? You don't seem to be making any reference to it in your filter. At the moment if you select "Includes" in your TCOperator prompt and a date in your Time Code prompt, it appears you will get all rows for the selected date regardless of the value in Profile? Is this the entire expression?

Regards,

MF.

[jmills]

Apologies, HOL is a TimeCode.

If I group the Employee or the Date and apply a Group Filter to the Employee, I would have hoped it to work.  however the filter still applies to the detailed rows.