question

Hi, We are migrating a SSAS database from 2005 to 2012 and everything went smooth until we found some changes in behaviour between the versions. The MDX question below returns different result from the two SSAS Servers. WITH MEMBER [Butik].[Ägare].[XL_QZX] AS 'Aggregate({[Butik].[Ägare].&[S],[Butik].[Ägare].&[H],[Butik].[Ägare].&[D]})' SELECT NON EMPTY CrossJoin( {[Datum].[Datum].[Vecka].&[201326],[Datum].[Datum].[Vecka].&[201226] }, {[Measures].[Utfall],[Measures].[Utfall YTD]} ) ON COLUMNS , NON EMPTY { [Butik].[Butik].[Land].&[S].&[N].&[3464-000 Boden], [Butik].[Butik].[Land].&[S].&[N].&[3481-000 Avesta], [Butik].[Butik].[Land].&[S].&[N].&[3377-000 Falun]} ON ROWS FROM [Försäljning] WHERE ([Butik].[Land].&[S],[Visa valuta].[Valutanamn].&[Svenska kronor],[Butik].[Ägare].[XL_QZX]) From SQL 2005 SP2: ![alt text][1] From SQL 2012 (RTM - will upgrade soon): ![alt text][2] The line marked "Boden" does not have any figures for "Utfall" for the selected week (Vecka) in 2013, but it *has* figures earlier this year so I expected a YTD measure. Why is it missing in the result from SSAS 2012? Can I set any configuration option to retain backward compatibility if it's by design? I've tried to change the configuration option NamedSetShallowExistsMode to 2 and restared SSAS (according to a breaking change in SSAS 2008), but it didn't help. The expression for measure "Utfall YTD" is: SUM(IIF([Datum].[Månad].CurrentMember IS [Datum].[Månad].[All], YTD([Datum].[Datum].Currentmember), LASTPERIODS( CINT(MID([Datum].[Månad].CurrentMember.UNIQUENAME, 24, 2)), [Datum].[Månad].CurrentMember )), [Measures].[Utfall]) Best regards, Martin Höglund [1]: /storage/temp/994-\ssas+2005+result.png [2]: /storage/temp/995-\ssas+2012+result.png