Solved: Date filtering (dates until yesterday), once again

[_jl_]

Hi,

Again ran into problems, so help is needed.  >:(

I have a dimension which shows the date information for current week (see attachment). From source there's data showing up from the future, like '2013/06/29'. How can I set a filter to my report that only figures that are up to yesterday are shown?

To show only figures for yesterday, this thing works:
#'[Cube].[Time].[Time].[Day]->:[PC].[@MEMBER].['+timestampMask(_add_days($current_timestamp,-1),'yyyymmdd')+']'#

But to show all the weekly data until that day. Help?  :o

BR,
jl

[MFGF]

How about:

lastPeriods(7,#'[Cube].[Time].[Time].[Day]->:[PC].[@MEMBER].['+timestampMask(_add_days($current_timestamp,-1),'yyyymmdd')+']'#)

This will show you the selected member and the prior 6 members

Or alternatively:

periodsToDate([your day level], #'[Cube].[Time].[Time].[Day]->:[PC].[@MEMBER].['+timestampMask(_add_days($current_timestamp,-1),'yyyymmdd')+']'#)

This will show you the selected member and all previous members from the Day level

Cheers!

MF.

[_jl_]

Got both working. Thank You!  8)