transposing rows into columns(keyfigure)
I need to transposing row into columns, means 1row into 20 column i created generic data source and WO DSO and map the field. for Key Figure i'm using the formula IF( /BIC/ZATNAM = 'Z_COB', /BIC/ZATF, 0 ).
formula works fine but transformation creates multiple records instead of 1 records.
Please help me to fix this problem.
Parth Kulkarni replied
1. Use a standard DSO. With 'Mat_Doc_No' as key. So that you will have one line.
2. Merely writing if condition will suffice. This is peculiar case but we cant do NO UPDATE (RETURNCODE = 4) in the ABAP routine in BI 7.
whats happens, from source you get first record of Z_COB, you populate 123 while all others are blank.
in second record, Z_CAB will be populated but all other blank, even Z_COB will be overwritten.
Mat_Doc_num Z_COB Z_CAB Z_CAT Z-CAD
0111 # # # 765
Always last one will be loaded overwriting previous values.
So you will have to take all records in an internal table in Start Routine and read them in the update routine or end routine.
Also, if this is delta update, then you will have to append the previously loaded records for the Mat_Doc in DSO.