I can't believe I'm having trouble with this, but I am.
I need to create a custom member in my time dimension that aways returns the
most recent date in the cube. I thought that something like
'closingperiod(day)' would work, but I get no results. My time dimension has
levels of year, quarter, month, and day.
TIA, Dave

closingperiod is not the right formula.

try something like:

tail(nonempty(time.day.members, measures.[any measure]),1).item(0)

nonempty(time.day.members, measures.[any measure]) return the days with
existing values
Tail return the last X members from a set (the latest in our case)
because this produce a set the .Item(0) is required to get 1 member only

I have not tested this formula (I have no server in front of me)
but there is other formula like this one to do the job.

good luck!


"KitenutDave" <KitenutDave (AT) discussions (DOT) microsoft.com> wrote

this is what we use

{Tail(Filter([Date].[Date].[Day].Members, Not
IsEmpty(([Date].[Date].CurrentMember))), 1)};



"Jeje" <willgart (AT) hotmail (DOT) com> wrote