Time dependent Formula Variable

[Former Member]

In bex query designer i can define formula variable with default value. Ex: April discount rate. And i use this rate on calculating. But in May, this rate is changing and i have to change default value. I need a way to enter Monthly rates to use in my query.So when user select May, in the report calculation will used may rate or if the selected month is april , May rate will used in the calculation.

Looks for your help.

[Former Member · Accepted solution]

1. when you define a variable default value than you can't change it without mannual editing. So as per your scenario you can't use it

2. The best way to maintain this is to create another infoObject which has discount value for month

If it is not possible to edit the cube now then use a customer exit.

CASE i_step.

• Begin of I_STEP = 2

CASE i_vnam."name of ur customer exit

READ TABLE i_t_var_range INTO s_var_range.

v_month = s_var_range-low.

CASE v_month.

WHEN '01'."for jan

MOVE 'Put your discount rate' TO v_discount

WHEN '02'. "for feb

MOVE 'Put your discount rate' TO V_discount

.

.

.

WHEN '12'. "for December

MOVE 'Put your discount rate' TO V_discount

ENDCASE.

s_range-sign = 'I'.

s_range-opt = 'EQ'.

s_range-low = v_discount

APPEND s_range TO e_t_range.

Assign points if it is helpfull.

Thanks

Tripple k

Message was edited by:

Tripple k