thanks to both of you...

i will check the calculated members.

i know i can add the dynamic time on sql (that one i actually know how to do lol), but the whole idea right now is to draw the report only from the cube using mdx and not using sql... :w00t:

i am planning to take a long weekend away from coding and next week start all over lol. 😀