Grouping question

[ry1633]

I have two fields in my database layer as follows:

[table1].[RefID] 
[table2].[Product Code]

What I'd like to do is create a single field that shows a grouped listing of every Product Code for a single Ref ID, separated by commas like Code1, Code2, Code3

Can I do this in Framework Manager or is this something I should have my dba create for me at the db level?

[bdbits]

You could get it into FM, but the data item would get recreated/rerun every time you use it. So I would persist it into the database, i.e. have the dba create you a table.

[ry1633]

yeah it ended up being best for my dba to do it.  I could kinda get close with some joins,  but my dba was able to build it with the oracle listagg function into a table for me.  Much nicer solution :)

[dougp]

For those who have no control over the database...

This can be solved in Cognos Report Studio or Cognos Anaytics Reporting.  See the attached report spec.