How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def

Assuming 3 records per grouped item:

1. Group on employee
2. Create a running count based on the skill field.
3. Create 3 calculated columns based on the count field.
Call them skill1, skill2, skill3:

if (count = 1) then (skill) else null
if (count = 2) then (skill) else null
if (count = 3) then (skill) else null

4. Create 3 more calculated columns using the maximum function. Call them maxskill1, maxskill2, maxskill3

maximum (skill1)
maximum (skill2)
maximum (skill3)

5. Group on employee on maxskill1 on maxskill2 on maxskill3
6. report employee axskill1 maxskill2 maxskill3

Interview Candidate
Oct 9th, 2005
4
8176

Cognos

Answer

Showing Answers 1 - 4 of 4 Answers

abc

Apr 9th, 2007

concatenate skills on the basis of employee

Cognos

Nov 1st, 2007

Concatenating is the best solution. Create a calculated field. Get the values related to Skill type 1 and concatenate them with required spaces inbetween.

1 a,b,c
2 d,e,f

prabakar.bi
Profile Answers by prabakar.bi

Mar 31st, 2009

I feel we can use the tool functionality to achieve this as follows.

1. Create a list report having employee column
2. Create a cross tab - contains emp in row and skill in column
3. Provide Master Detail relationship between 'emp' of list & CT
4. Hide emp of CT and format appropriately

You can see the result as

1 abc
2 def

cognos10consultant
Profile Answers by cognos10consultant

Feb 24th, 2012

To achieve this you have to create list first ...from the source tab add employee..after that click on toolbox tab add repeater as 2nd column...from the source tab add skill to the repeater...then we have to setup master detail relationship ...

(if you see query explorer there will be 2 queries..1 for list and 1 for repeater..click on query1 ..in the data items tab add the skill from source tab..same as like that click on query 2 ..in the data items tab add employee from source tab ...)
now we have to set master detail relation ship ....click on page1 ..select repeater column (skill) right click on it..
click on master detail relation ships..click on new link..set relation from query 1 to query 2 ..(employee to employee)now save the report and run it...we can get this o/p....