i have an Value type field say MSN in cube.there are only 5 value types are there.each value type is referring to some other field. lets for example..
XYZ1,XYZ2,XYZ3,XYZ4,XYZ5 are the value types in the value type field.And
ABC1,ABC2,ABC3,ABC4,ABC5 ARE THE coloumns or fields.
XYZ1 VALUE TYPE IS REFERRING TO ABC1 FIELD.
IN THE SAME ORDER...
my requirement is now is in variable screen i want to creat variable on value type.once user enters value type from that 5 value types the corresponding field should come and user can pick the values from the field.
VALUE TYPE(MSN) = XYZ1 then the corresponding field should come like..
ABC1 = -
, so that user can values from that coloumn of ABC1.
how to do this requirement...
thanks in advance....