Home Forums Data Warehousing Analysis Services MDX Query: Every end of each month on rows RE: MDX Query: Every end of each month on rows

  • October 24, 2013 at 3:23 pm

    #1661481

    If hierarchy is ...-Months-Days

    SELECT

    NON EMPTY { [Measures].[Sales Amount] } ON COLUMNS,

    NON EMPTY { filter([Date].[Calendar].[Date], [Date].[Calendar].currentmember is [Date].[Calendar].currentmember.parent.lastchild) } ON ROWS

    FROM [Adventure Works]

    If hierarchy is ...-Months-...-Days

    SELECT

    NON EMPTY { [Measures].[Sales Amount] } ON COLUMNS,

    NON EMPTY { filter([Date].[Calendar].[Date], [Date].[Calendar].currentmember is closingperiod([Date].[Calendar].[Date], [Date].[Calendar].currentmember.parent.parent....)) } ON ROWS

    FROM [Adventure Works]