Web Listing 1: Workaround 1 WITH SET MYSET AS HEAD([Date].[Date].[Date].MEMBERS, COUNT(MEASURES.ALLMEMBERS)-1) MEMBER MEASURES.MeasureUniqueName AS MEASURES.ALLMEMBERS.ITEM( RANK( [Date].[Date].CURRENTMEMBER, MYSET)-1).UNIQUENAME MEMBER MEASURES.MeasureDisplayName AS MEASURES.ALLMEMBERS.ITEM( RANK( [Date].[Date].CURRENTMEMBER, MYSET)-1).NAME SELECT {MEASURES.MeasureUniqueName, MEASURES.MeasureDisplayName} ON 0, MYSET ON 1 FROM [Adventure Works]