InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 11:51:58 GMT20http://www.sqlservercentral.com/Forums/Topic821744-17-1.aspxI am really stuck, having spent an entire day trying to analyze what the &^&% is going wrong:I have a SSAS 2008 cube with a standard Time dimension (Dimensie Reporting Period.dim), which contains a hierarchy called "Tijd".As we would like to report on current month, week etc. I have created named sets using MDX to provide me with relative periods in my reports. So far so goo. All "current ...." named sets work fine.However when I try to create a "previous..." named set, there is a strange difference between the cube browser (which shows the right week), but excel is not showing any value at all.My Named set "current Week" has the following code:Tail(Filter([Dimensie Reporting Period].[Week].Members, Not IsEmpty([Dimensie Reporting Period].[Week].CurrentMember)),1)And my Named set "previous week" has the following code:LastPeriods([b]1[/b],[current_Week].Item(0).Item(0).PrevMember)When I look in the cube, the result is like this:Week 46, 2009 3245[b]But on excel, no values are reported![/b]When I change the code of the named set "previous week to:LastPeriods([b]2[/b],[current_Week].Item(0).Item(0).PrevMember)Then the cube shows:week 45, 2009 2318week 46, 2009 3245and excel showsweek 45,2009 2318Doe anyone know how (and why) this happens?? I tried all diferent scenario`s where i changed the lastperiod (to 1,0,-1) but the result stays the same...excel is not giving the previous week but it is showing 2 weeks before.Hope you can help me.Kind regards,jeroenThu, 19 Nov 2009 09:39:52 GMTjbreugelmans