2 Replies Latest reply on Jul 28, 2016 7:28 PM by Freddy Setiawan

    Create an MDX Set

    Kory Skistad

      How would you create an cube SET against Analysis Services 2008 in Tableau?  I  am trying to use this set:

       

      LastPeriods(12, StrToMember('[Date - Loan Origination].[Calendar].[Month].&[' + LEFT(Format(Now(), 'yyyyMM'),4) + ']&[' + Format(Now(), 'yyyyMM') + ']').Item(0).PrevMember)

       

      I can't get it to work in the Set builder in Tableau.  We are using Tableau 8.