Which has a greater effect on tidal forces?

The Moon has a greater effect on tides, on planet Earth, than the Sun. This is despite the fact that the gravitational attraction by the Sun is greater - the reason is that tidal forces depend on the CUBE of the distance.