Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Vincent Rainardi The Date Dimension in Analysis Services RE: The Date Dimension in Analysis Services

  • December 9, 2009 at 5:44 am

    #1089755

    duda (12/9/2009)

    ALTER CUBE CURRENTCUBE

    Update DImension [Date].[YearQuarterMonthDay],

    Default_Member = StrToMember("Tail(Filter([Date].[YearQuarterMonthDay].[Month Name And Year].members,

    Not IsEmpty([Date].[YearQuarterMonthDay].CurrentMember)), 1).Item(0)")

    This caused the other hierachy to only show measured data for only the current month.

    What you don't know won't hurt you but what you know will make you plan to know better