Home Forums Data Warehousing Analysis Services Display all the Dates of a Week of the current date selected RE: Display all the Dates of a Week of the current date selected

  • When you say it's dynamic, is it consuming a parameter? If so you can use the StrToMember function to make that work, like so:

    STRTOMEMBER("[Date].[Calendar].[Date].&["+your parameter+"]").Parent.Children

    That did the Trick Sorry for the delay 🙂 it was working fine ..Thanks for the info bro