Got a question regarding parameters.
I need to create a custom parameter. This parameter should contain about 4 values. Values are not in the database. Based on parameter selection, need to filter data.
Parameter : paramCategory
Values:
Cat A130, B89, T1, E2
Cat B2, F4, F5, F9
Cat D100, D390, V100
Cat S12, A12, B45, N89
Then in the record selection, I will need to filter records based on the parameter selection.
If paramCategory = 'Cat A130, B89, T1, E2' Then
EmployeeCat = 10
else if paramCategory = 'Cat B2, F4, F5, F9' Then
EmployeeCat = 13
else if paramCategory = 'Cat D100, D390, V100' Then
EmployeeCat = 15
else if paramCategory = 'Cat S12, A12, B45, N89' Then
EmployeeCat = 17
Would like to know whether the above is possible. I am sure it is. I am coming from crystal report background and know how to do it there.
Still learning Cognos and couldn't find any reading materials on this.
Any help is greatly appreciated.
------------------------------
Dn Pr
------------------------------