Worked like a charm!! Thanks a lot for your assistance 🙂

Oh ok. I totally understood what you told. Although i have a question, with regards to the way week hierarchy in my datawarehouse how would you apply the date part...

Although the query executes successfully, the year and the week columns are not being displayed. They do come up when i specify the week range manually like in the first...

Thank you. That did eliminate the error.

Doesn't work.

I am getting an error message saying "The currentmember function expects a hierarchy expression for the 1-argument. A member expression was used"