Skip to Content
0
Former Member
May 10, 2010 at 04:58 PM

Removing # on constant selection query without filtering on #

40 Views

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

  1. 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