Hi all,

Thanks for the many updates to this. I forgot to mention that the client is running SQL2000 (apologies fo that). I've managed to crack the MDX as follows:-

(ANCESTOR( [Financial...

Acn you provide the MDX? Sometime the IIF function slows things dow. Use case instaed;-)