When do you use the Dative and when do you use the Accusative with the 'magic nine prepositions'?

The prepositions which can be followed by either Dative or Accusative are: oben, unter, neben, vor, hinter, zwischen, in, auf, an

When there is movement involved then Accusative is used, however, if there is no movement then the Dative is used.