I don't have an indepth explanation but simply said, its affects the AI on everything apart from the tactical battles, which includs diplomacy, money from the sky, p.o., aggressiveness etc.

Now one quirk about the campaign setting is that it is used to resolve autocalc battles (instead of taking the battle difficulty setting) which is a bug imo.