I have a requirement.
ODS has
MAT CHAR1 CHAR2
001 1 1
Cube has
MAT CHAR1 KF1
001 1 100 Kg
002 2 150 Kg
I put the query with the constant selection on CHAR2 in the RKF for KF1.
So Now it showing up like this
MAT CHAR1 CHAR2 RKF
001 1 1 100 Kg 1st rec
100 kg 2nd rec
001 2 # 150 kg 3rd rec
1st rec and 3rd rec are good, but dontt want the 2nd rec. that repeats the RKF value and mess up the result also.
If I put the filter on CHAR2 to excude #, It takes away the 3rd rec also. is there something I can do just to take away the 2nd rec.
I just need to show 1st rec and 3rd rec.
Thanks in advance