Named sets on time dimension

• Duncan Lawrence

  SSCrazy

  Points: 2047

  More actions

  August 2, 2013 at 10:06 am

  #147863

  Hi, I wonder if you can help

  I have created a Dynamic Named Set on the cube's Time dimension that returns the last six months

  Create Dynamic Set CurrentCube.[Last 6 Months]

  As {Tail([Time].[Fiscal Time].[Month].members,6)},

  Display_Folder = 'Named Sets';

  This works well unless I want to move the members returned down the timeline

  For example creating a view in the BIDS browser with Month (from my Time dimension hierarchy) on the rows and the set as a Filter Expression works fine as the measure selected is returned for each of the previous six months from the default member on the Time dimension

  If I try to move the 'six months view' back one month the query fails

  I've tried adding a second time attribute using just Months, but without success

  Any ideas would be gratefully received

  Thanks

  ---

  All the best,

  Duncan