Skip to Content
0
Former Member
Feb 27, 2007 at 08:55 AM

Query Design help

16 Views

Hello Experts,

I have a requirement, based on CHAR values I need to have an extra field which will have fixed values.

Like if CHAR values is in the range of 100 - 199 new field value should be AA

200 - 299 BB etc..

example

CHAR -


New(CHAR/KF)

100 -


AA

200 -


BB

300 -


CC

150 -


AA

250 -


BB

350 -


CC

I would like to know how it is possible at the query design (Bex), I know it can possible at the Cube design,,,, but want to understand is there a way to get this done through RKF, CKF, etc....

Thanks a lot in advance

VJ