Hi,

I'm attempting to create a named set that contains
surrogate keys for the last 7 days so users can select
this and just refresh their reports rather than having to
keep changing the dates selected.

I can't find any info on data/time range functions for
creating a named set?

I tried creating a function in SQL Server, using a view to
get the results of the function into the cube, but once
added to cube, it produced errors in the rebuild as there
were members in the fact table that were not in my new
dimension and if processed with errors then there were
only 7 days (as expected) in the entire cube! Could not
work out how I might get the results of my function in any
other way!

Any help really appreciated!
Thanks
Paul

StrToMember("[Period].["+format(now(),"YYYY")+"]")

Here's a lead. Let me know if you need any more tips.