Skip to Content
0
Former Member
Jan 26, 2011 at 09:09 PM

customer exit for formulae variable coding

24 Views

in ods i have data like

Postingday................value1........value2

1/26/10............70.................50

1/27/10............60.................48

............

12/30/10............120.................55

12/31/10............10.................52

now in the report for a cube i have to show data for 3 keyfigures

1 is amount and 2nd is (Amount x Value1) 3rd is (Amount/Value2)

now the value1 and value2 changes everyday depending on what the Date is...

so today on 1/26/11 the value1 is 70 and value2 is 50

so i have to write formulae variable which fetches the value1 and 2 for Todays date...

what should be the code for customer exit for formulae variable..

something like pseudocode below

when "zvar1"

FOR 0calday = today = PostingDay in ods table /bic/azpostingdte

Seleect Value1 ..

endfunction