All BMWs since about 1990 donít need auto box filter changes. As to oils Iíd always recommend using what the manufacture recommends, these are marked on the boxes itself. On a 1997 car you box may well be lifetime oil and doesnít require changing.
Iím a Brit and havenít heard of redline, I always use Castrol oils as theyíre recommended by most manufactures.
If your oils are changeable:
Auto box = Castrol dexron III Approx 5lt
Standard Diff = Castrol SAF OX Approx 1.5 Ė 2lt
Limited slip Diff = Castrol SAF XJ Approx 1.5 Ė 2lts
Or look at www.castrol.com