Thanks Martin - for a DW with 5 Million rows, SSAS seems to be handling it quite well. So far, no performance issues noticed (argh - i think i just jinxed it).

Thanks for all your help. You're right..users' requests trumps the more sensible cube logic - in this case at least.