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.
Is there any update on this? Were you able to find a workaround?
Did you managed to get it nailed?
I'm curious as well.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...