Last Period as Default Member

#1

Hi,

I have a Time dimension(Year and Month) in which I want
to use the last period as Default Member. I know I can
use Tail to solve this, but I can't figure out how the
syntax should be.

Please help!

#2

Tail( Filter([Time].[Month].Members, NOT
IsEmpty(Time.CurrentMember)),1).Item(0)

should give you the last non empty month.

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

Quote:

Hi,

I have a Time dimension(Year and Month) in which I want
to use the last period as Default Member. I know I can
use Tail to solve this, but I can't figure out how the
syntax should be.

Please help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Last Period as Default Member

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Last Period as Default Member - 12-01-2003 , 07:54 AM

Re: Last Period as Default Member - 12-01-2003 , 08:16 AM