How do I develop
Good morning sir's.
How would I handle the following in BW?
I have an indicator (which can be either 'y' or 'n') that will be loaded from a flat file for a certain dealer code. This indicator will change on a monthly basis.
I also have a 'variable margin payout percentage' that will be loaded via a flat file (which changes once a year). I then have to produce a figure ie. "IF indicator is '= y' multiply with 'variable margin payout perc', IF 'indicator' is = 'n' then '0'.
(1) Should I handle the indicator data as master or transaction data
(2) How would I producee the figure required?
Your assistance will be appreciated.