lots of confusion :( formula variable with replacement path

[Former Member]

hi gurus,

            can't able to understand this concept from days many explained me but not upto the mark can anyone please explain me in a very detailed manner so dat it will be very useful for me

thnaks in advance

venkateshveera

[ravi_chandra3 · Accepted solution]

Hi

Let say i have master data table

MID      DISCOUNT

==================

M100      10%

M200       20%

M300      30%

and another transaction data table;

MID      AMOUNT

======================

M100       10000

M200       20000

M300       30000

now i would like to create a report on infocube, and  i have to create a formula in the bex query and in that formula i need to deduct the discount from the actual amount like the report should be as shown below

MID     AMOUNT       ACTUAL AMOUNT

===================================

M100     10000           9000

M200      20000          18000

M300      30000           27000

Now to achieve this ACTUAL AMOUNT FORMULA , you have to create the formula variable with replacment path as attribute on MID characteristic and select the attribute as discount.

Hope you got it,

Regards,

RaviChandra