I have a reporting requirement by using an ODS which has 4 fields. all are of characteristic info objects.
Out of those four 3 fields are given as key fields and one is as data field.
One object name and class name combination can have multiple characteristic names and each characteristic name will have one value.
The reporting should be as below.
objectname classname characteristicname1 charstic2 charstic3 etc
Obj1 class1 XXX abc 123
obj2 class2 yyy def 456
Please let me know how to do it?
Edited by: raj_kishore93 on Apr 6, 2009 3:19 PM