query regarding selection variables

[Former Member]

Hi,

how can i create a selection variable on a key figure?

i have a keyfigure called revenue and report should ask for a value of this whenever report is run. any inputs?

Thanks,

Vijaya

[Former Member]

Thanks

[Former Member]

Vijaya,

If you only want to retrieve records based on the value of a key figure, what you can do is setup a Condition based on your Key Figure.

Your condition can be based on hard coded values or it can be based on a variable input from the user. If you condition is set to Greater than the value input and the user enters 10,000 then you will only see records greater than 10,000.

Is this what you mean?

Regards

Gill

[Former Member]

Hi

You mean to say when the user enters a value for revenue he should fetch all the relevant records with the value revenue....entered by the user

If the understanding is correct, i think you can map the keyfigure to a newly created charecteristics in the cube and in the update rule routine you can write a code to map th kf with the char and use a selection variable in your reports

Regards

N Ganesh