variable problem

[Former Member]

Hi experts..

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

XYZ2-ABC2,

XYZ3-ABC3,

XYZ4-ABC4,

XYZ5-ABC5.

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.

for EX:

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

[Former Member · Accepted solution]

Hi Kundan,

Change your data modal to char modal from kyf modal.

map abc1, abc2, abc3, abc4,abc5 to a kyf abcd in transformations.

in report create selection using kyf abcd & Value type char with varaiable.

based on your variable value it will pick corrsoponding kyf value.

hope this will help you.

Thanks,

Vijay.